Combine multiple Purchase Orders on one Invoice

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

This post has 2 Replies | 0 Followers

1 Posts
17 Points
Joined: 2002-6-10
Last Online:
2007-3-13 6:05
Location: Louisville, KY USA
Chris Ballard Posted: 2002-12-17 16:18 | Locked
Do you have a product that does the following? Or know who may?

Purchase Invoice that combines purchase orders.

For example:

Purchase invoice # 1234 comes in. It includes items from PO# P9870, P9882, and P9975. I want to pull up a new invoice form. Insert the vendor, invoice document date, and the vendor's invoice # (1234). I may go to the lines, where a Purchase Order No. field is added, and on the first line PO# P9870 is called up, then select an item from this PO. After that the qty., cost, and all other fields are filled in. You then go to the next line, where you call up the same PO or one of the others. You continue until all items from the vendor's invoice are accounted for.

With this method, the same vendor invoice number is used for all items on the invoice. Using the vanilla Navision product, you must call up each PO, one at a time to process. You cannot use the same vendor invoice number, because the system does not allow duplication of the Vendor Invoice No. You will need to do something like this:

PO No. Vendor Inv. No.
P9870 1234-01
P9882 1234-02
P9975 1234-03

This is for version 3.60.

Thank you,

Chris Ballard
Accounting Systems Project Manager
Price Data Systems
Bus. Ph. (502) 499-5375
Bus. Fax (502) 499-5376
Email: chris@priceinc.com
20 Posts
188 Points
Joined: 2002-10-22
Last Online:
2014-10-21 17:11
visu9211 replied on 2002-12-17 16:58 | Locked
Hi Chris. As far as i understand, you want to combine multiple POs into a single Invoice received from the Vendor. You can do it by going to Purchase & payables -> Invoices. On the invoices form click Functions -> Get Receipt Lines. Then select all the items from the posted receipts for which you have received the invoice from the vendor. Thats it!
Male
151 Posts
919 Points
Joined: 2001-5-1
Last Online:
2007-3-13 4:39
Location: Suntec City Singapore
Rohith Kamath replied on 2002-12-18 4:38 | Locked
On the Sales side you could also use the "Combine Shipments" functionality and the system combines all shipments for a customer and creates one invoice. The same functionality could be easily replicated for a purchase scenario.
Page 1 of 1 (3 items) | Get this RSS feed | Bookmark and Share