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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Is it possible in Purc...
Small and medium business | Business Central, N...
Answered

Is it possible in Purchase Order divide the cost between different G/L account and Different Dimension Value

(0) ShareShare
ReportReport
Posted on by MahGah 15,613

Hi

Accounting department uses G/L and Dimension for "Cost Center". But sometimes they buy one item in one PO that divides between 4 cost centers.

Is it possible in PO line that they change the posting setup to post the cost between 4 G/L accounts ? Also, can they select 4 dimensions Value (all under one global dimension such as department) to divide the cost between those dimensions? 

If it is not possible what is your suggestion here? 

Thanks 

I have the same question (0)
  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 235 User Group Leader on at

    Wait a quantity of one is going to four cost centers? If that is so, I would setup a single cost center and/or dimension and at the end of the month use a recurring journal to allocate from the single cost center/dimension to the other 4.

  • MahGah Profile Picture
    MahGah 15,613 on at

    Kim Dallefeld  Thanks for the response. I am struggle with this question. Let me make sure I understood you

    Let Po post to the default GL/Dimension (let say GL1/D1).

    Then create General Journal (since this is case by case) and on one side select that G/L (GL1) account and other side the other G/L account (let say GL3) and select needed dimension for the other side (D3) . Then post.   But where I select the dimension for GL1? I mean that dimension needs to reduce as well.

    Or maybe I confused myself.

    Thanks for your help

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 235 User Group Leader on at

    Your journal entry allows you to put dimensions on the lines, in your case, you need to put the debit with it's GL and dimensions on one line and your credit on another.

    Another option would be to add additional lines to your invoice...

  • MahGah Profile Picture
    MahGah 15,613 on at

    Thanks Kim Dallefeld 

    Do you mean something like below? (as an example). In this case I needed to activate "Direct Posting" which I have been told this should not be on for "Direct Cost". 

    How do I add additional lines tp my invoice? Let say we order Part A then received it. Now, we want to invoice it. How I can break this item to go to 4 different accounts? 

    I truly appreciate your help with this topic. 

    pastedimage1669927790042v1.png

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 101,995 Super User 2026 Season 1 on at

    Hi, just adding some info.

    I have encountered a similar need before. The client's fixed assets belong to multiple departments, and the expenses need to be apportioned to different dimensions during depreciation.

    We customized a simple split function at that time, select the row, click split, select the dimension, enter the percentage (the sum is 100), and click OK to automatically add the rows.
    I think it's similar to this requirement.
    Hope that gives you some hints.

    Thanks

    ZHU

  • MahGah Profile Picture
    MahGah 15,613 on at

    yzhums

    Thanks for info. Do you think this is possible in PO for item? I mean at that point item already received and interim transactions posted.

    Thanks

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,995 Super User 2026 Season 1 on at

    Hi, I think it is possible.
    Because even if the items have been received and invoiced, we can also modify the quantity in the line, as long as the quantity is not lower than the quantity received.

    So in the code, you can open the order, modify the quantity of the original line, and create a new line with the divided quantity.
    Hope this gives you some hints.

    Thanks

    ZHU

  • MahGah Profile Picture
    MahGah 15,613 on at

    Hi Mr yzhums

    Thanks for the information and helpful tips.

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 Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,314 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,781 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,356

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans