15,433
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
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
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
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
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.
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...
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
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.
#1
André Arnaud de Cal...
291,784
Super User 2024 Season 2
#2
Martin Dráb
230,476
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
