Trace PO, Good Receipt, and PI number

(0) Share

Report

Posted on by Community Member

Hello everyone,

I am user of Microsoft Dynamic NAV 2013. So now, I am in the middle of system migration that I have to record all 'valid' Payable that I still have to pay.

I have invoiced (Purchase Invoice) all available Good Receipt.

But I could not find any list that contain PO number, Good Receipt number, and PI number. I need this to filter, whether those invoiced documents are still valid or not.

Could you please help where I could get list of PO, GRN, and PI number in 1 page?

If there is no list like that, at least, how can I get Received date of my PI list?

Please help

Any kind of contribution would be really appreciated

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report

hi,

In NAV, you can have multiple receipts and invoices per PO.

You could also have multiple POs per receipt and/or multiple PO per invoice.

If you are really in need of that kind of information, I would give a try with a SQL-Query or JetReports to process the data in Excel.

Normally you can see in the Item Ledger Entries which receipts are invoiced already (Quantity Invoiced). I think it's the best for you to speak to your local expert about this issue so he/she can provide you a solution (you mentioned you are in a migration at the moment).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, Mr Holst,

Thank you for your response. Unfortunately, I am unable to attain any solution from NAV expert/developer on my case, because unfortunately the response was really slow and I could not help with it anymore.

Yes, you're right, that those multiple documents per transaction would be confusing.

This idea just comes up into my mind, because I need to decide, which one the valid transaction that still relevant, based on Receive date. If there is any better solution, I would choose to not bother you with this.

But, it would be really helpful if you dont mind to share those query that you've mentioned :)

Thank you very much for your help, I really appreciate it, Mr Holst

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Ferdinand,

Take a look at these fields' information and you will see how they are linked:

- Purch. Rcpt. Header => Order No.

- Purch. Rcpt. Header => Vendor Order No.

- Purch. Rcpt. Line => Order No.

- Purch. Rcpt. Line => Order Line No.

- Purch. Inv. Header => Order No.

- Purch. Inv. Header => Vendor Order No.

- Purch. Inv. Header => Vendor Invoice No.

- Purch. Inv. Header => Pre-Assigned No.

- Purch. Inv. Line => Receipt No.

- Purch. Inv. Line => Receipt Line No.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

Valid payables you still have to pay would consist of two sets:

1. Received and Invoiced POs which has not been paid (you can get those yourself quite easy by drilling to any vendor card balance and clear the vendor filter, and filter out the invoices which are still open).

2. Received but not Invoiced POs - those you will find in the list of unposted Purchase Orders, in which Quantity Received would be more or equal Qty to Invoice.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Khoa,

Thank you for your email.

But if I am not mistaken, there are only few information on Posted Purchase Invoice I had.

Please take a look of this

Could you please help, what kind of module that you mention?

Thank you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Alex,

Thank you for your reply

Yes, I have done invoiced all received PO.

About your no 1 suggestion, it seems interesting. But in nav 2013, how could I get this done?

I appreciate your kind help

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Ferdinand,

Take a look at below link:

community.dynamics.com/.../how-to-view-all-fields-of-a-record

Was this reply helpful? Yes No