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.
