TM1 Forum

Hi,
I have a request for which I need to store the rolling balances for inventory stock on hand. So basically, I need to roll the closing balance of the previous month as the opening balance of the next month. Since, the data source is at a transaction level the opening balance for each month needs to be calculated based off the transaction data, which has receipts, adjustments, stock on hand. Does anyone have any examples of models that do this.

ssp wrote:Hi,
I have a request for which I need to store the rolling balances for inventory stock on hand. So basically, I need to roll the closing balance of the previous month as the opening balance of the next month. Since, the data source is at a transaction level the opening balance for each month needs to be calculated based off the transaction data, which has receipts, adjustments, stock on hand. Does anyone have any examples of models that do this.

I'd suggest doing a search for the word "Inventory" in the old Applix Forum (http://applixforum.olapforums.com/). It's something that's been discussed many times there, so you may well find what you're looking for.