Level 2 Model Builder

Maggie

Hi there,

 

After importing shipping costs into Financial Planning and Analysis model from the supply chain model, 2020 and 2021 shipping costs are showing up. However the 2019 shipping costs got overridden to 0. Is this correct? 

 

Thank you,

Maggie

Ajinkya

Hi @Maggie ,

 

After importing shipping costs into Financial Planning and Analysis model from the supply chain model, the shipping costs should not be overridden to 0. Follow the below steps for the correct values to reflect,

 

1. Assuming you have created a INV05 shipping Export saved view in supply chain model, go to your FP&A model -> OTH01 Non-Employee Expenses grid view-> Data -> Import-> Connect to you supply chain maodel's INV05 shipping export saved view and map it in the following manner(highlighted in black),

Note: Please ensure to import G3 locations by code.

 

2. Time & G3 locations shall automatically get mapped, select 'sales' from dropdown under E1 departments tab and follow the below mapping for last tab(OTH01 Non-Employee Expenses)

3. Run the import. This shall fetch you correct shipping costs values in your FP&A model.

 

Hope this helps. Hit a like if it works for you ! 

 

Regards,

Ajinkya