Aged Creditors including later payment

(0) Share

Report

Posted on by Community Member

Hello,

We have recently transferred from Sage 50 to Microsoft NAV. To create our payment runs we used to run a Aged Creditors report excluding later payments to give us the status on supplier accounts.

Now we have moved over to NAV we cannot seem to recreate the same report. The "Aged Accounts Payable" report give us the Aged Creditors excluding later payments. We have tried running this report with different combinations of Posting and Document date with no success.

The suggested payments in NAV is good but if you have payments on account it does not highlight any invoices for payment. This is not always true for us, SAGE used to show us the account activity (outstanding invoices and payments on account (unmatched).

Has anyone else come up against this one and how did you work around it.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Maneesha 5,891 on at

Like (0)

Report

Dear Horizon ,

Please refer the link

https://msdn.microsoft.com/en-us/library/dn948192(v=nav.90).aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Maneesha,

Thank you for the response. The article seems to refer to "posting date on adjustment value entry". I am looking for a report relating to Vendors and Customers. Apologies if I have missed anything.

If you have any further advice it is appreciated.

Thanks

Chris

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

Is this a standard report you are checking ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We cannot get the standard "aged accounts payable" report to reproduce the equivalent of SAGE's Aged Creditors excluding later payments

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hello

How data has been transferred from Sage50 to NAV ? Is it just cumulative opening balance or It is with Open Invoices and payment ?

Was this reply helpful? Yes No