Using the latest BC 365 SaaS version. Our workflow for receiving goods generally involves larger purchase orders with many lines. Gradually over time our vendors ship us batches of items against those PO's. Most of the time we partially receive against the open PO's. So that means that a single vendor invoice can be applied against multiple PO's.
Where I am stumbling involves how BC 365 associates a Vendor Invoice No. against the individual PO's. Say we have Vendor Invoice No. 123456, and it is fulfilling an item on PO No. 1000, an item on PO No. 1001, and an item on PO No. 1002. When we post the receipt & invoice, each of those PO's requires a unique Vendor Invoice No. Which makes no sense from a practical business standpoint. We can't have them share Vendor Invoice No. 123456. As a workaround we are manually appending a hyphen, followed by the PO No. value to the Vendor Invoice No. to make it unique. While that allows the transaction to post, when it comes to payment remittance the vendor is presented with a convoluted mess to reconcile. Such as a line for 123456-1000, a line for 123456-1001, and a line for 123456-1002 in my example.
How do you handle this more gracefully and cleanly? I come from 20+ years of being in the Microsoft GP world, where a Shipment/Invoice transaction can pull in the user-selected open purchase lines from all open PO's. And these are pulled into a new form where the user can define a single Vendor Invoice No. value for all of them.
Yes, on a functional level this makes sense. The thing is if we are receiving and invoicing in a single action. Otherwise when we have a large shipment that's arrived we'd have to manually receive off each open PO as one big step. And then we would have to go into this Purchase Invoice function to get those receipt lines as a second big step. So from a practicality standpoint it's rather cumbersome.
I wish that this functionality was a bit cleaner and more streamlined. Out of the box it seems to work best if things are simple. One purchase order all fulfilled at once against a single receipt/invoice. For partial PO receipts as well as receipts against multiple PO's the workflow wasn't very well thought out!
in your case, you can use get receipt lines function in BC to post one purchase invoice against multiple PO.
Sohail Ahmed
1,012
YUN ZHU
936
Super User 2025 Season 1
Mansi Soni
612