Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Trace PO, Good Receipt...
Microsoft Dynamics NAV (Archived)

Trace PO, Good Receipt, and PI number

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Trace PO, Good Receipt, and PI number

    Hi Ferdinand,

    Take a look at below link:

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trace PO, Good Receipt, and PI number

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trace PO, Good Receipt, and PI number

    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

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Trace PO, Good Receipt, and PI number

    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.

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Trace PO, Good Receipt, and PI number

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trace PO, Good Receipt, and PI number

    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

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Trace PO, Good Receipt, and PI number

    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).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans