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.
inventory balances
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: inventory balances
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.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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.