web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Accounting entries spl...
Finance | Project Operations, Human Resources, ...
Answered

Accounting entries split in D365f&o

(4) ShareShare
ReportReport
Posted on by GH-09120844-0 46
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)
  • Verified answer
    Syed Haris Shah Profile Picture
    Syed Haris Shah 811 on at
     
    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
  • GH-09120844-0 Profile Picture
    GH-09120844-0 46 on at
    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).
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 20,125 Most Valuable Professional on at
    Is it possible that you use dimension as site.
  • GH-09120844-0 Profile Picture
    GH-09120844-0 46 on at
    @
     
    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.
  • GH-09120844-0 Profile Picture
    GH-09120844-0 46 on at
    Can you tell me how to 'Set up your Chart of Accounts so that the Receivable and Revenue accounts require the Site dimension'?
    Thanks
  • GH-09120844-0 Profile Picture
    GH-09120844-0 46 on at
    Thank you, I will test and let you know if all is working as expected.
  • Suggested answer
    Marijana Vrndic Profile Picture
    Marijana Vrndic 2 on at
    Check out the following setup in Account receivable parameters and enable per need:
     
  • CU15121148-0 Profile Picture
    CU15121148-0 2 on at
    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.
  • GH-09120844-0 Profile Picture
    GH-09120844-0 46 on at
    Would it be possible to split the receivable account by Site/Warehouse?

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 338 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans