Create Shipping Export Module and Create a Saved View

Yogitha
edited November 2022 in Modeling

@jagadishdash 

@alexpavel 

 

Can u let me know what's wrong?

 

In the Supply Chain model, create a module to export the shipping costs by location and create a saved view for export: 

  • Module Name: INV05 Shipping Export 
  • Dimensions: G3 Locations list, Time (months) 
  • Category: Inventory
  • Functional Area: Inventory
 
Line Item Format Purpose
Shipping CostsNumberShipping Expenses by Location 
Code TextLocation Code to ensure consistency at import
 
  • Before writing the formulas, use a subsidiary view to change the dimensionality for the Code line item so that is it not applicable over Time.
  • Also, there is no need to recreate a Code if the data already exists.
  • Review the Summary Method settings and create a saved view for exporting in the INV05 module.
  • Keep in mind that you will want to import G3 Locations by Code.2022-11-04 (2).png2022-11-04.png
Tagged:

Best Answers

  • jagadishdash
    edited November 2022 Answer ✓

    @Yogitha 

    Check. In your General List. For G3 location selective access is on. And Go to user section and make sure you have the full access to All region. 

     

    Then it's work fine as i told in above. 

     

    Hope you got it. 

     

  • ShubhamCh
    edited November 2022 Answer ✓

    Hi @Yogitha 

    First of all change the time format as @jagadishdash explained. I believe you have selective access also turned on. 

    Go to User page

    There you'll see G1,G2,G3 location read and write columns. 

    In G1 location write column select all members.

    It'll fix the problem. 

    Thanks!

    -Shubham

Comments

  • jagadishdash
    edited November 2022

    @Yogitha 

    First of all, You Module creation is wrong.

    As you can see the instruction you need to Make the time dimension in month, But  you created as Week time dimension. First change it.

     

    then you need to bring the code from system module SYS06 location details.code in the COde line item.

    For shipping cost you need to bring from 'INV01 Inventory Ordering'.Final Shipping Costs summing with distribution center from sys module of SKU.

     

    Follow the instruction properly. 

    Hope it helps.

     

    Jagadish Dash

     

  • Yogitha
    edited November 2022

    There is an error in the Pivot item  - G3 Location why?

    Changed the time Scale

  • Yogitha
    edited November 2022

    @jagadishdash 

    My SYS06 Module looks unpopulated.

     

    2022-11-04 (4).png

  • jagadishdash
    edited November 2022

    Your location list has some problem. Check your location list. 

  • Yogitha
    edited November 2022
  • jagadishdash
    edited November 2022

    I'm telling about G3 location list. 

    General list>> G3 location