Get a list of open and recent invoices from a web service

(0) Share

Report

Posted on by Community Member

Hi,

I want to be able to get a list of recent (defined by a date range) and/or open invoices from Navision. IS the Sales Invoice page the correct one?

If not which would be?

Any idea how can I set the filter to get the recent (regardless of their paid status) ?

Thank in advance,

Ignacio

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you want to know what invoices have been shipped and invoiced then you need to look at posted sales invoice (132) or Posted Sales Invoices (143), which is basically a result of sales order is posted and invoiced.

In Navision you can also create sales invoice directly which is basically a charge to the customer and once you post that even end up in Posted Sales Invoice. These open invoices which are not yet invoiced then you can get that information from Page 9301 or Page 43 (Sales Invoice)

In both scenarios you have posting date/Document Date which you an use to filter it.

Below is the link showing an example how to filter on fields.

msdn.microsoft.com/.../dd355316.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks again Suresh for your help,

When I refer to "open invoices" I meant invoices that are already sent to the client, but not paid yet, not sure if this detail change something in your answer.

Thank,

Ignacio

Was this reply helpful? Yes No
Suggested answer

Daniele Rebussi 2,480 on at

Like (0)

Report
Copy link

Link copied!

If you want to get the list of invoices not paid you can look at Cust. Ledger Entry table, filtering by Document Type = Invoice, Open = Yes and by Posting Date (based on what you consider as recent).

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report
Copy link

Link copied!

In this case you need to expose Customer Ledger Entries Page (25). In that you can filter the Document Type to Invoice and Set the sorting order to Posting Date.

By doing that you will be able to get the posted invoices as the order of the posting date.

Then check the value of the Remaining Amount column. If the remaining amount is not equal to zero that means customer has still not paid for the invoice. (Your account department should apply the payment).

How to set the sorting order of a page: tharangac-dynamicsnav.blogspot.com/.../how-to-setchange-default-sorting-order.html

Was this reply helpful? Yes No