Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Nav Purchase Order Tracking with Purchase Invoices

Posted on by 210

Hi,

My company uses Microsoft Dynamics Nav 2009 Classic and is attempting to implement an AP workflow system with OCR and matching capabilities. However, the solution we have found (and most others) post the invoice data to the Purchase Invoice function of Navision, thus not offsetting with the Purchase Orders entered. We use this 'Oustanding PO' list in the Assignment Ledger for project management purposes, and is therefore essential to the business.

 

I've been struggling to find a solution to this problem and am seeking your help in understanding whether 1) there is an option to offset Purchase Invoices with Purchases Orders, 2) there is a workflow solution that posts invoices to the Purchase Header and Purchase Line tables in Navision?

 

Thanks in advance for the help.

*This post is locked for comments

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    You can customized a report to show the orders their receipts and invoices.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    If it's done please verify the answer.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    Stanadard & customize both are cleared by MMV & my post.

    I think it should be clear the concept as required.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    Hi,

    If you want to follow the standard way:-

    You may go to the individual Purchase Order, navigate to the Receipts and from the Receipt Lines, you may navigate to the respective Purchase Invoices.  

    With a minor customization, you can directly navigate to the Purchase Invoices from the Purchase Order:-

    In the posting routine, you need to update the "Order No." while posting into the Purchase Invoice.  But this can be done only if you are posting one Purchase Invoice against one Purchase Receipt.

    Best Regards,

    MMV

  • _dafa Profile Picture
    _dafa 5 on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    Hello,

    I have Dynamics 2013 R2

    I have the same problem in regards to the traceability between "the invoice is received and entered as a Purchase Invoice using the Get Receipt Lines function".

    Sandeep Poonia suggested to "open the purchase order form, click on the Order button and then click Invoices" in order to populate all related posted invoices to the purchase order. However, I came to test and understand that his suggestion only holds true when we post receive from the purchase order directly.

    Therefore, the problem remains: how do you populate the invoices for a purchase order that have been posted through the Get Receipt Lines function?

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    Please verify the answer.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    Open the Purchase Order form, click on the "Order" button and then click "Invoices". This opens the purchase invoice list populated with all related posted invoices, and they should all be there.

    Please verify the answer for purcahse order returns.

  • iglooman Profile Picture
    iglooman 210 on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    thanks sandeep. So I understand this logic of purchase order returns, but how does this work if you have 100% receipt of goods and eveything is ok? Let me just run through an example to make it more clear.

    I create a Purchase Order for 100 units of Apple iPads, for a total cost of $40,000. 5 days later the goods are received, and updated in Navision using the Receipt option in the Purchase Order. 2 days after this, the invoice is received and entered as a Purchase Invoice, using the Get Receipt Lines function. This links the invoice to received items from a PO. However, how then can I relate this Purchase Invoice to the PO and Posted Receipt lines? I want to figure out a way to relate all three of these documents. So far I've come to the conclusion that maybe the only option would be custom development of the Purchase Invoice, to include the Order No. from the Posted Receipts table.

    Let me know if this is correct, or if you see a solution to the problem.

    Cheers

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    Perhaps this helps:  print it while it's available

    www.pardaan.com/.../NAV%202009%20-%20Returns%20Management.pdf

  • iglooman Profile Picture
    iglooman 210 on at
    RE: Nav Purchase Order Tracking with Purchase Invoices

    This is for Nav 2013, not sure this helps me much. Plus it doesn't explain what Purchase Return Orders are?

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans