[Question] Pastel Xpress V14 Issue

[Alandt]

Hi all!

I hope that somebody will be able to assist me.

I am using Pastel Xpress V14 to Invoice my clients.

Earlier today a client requested a statement from the beginning of this financial year's till the end September.

I went to the client's account, entered the dates and then I saw that there was an amount due at 90 days.

I investigated and noticed that on the 27/07 the payment was made, even with the reference to my cashbook, but there is no amount credited to the statement.

However, this is a strictly COD Client, and I double checked (even on the bankstatement recons) that the payment has been made.

Now when I go the Due Invoices, there comes and invoice up with the same amount. I checked the cashbook's history, and the payment for the invoice is there.

I then printed out a detailed ledger, and everything is 100% there.

If you need more information please feel free to contact me.

This is the only account that has that "issue".

Thank you in advance.

[Alandt]

Sorry if this thread was created in the wrong category. Please move it to the appropriate category should it be necessary.

[Mike C]

Hi Alandt - when you entered the payment in the cash book did you enter it under G (General Ledger) or did you match it to his invoice under C (Customer)?

If the first scenario (G) you will need to do a Journal entry under Customer Journals.

If the second scenario (C) it could be that you have to match the payment via "Match Open Item"

[Alandt]

Morning Mike!

Thank you for the reply.

The invoice was matched as a Customer, thus C.

I double checked on the transactions for that month and it was matched to the invoice.

When I go to match Open Item, the invoice is there and the balance is R 0.00 of the invoice. But when I go and have a look at my unpaid invoices, I see that amount due at 90 Days.

I really don't know why this is happening.

[Neville Bailey]

Run the customer age analysis, but only for that customer, and tick the box named "Print Transactions".

Do you see a line item "O/I Difference" at the end of the report?

[Alandt]

Hi Neville,

I have done as requested, and yes, there is a line O/I Difference at the end of the report, with the exact amount that is "due".

[Neville Bailey]

OK, that means that you have some data corruption in the Open Item table.

Drop me an email and we can arrange a TeamViewer session so that I can fix it with my database editor.

[Alandt]

Thank you! Will do as soon as I can.

Have a wonderful day!