NAV version 5.0SP1 - The balance shown by the AP Aged Report (native, Aged as of 12/31/13 by Document Date) for a particular project code does not match with the GL account balance for the same date (..12/31/13) for the same project code. I tried running the AP Aged report by both Trans Date and Document Date and the result is the same.
There are no entries posted directly to the GL AP account without going through the AP sub ledger. There are some Vendor ledger entries where the document date is in 2014 with the posting date in 2013. I understand that could cause a difference but even after accounting for those, there is still a big difference. Is there any other factor that could cause this?
Check if all your vendors are set-up with a project code dimension. There might be some vendors without a project dimension assigned.
Alternately, try printing the aged AP report without any filter on the project code field and reconcile it with your AP control account in the GL? This way you can verify if the missing dimension on vendor account is causing the difference.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics