Create Shipping Export Module and Create a Saved View

Yogitha

@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 Costs	Number	Shipping Expenses by Location
Code	Text	Location 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.

jagadishdash

@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

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

jagadishdash

@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

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

Changed the time Scale

Yogitha

@jagadishdash 

My SYS06 Module looks unpopulated.

 

jagadishdash

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

Yogitha

@jagadishdash 

jagadishdash

I'm telling about G3 location list. 

General list>> G3 location