Skip to Content
0
Former Member
May 02, 2017 at 08:02 AM

Aging List for Payables vs. Trade Creditor G/L Balances SAP ByDesign

611 Views

Hi all,

I've had a couple of SAP ByD customers with multi currency payable items (as most companies will) who expect their Aging List for Payables report to reconcile to their Trade Creditor G/L Balances (Trail Balance) when comparing company currency for the same period.

There's a help document that explains this issue and suggests adapting the Trail Balance report by adding the line item currency. This shows the Trade creditors by currency but does not help in terms of reconciling the two reports to each other.

As I understand it, this is because the report Aging List Payables is based on the exchange rate of the day the documents were posted.

Does anyone know why the report was created this way, I'd love to know the thinking behind why the Aging List Payables has been created this way? Also, has anyone found a way to get an Aging Payables report that is comparable to the Trial Balance?

Thanks!