Correct total and individual Ending Inventory Account

[Former Member]

Hi,

I have an account called "Ending Inventory", the values for Q1 to Q4 for "Ending Inventory" are 180, 200, 120 and 300. The total of "Ending Inventory" for the year must be 300 instead of combining all 4 values to be 800. How do i achieve that?

This is not like unit sold x unit price = sales, where the total sales can be arrived at correctly by using script logic. I need the right "Ending Inventory total (i.e. derived from Q4's Ending Inventory) and the right "Beginning Inventory" (i.e. derived from Q1's Beginning Inventory) to arrive at the right "Units to be Produced" (i.e. sales + ending inventory - beginning inventory).

I thought about tracking the movement of the inventory, i.e. 180 for Q1, +20 for Q2, -80 for Q3 and +180 for Q4 so that the total of "Ending Inventory" will come out correct but that would mean that the individual quarters won't have the right total.

Perhaps i am mistaken when i assume that there's no appropriate keywords within script logic to allow me to do this. Does anyone have any idea?

Cheers

[Former Member · Accepted solution]

Hi,

Try this change the account type property of the dimension to either AST or LEQ. let us know if this works

thanks

[Former Member · Accepted solution]

Hi,

Changing the acctype of accounts to "AST" and "LEQ" will force data entered in 2005.Q1 , 2005.Q2 and 2005.Q3 to be ignored (i.e. not aggregated into 2005.TOTAL but the value still exists in 2005.Q1) and data entered in 2005.Q4 to be aggregated into 2005.TOTAL.

The difference between "AST" and "LEQ" is that "AST" will be regarded as a positive value, while "LEQ" will be regarded as a negative value.

While that's half the puzzle solved, i still need something that helps me to aggregate only 2005.Q1 into 2005.TOTAL while ignoring any values entered into 2005.Q2, 2005.Q3 and 2005.Q4. An account that fits this criteria would be "Beginning Inventory"

Any idea?

Thanks.

Edited by: lip chean soh on Oct 30, 2008 4:54 AM

[Former Member]

You should be able to find this information in the Logic guide;

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80ffae4b-99d5-2a10-4e9f-96149969...

I think you need the section "The time shift instructions"