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?