Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Wiser]

When running the Reconcile AP to GL report (10101), it appears to NOT pick up purchase lines associated with return purchase orders that have been ‘shipped’ but not invoiced.  Even though the GL transaction posts to the same accounts as PO receipts, the return shipments are not picked up in the report, thereby resulting in a difference between the report and the G/L balance.  Has anyone else run across this and might have a solution?

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————

[Ken Elliott]

We handle our returns a different way, so we do not see this issue. However, having open payables in foreign currency also creates a variance because it reports the open balances using the latest exchange rates rather than the exchange rates from when it posted to the G/L.

——————————
Ken Elliott
Billy Graham Evangelistic Association
Charlotte NC
——————————
——————————————-