MBL2 Conclusion INV05 Formulae

pchandalia

Hi,

I have spent a long time trying to figure out the formulas for the line items in the INV05 Shipping Export Module.

 

For Shipping Costs - 'INV01 Inventory Ordering'.Final Shipping Costs and I know we need to also bring in the SKUs from one of SYS modules. However, I am unable to bring in the SKUs. Any help would be appreciated! 

For Code = CODE(ITEM('G3 Location')) , is this correct? 

 

Also, when I try the next part to import this module into the OTH01 module of the FP&A model, I am getting an error on the timescale.

 

Thank you! 

Palak

prabhu

Hi @pchandalia,

 

You are in a Right Track,

 

QUESTION : For Shipping Costs - 'INV01 Inventory Ordering'.Final Shipping Costs.

 

Instruction in exam clearly says, you have to bring(sum) the shipping costs based on location,

refer your SYS08 sku details Module. 

 

 

 

 

 

example on SUM    Target Module.Line item = Source Module.Value[Based on What?????]

 

When you are using sum function, When you are referencing a line item( [Based on What?????] ), within sum function, The format of Line item( [Based on What?????] ) should be dimension in your target module.

 

 

 

Question : For Code = CODE(ITEM('G3 Location')) , is this correct? 

 

                                Yes you are correct but, have you read the instruction care fully?

                                                                       have you created a subsidiary view?

 

 

 

Hope it helps,

 

@pchandalia  All the best for your Exam.

 

 

Thanks,

Sorna Raja Prabhu