Accounting entries split in D365f&o

(4) Share

Report

Posted on by GH-09120844-0

Hello Experts,

I have a customer that buys goods from different sites.

When invoicing my customer I would like to generate 1 invoice grouping all purchases from all sites.

When posting the invoice i would like to split the entry as follows:

Db Recevable Account - SITE1

Db Recevable Account - SITE2

Db Recevable Account - SITE3

Cr Revenue - SITE1

Cr Revenue - SITE2

Cr Revenue - SITE3

Can you please let me know how can i achieve this?

Thanks a lot

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (9)

Answers (1)

GH-09120844-0 46 on at

Like (0)

Report
Copy link

Link copied!

Would it be possible to split the receivable account by Site/Warehouse?

Was this reply helpful? Yes No
CU15121148-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I will do my best to provide a concise and human-like response for this technical topic.
This setup is achieved using Financial Dimensions (or Segments) in most ERP/accounting systems.
Tag the Transaction: Ensure every line on your single customer invoice is tagged with its originating Site (SITE1, SITE2, etc.).
Configure Accounts: Set up your Chart of Accounts so that the Receivable and Revenue accounts driveezmd require the Site dimension.
Posting Logic: The system's posting rules will automatically split the single invoice total into multiple G/L entries, applying the dimension from the invoice line to both the Revenue and the Receivable sides.

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Marijana Vrndic 2 on at

Like (0)

Report
Copy link

Link copied!

Check out the following setup in Account receivable parameters and enable per need:

2 people found this reply helpful.

Was this reply helpful? Yes No
GH-09120844-0 46 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I will test and let you know if all is working as expected.

Was this reply helpful? Yes No
GH-09120844-0 46 on at

Like (0)

Report
Copy link

Link copied!

@CU15121148-0

Can you tell me how to 'Set up your Chart of Accounts so that the Receivable and Revenue accounts require the Site dimension'?

Thanks

Was this reply helpful? Yes No
GH-09120844-0 46 on at

Like (0)

Report
Copy link

Link copied!

@

Marijana Vrndic

Marijana Vrndic this will create an invoice per site and it is not what i need. I need to issue one invoice with different sites and have the 411 split per site.

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,430 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Is it possible that you use dimension as site.

Was this reply helpful? Yes No
GH-09120844-0 46 on at

Like (0)

Report
Copy link

Link copied!

Hello Billur, YEs we have the site as dimension but not sure how to split the balance sheet account by Site. (For the P&L no problem).

Was this reply helpful? Yes No
Verified answer

Syed Haris Shah 1,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @GH-09120844-0,

To achieve this behavior, sales orders need to be created per site, ensuring that all lines within a single sales order belong to the same site. The corresponding site financial dimension must be applied consistently at both the header and line levels.

This ensures that AR and Revenue postings use the same site dimension. Although invoice posting can be consolidated, the general ledger entries will still reflect the site-derived Financial Dimensions from each sales order.

If you find this answer helpful, please consider Verifying the answer. 👍

Regards,

Syed Haris Shah

2 people found this reply helpful.

Was this reply helpful? Yes No