Hello,
I am new to Nav and am looking for a way to search PO numbers that have been received and invoiced. Is there a way to do this?
Hi
One quick way is to go to Posted Purchase Invoices navigate page in NAV 2009 and Posted Purchase Invoice form in NAV5.
In NAV 2009 it already gives you a list of PI and their POs. In NAV5, do a lookup on No. field (F5), you will again see the list of PIs and their POs. both are exportable to excel. You could hide those columns that you do not need to be exported to excel first.
Sorry, please diregard my post. I do not think by default it’s available there! I recall I added the PO# there to the list myself
You need to write report to achieve the same.
Welcome to the user group. :[:)] Your question isn’t quite clear. And maybe you just need to understand how it really works.
In NAV when you have a purchase order (or for that matter a sales order) and you post it (so that there are no remaining / back-order lines), then NAV deletes the order from the database, as it is no longer needed. Instead it creates both Posted Purchase Invoices and Posted Purchase Receipts. And if the order was not posted in one step, but was received over several days, then it creates multiple receipts and posted invoices.
The “Order No.” is stored on the header of both the Posted Invoices and Posted Receipts, so to search for the PO numbers then you can open the Posted Purchase Invoices and Posted Purchase Receipts forms and search directly in the Order No. field here.