Business Central / NAV UG
Business Central / NAV UG
Organizer:
- Organized by
-
-
Purchase Order reporting
-
Purchase Order reporting
Hello – I am looking for a Business Central Purchasing report that will show me the status and details (what has been received and invoiced – all lines) of all open PO’s. There is the Purchase Order Status report but once there is no outstanding quantity(all receipts are done) the PO line is no longer on the report. Is there an out-of-box report for the Purchase Order Lines?
Regards -
4 Replies
-
If you are using Inventory there is an Inventory Purchase Orders report that shows all open items on PO’s and their QTY status.
Otherwise, if you are not using inventory and wanted it presented in a more readable fashion, then use a configuration package for Purchase Lines (Table 39), choose which columns (so many you can choose that are helpful for this report), filter the list in the config package to pull just the status’ you are interested in, like Purchase Order and export that to Excel.
In Addition, you can build custom reports using API connections that will give you this information through Excel or Power BI, etc.
Also, if you use your lookup magnifying glass and enter “Purchase Lines” you’ll get a great list with all of the status’ including Amt Rec’d Not Invoiced, etc.
Log in to reply.
