Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Invoice number by business unit

(0) ShareShare
ReportReport
Posted on by 390

Hi all,

We want to generate customer invoice by business unit.  I was able to set up a number sequence per business unit but it can't be assigned to Invoice number in AR Parameter.  Does anyone have similar need?  How did you get it done without extension?

Thank you.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,489 Super User 2025 Season 1 on at
    RE: Invoice number by business unit

    Hi YanQ,

    Does the Finance/business team has also some reasons for this rejection? It would be good to know their thoughts.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Invoice number by business unit

    Hi YanQ,

    I am with Andre because with this suggestion you can remain in the standard application.

    The alternative is a system modification, which seems tricky if you bind it to the business unit because the business unit is per se not bound to a company or a retail store.

    As an accountant, I also do not see the benefit of this adjustment except that it might be 'nice' or something that has been done this way in the past.

    I would thus recommend that you weight again the costs of this modification against the assumed benefits before thinking about a system modification.

    Best regards,

    Ludwig

  • YanQ Profile Picture
    YanQ 390 on at
    RE: Invoice number by business unit

    Thank you Andre.  Yes, we discussed the option of using receipt number in Retail.  Unfortunately, it got rejected by Finance/business team.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,489 Super User 2025 Season 1 on at
    RE: Invoice number by business unit

    Hi YanQ,

    Each store will have its own receipts. These will be integrated to the sales orders via retail transactions. The retail transactions do have the original receipt number. What value would it have to use an invoice series per store? Instead of an invoice number series per store, I would recommend a financial dimension to be included. At least, the retail reporting is aware of the retail channel.

  • YanQ Profile Picture
    YanQ 390 on at
    RE: Invoice number by business unit

    Hi all,

    Thanks for your responding.  We are using D365FO and have stores (retail) globally.  All stores are business units and would like to generate invoice by store number for various reporting purpose.  

    Thanks all.

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,723 on at
    RE: Invoice number by business unit

    Hi YanQ,

    Appreciate if you can go through all suggestions and update us on this thread.

    Best regards,

    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,723 on at
    RE: Invoice number by business unit

    Hi YanQ,

    As Ludwig and Andre already mentioned; this is not possible to do in standard environment.

    I have below queries.

    --- What is the purpose of this requirement to add business unit with customer invoice ?

    --- Based on what logic, ERP will be able to dynamically select different business unit dimension values for different customer invoices ?

    Instead of this; you can try with below options.

    1) When you are posting customer invoices; you must be posting with BU dimension value.

    2) If point 2 is 'Yes'; then you can simply generate Dimension statement report available in 'General ledger' module based on that BU dimension value. System will show you posted transactions as recorded with this BU value.

    You can find this in D365 but I am not sure if this report / any such report is available in AX version to give you financial dimension wise report.

    0333.JPG

    This you have to check and update in this forum.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,489 Super User 2025 Season 1 on at
    RE: Invoice number by business unit

    Hi YanQ,

    You can use number groups per customer which would enable different series per customer. There is no support for a number sequence based on a financial dimension value.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Invoice number by business unit

    Hello YanQ,

    Can you please also let us know whether you operate Dynamics AX or D365FO?

    Many thanks and best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Invoice number by business unit

    Hi,

    That's not possible to my best knowledge without making a system modification.

    Why do you need that and can you ensure that a business unit is only available in a single legal entity or are they used across legal entities?

    Best regards,

    Ludwig

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 Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans