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

augustus.perera
augustus.perera
in Academy Discussions

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

 

 

Comments

  • andre.lie
    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
    augustus.perera

    Thank you Andre. 

Categories