Finance | Project Operations, Human Resources, ...

Invoice number by business unit

(0) Share

Report

Posted on by YanQ

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.

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello YanQ,

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

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report
Copy link

Link copied!

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.

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.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
YanQ 390 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
YanQ 390 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
André Arnaud de Cal... 304,500 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi YanQ,

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

Was this reply helpful? Yes No