Skip to main content

Notifications

Business Central forum

Customer PO Number - Customer Purchase Order Number in Sales Invoice

Posted on by

We have been setting up, testing, and importing into Dynamics 365 Business Central for a few months, but we have yet to figure out a way to add the CUSTOMERS Purchase Order Number into Dynamics?

Most of our customers will not pay us if thier PO# is not on the invoice. The odd part is it shows up in the PDF copy that is emailed, but no field to enter this into.

Where and How is this done?

Categories:
  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Customer PO Number - Customer Purchase Order Number in Sales Invoice

    in dataitem "Detailed Cust. Ledg. Entry" add a sub-dataitem "sales header", which is linked via "document no." and "document type"=order.

    from dataitem "sales header" you get the "external document no." for usage as "customer po no."

  • Saif Ehsan Profile Picture
    Saif Ehsan 360 on at
    RE: Customer PO Number - Customer Purchase Order Number in Sales Invoice

    Any ideas if there is a field for "Total amount paid on invoice" or "Amount Applied"?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customer PO Number - Customer Purchase Order Number in Sales Invoice

    I worked it out - it's LeftHeaderValue that equals External Document Number - not very obvious at all.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customer PO Number - Customer Purchase Order Number in Sales Invoice

    Ian,

    We run into the same issue. It doesn't appear to be a one to one match on the field you wish to display the data form. Any insight you find would be helpful.

    Chad.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customer PO Number - Customer Purchase Order Number in Sales Invoice

    Hi Ivan,

    Would you know what the External Document Number is called in the XML mappings (content controls in Word)? I'm trying to modify the custom layout of an invoice email body to insert the External Document Number, but I can't see what it's called - I see no sign of an External Document Number in the XML mappings.

    Thanks,

    Ian

  • Suggested answer
    ikoletic Profile Picture
    ikoletic 2,202 on at
    RE: Customer PO Number - Customer Purchase Order Number in Sales Invoice

    Hi Ian,

    Yes, you can - see following help topic

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customer PO Number - Customer Purchase Order Number in Sales Invoice

    Hi Mary,

    So can we show the External Document Number from a Sales Order in CRM on a Sales Invoice in Business Central?

    Thanks,

    Ian

  • Suggested answer
    MCarrero Profile Picture
    MCarrero 772 on at
    RE: Customer PO Number - Customer Purchase Order Number in Sales Invoice

    Use the external document number on the sales order (ex: PO12345).  This flows through to the invoice, then prints in the Customer PO No. field.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans