Skip to Content
author's profile photo Former Member
Former Member

Correct total and individual Ending Inventory Account

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2008 at 02:23 AM

    Hi,

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

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2008 at 11:14 AM

    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-96149969aabb

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.