Create Shipping Export Module and Create a Saved View
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
| 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.
_151184.png?large/****-exif-data/true?v=v2&px=999 "2022-11-04 (2).png")
Best Answers
-
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.
0 -
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
0
Answers
-
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
0 -
There is an error in the Pivot item - G3 Location why?
Changed the time Scale
0 -
0
-
Your location list has some problem. Check your location list.
0 -
-
I'm telling about G3 location list.
General list>> G3 location
0
_151193.png?large/****-exif-data/true?v=v2&px=999 "2022-11-04 (4).png")
_151207.png?large/****-exif-data/true?v=v2&px=999 "2022-11-04 (8).png")