Is there any way to print an open payables report in AP printing amounts in both source and home?

Sheldon

Hi Sheldon,

The only options for printing the Open Payables report when Multi-currency is enabled is either home or source, not both.

Can you tell me how I can balance my US payables?

I receive invoices in different periods so they will have different exchange rates.

Sheldon

When you print the Home currency format, this will print the home currency equivalent for USD or other non-home currency vendors. There is a filter on the report screen so that you can print the report for only US customers, if desired. 'Currency' is a selectable sort/filter option for this report.

What information are you wanting to see on the report that either the source or home formats don't provide (except the fact that both aren't on the same report)?

We provide a printed open payables to support our payables trial balance amount every month end. If it does not print both currencies on a report the paperwork cannot support the balance on the account because you cannot tell what exchange rate was used on each invoice.

Hello Sheldon Dyck,

If you print an open payables report in home currency, and its total matches the total reported in the AP control account on the Trial Balance, does that not support the GL balance?