Aged Accounts Payable and Vendor Trial balance do not tally

Davedave

Hi guys,

Was wondering if you all have faced this problem I am having before?

a) Use purchase journal to create one invoice USD176 @ MYR668.89 and post on 01/09/2006

b) User payment journal to create one payment USD76 @ MYR280.74 and post on 25/09/2006

c) Apply the payment to invoice in Vendor Ledger Entry and post on 06/10/2006

d) Print Aged Account Payable and Vendor Trial Balance as at 30/09/2006. Ending Balance for these two reports for the same vendor and date do not tally.

From an applications point of view, I think what I'm doing is correct but then again I may be wrong. Maybe there is a hot fix somewhere out there for this?

Thanks
David

ara3n

What version are you running? there is a fix for sp1 in 4.0.

Davedave

Hi,

Sorry I forgot to include the version number.

I am running on Navision 3.7 MY

Thanks
David

ara3n

I ran your entries in 4.0 sp2 and the numbers did match.
I ran the aging report as of 30/9/06 based on trans date. The balance due was 258.36 in the aging report and ending balance in vendor trial balance was -258.36.

What numbers are you getting for the two reports?