Monthly ending balance of a module with a weekly time scale bring to another module with monthly sca



appreciate if someone can check and give some directions. Thank you.


I wrote..

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN PREVIOUS('INV01 Inventory Ordering'.Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory


I need to extract only monthly endling inventory balance to another module...


source module is below: time scale weekly, summary method is set to - sum;time-ending balance, dimension is P3 SKU



Target module is below : time scale monthly, G3 Location, dimension is distribution canter sub set





  • @augustus.perera 


    Since the difference between your source and target modules is the distribution center list, you can use SUM function based on the system module that has the same list as the source module and provides look up for the distribution center

  • Thank you Andre.