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

augustus.perera_*38457

Hi

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

 

 

andre.lie

@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

augustus.perera_*38457

Thank you Andre.