Customer Statements - Pastel Xpress V11

[FountainHillGH]

I run a guesthouse that uses a reservation/property management system not integrated into Pastel. Instead of recapturing each individual invoice generated by the reservation system to Pastel Xpress V11 (yes... I know its old and outdated, but it works for us!), I have generated a CSV file from the reservation system and imported it through a sales journal to create the guest "invoices" on Pastel. All payments from guests are then allocated against these "invoices" through the various cashbooks.

My problem is for year end when I need to generate an "outstanding customers" report/statement. It seems that if I have used the sales journal function, the "invoices" I have created do not pull through to the "invoices due" report and I would have to manually reconcile on a customer statement.

Does anyone have any suggestions as to how I can generate a list of outstanding customer invoices on Pastel to reconcile with our reservation system?

[Neville Bailey]

If you have set up your customer accounts for Open Item processing, rather than as Balance Forward processing, you could run an Age Analysis report, with the "Print Transactions" and "Show OI Unmatched Only" options ticked.

[FountainHillGH]

Neville, you are a legend. Thank you so much!!!

[Neville Bailey]

Neville, you are a legend. Thank you so much!!!

You're welcome!

Now read my post here, and do something about your old version of Pastel!