get inventory per country per sku

Abhishek586
Abhishek586
in Modeling

I have an Invenotry ordering module where i have beginnening inventory, i want to get the inventory in a new moudule by country and by country and sku both i have a sku details module which has country made in as lst item and sku as a dimension

image.png
image.png

i tried using this formula but got no data
'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Country Made In] for inventiry by country

Best Answers

  • AjayM
    AjayM
    edited October 14 Answer ✓

    Got it, thanks for sharing.
    Looks like you don't have (or don't need) time dimension in INV05 and INV06 modules?
    If you don't need time dimension in these modules, you need to make sure your formula takes care of aggregating values across time dimension as well from the source.

    First verify if 'Total of All periods' is turned on under model's time settings ('Include' section at the end).
    If it is turned OFF, you can use TIMESUM function in your formula.
    If 'total of all periods' is turned ON, you could instead use the select function like "select:time.all periods" in the formula.

    If you need time dimension in INV05 and INV06 modules, just enable it, and your original formula from first post should work.

    Cheers!

  • Prajjwal88
    Prajjwal88
    Answer ✓

    Hi @Abhishek586 ,

    I agree with the solution mentioned by Ajay, The other way to do this is you can simply make another line item in your source module INV01 for beginning inventory say 'beginning inventory TimeSum' then just mark the same Line Item's time scale as Not Applicable from blue print view and apply the formula as-
    TIMESUM(Beginning Inventory)
    And after that you can simply use this Line Item instead of previous one in the target module with the same formula you have applied already.

    I hope it helps.

Answers

  • AjayM
    AjayM
    edited October 14

    Hi @Abhishek586 ,

    If your source module INV01 is already by SKU, why do you need a summary in another module also by SKU (besides country)?
    Check the summary setting of 'beginning inventory' in INV01. I see time summary is ON, but the normal summary?

    Cheers!

  • Abhishek586
    Abhishek586

    hi @AjayM

    i need it like this

    image.png

    and inventory by per country per sku

    image.png

    the normal summary is sum and the time summary is opening balance

  • AjayM
    AjayM

    In both these INV modules, same formula should work - the formula that you mentioned in the original post. Mind sharing the snapshot of INV05 module result after applying the formula?

  • Abhishek586
    Abhishek586
    image.png

    sure here is the snapshot after applying the formula, no data is seen
    however when i use data01 module to get the inventory the data is displayed

    image.png

    here is my data 01 module

    image.png

Categories