Forum - Purchase Ledger On Account

Purchase Ledger On Account

Alan

2015-11-11

What would be the reason that when I run my Purchase Ledger report and select Only On Account, the Total of the report and the On Acc. total differ.
Shouldn't these two match every time?

Paul Timms

2015-11-12

Hi Alan

Do you have any foreign currency on account payments? Does it make a difference running the report in Base Currency or Currency?

Regards

Paul

Alan

2015-11-18

Hi Paul, yes, there are foreign currency on account payments,
The difference is the same when running the report in Base Currency or Currency however.

Best regards,
Alan

Paul Timms

2015-11-20

Hi Alan

Which version is this? And do the On Account receipts have prepayment numbers?

Regards

Paul

Alan

2015-11-25

version 6.32011-09-07

When I run the purchase ledger report with the show pre pay nos option ticked, pre pay numbers show. However, for some suppliers, the total of all the pre pay number amounts added up does not match the total balance for that supplier.

Oddly though, this amount difference does not equate to the same amount that the Total of the report and the On Acc. total differ by!

Paul Timms

2015-11-26

Hi Alan

Earlier versions did have issues with foreign currency on account/prepayments. If you run the Purchase Ledger report with function Rate Differences, does it show you any differences? Also, what does the Prepayment History P/L report show in base currency and currency?

Solving these currency issues can be quite hard. Sometimes upgrading to the latest version will fix some of the issues but maybe not all of them. It's probably best not to try to fix them in 6.3 because you might find your fix doubles up when upgrading.

Regards

Paul

Back to the list