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

Highlighted
Contributor

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

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

Augustus_0-1601789518010.png

 

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

Augustus_1-1601789832030.png

 

 

2 REPLIES 2
Highlighted
Certified Master Anaplanner

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

@Augustus 

 

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

Highlighted
Contributor

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

Thank you Andre.