5
Hello,
How do I reconcile a vendor against an external statement of account?
an example:
as pr maj 31 I run a statement in NAV based on all open invoices. I receive a statement from the vendor June 10 with all non paid invoices as per maj 31. June, 5th I make a payment and now i'm in trouble as my statement in NAV has changed...
At the moment I do V-Lookup against the statement and against the payment
Can anyone explain an easier way to reconcile with this issue?
Hello joejoe,
Thank you for posting on the Microsoft Dynamics NAV Forum.
Have you tried backdating the Vendor Detailed Trial Balance? That should show only Payments and Invoices through total balance through the date established. For example, with a date of 01/01/2020..05/31/2020, the Vendor Detailed Trial Balance would show the activity including the starting balance coming into 2020 from 12/31/2019 up through 05/31/2020. This would exlcude the Payments from June 2020.
I hope this helps you move forward.
Best Regards,
Tom
Moved to the Dynamics NAV forum. You seem to use NAV and not Dynamics 365 Finance.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (