Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Vendor Invoice No. Uniqueness

(0) ShareShare
ReportReport
Posted on by 356

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.

  • Greg Kujawa Profile Picture
    356 on at
    RE: Vendor Invoice No. Uniqueness

    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!

  • Jun Wang Profile Picture
    7,761 Super User 2025 Season 1 on at
    RE: Vendor Invoice No. Uniqueness

    in your case, you can use get receipt lines function in BC to post one purchase invoice against multiple PO.  

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,012

#2
YUN ZHU Profile Picture

YUN ZHU 936 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 612

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans