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

(0) Share

Report

Posted on by MahGah

15,519

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)

All responses (8)

Answers (1)

MahGah 15,519 on at

Like (0)

Report

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

Hi Mr yzhums

Thanks for the information and helpful tips.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
MahGah 15,519 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Verified answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
MahGah 15,519 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 User Group Leader on at

Like (0)

Report

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

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...

Was this reply helpful? Yes No
MahGah 15,519 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 User Group Leader on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No