Multiple Purchase Orders for One Invoice

  • Multiple Purchase Orders for One Invoice

    Posted by DSC Communities on December 15, 2016 at 11:22 am
    • Gary Deemer

      Member

      December 15, 2016 at 11:22 AM

      We are using NAV 2009 R2 and we’ve run into a situation where a vendor is sending us one invoice that covers multiple PO’s in NAV.  Is there functionality in NAV to accommodate this kind of situation, much like there is for posting mutliple shipments on one PO or using multiple purchase receipts for one invoice?  We could manually modify the invoice number for each PO but then that one invoice would show in A/P as mutliple invoices instead of just one.

      ——————————
      Gary Deemer
      Accounting Director/Treasurer
      Arbor Day Foundation
      Lincoln NE
      ——————————

    • Lewis Rosenberg

      Member

      December 15, 2016 at 1:10 PM

      I’ve never tried it, but from the Purchase Invoice Lines section you can use FUNCTION > GET RECEIPT LINES and I think you can select receipt lines from multiple purchase orders.

      ——————————
      Lewis Rosenberg
      IT Manager
      Mars Fishcare
      Chalfont PA

      NAVUG Board of Advisors, Programming
      NAVUG Programming Commitee
      NAVUG Membership Committee
      ————————————————————————-

    • Gary Deemer

      Member

      December 15, 2016 at 2:40 PM

      Works like a charm!  Thanks so much, Lewis!!

      ——————————
      Gary Deemer
      Accounting Director/Treasurer
      Arbor Day Foundation
      Lincoln NE
      ————————————————————————-

    • Saurabh Shah

      Member

      December 15, 2016 at 2:35 PM

      Hello Gary,

      if you posting Invoice directly from the Purchase order then this is not possible but if you post the receipt of each purchase order separately then this can be possible.

      Post the each purchase order for receipt so multiple Purchase Receipt document will get created.  

      Go to Purchase Invoice function and create new document. You can select all the receipts at lines by using the Get Receipt lines function. You will have a list of Purchase receipts so select all those lines and Post it under single invoice.

      You will also have only one Vendor Ledger entry for this invoice. 

      Let me know if you need any other information for this. 

      Regards,

      ——————————
      Saurabh Shah
      Amerdian LLC
      Midlothian VA
      ————————————————————————-

    • Gary Deemer

      Member

      December 15, 2016 at 2:42 PM

      Thanks so much, Saurabh!  Both you and Lewis were all over this!

      ——————————
      Gary Deemer
      Accounting Director/Treasurer
      Arbor Day Foundation
      Lincoln NE
      ————————————————————————-

    • David Wiser

      Member

      December 15, 2016 at 4:35 PM

      One additional point to cover…when you fully invoice a PO from the PO, the system will remove the fully received and invoiced PO from the Purchase Header/Line tables.  When using the Purchase Invoice/Get Receipts option described above, NAV will not automatically remove the PO upon invoice posting.  Removing the PO will have to be done manually or by periodically running the Delete Invoiced Purchase Order job.

      ——————————
      Dave Wiser
      Controller
      Beckwith & Kuffel
      Seattle WA
      ————————————————————————-

    • Avril Casey

      Member

      January 29, 2018 at 5:31 AM

      ?hi

      just reading this update, we are on 2016, does anyone know has this process being enhanced to make it easier to match multiple Purchase orders to 1 invoice?

      many thanks
      Avril

      ——————————
      Avril Casey
      Trendmicro
      Cork
      ——————————
      ——————————————-

    • Val Gameiro

      Member

      January 30, 2018 at 10:00 AM

      As far as I know, no new functionality for this in 2016 or subsequent versions.

      The process remains the same, as far as I know.

      ——————————
      Val Gameiro
      Senior NAV Analyst
      BPL Plasma Inc.
      Austin, Texas
      NAVUG Austin Chapter Leader
      ——————————
      ——————————————-

    • Naveen Jain

      Member

      January 30, 2018 at 1:01 PM

      It is the same process for all versions of NAV as Described?

      ——————————
      Naveen Jain
      Director of IT
      Symbex Companies
      Santa Fe Springs CA
      ——————————
      ——————————————-

    • Kim Dallefeld

      Member

      January 30, 2018 at 2:34 PM

      Dave makes a good point, if multiple POs to one invoice is something you will do continually, you should add to your month-end process the execution of Delete Fully Invoiced Purchase Orders.

      ——————————
      Kim Dallefeld
      VP Professional Services
      Syte Consulting Group
      kdallefeld@sytecg.com

      Past NAVUG Board Chairman
      NAVUG Programming Committee
      ——————————
      ——————————————-

    • Val Gameiro

      Member

      January 31, 2018 at 10:25 AM

      For my users, on the sales side, I added a field to let them know the SO is “OK to DELETE” so they can easily tell.

      It’s just a lookup function to the sales lines, to make sure all the lines have been shipped and invoiced (really Qty Invoiced = Quantity is all you need).

      ——————————
      Val Gameiro
      Senior NAV Analyst
      BPL Plasma Inc.
      Austin, Texas
      NAVUG Austin Chapter Leader
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Multiple Purchase Orders for One Invoice’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!