Level 2 - Sprint 1 - 1.5.2
Review DAT01 Beginning Inventory Module
- Module Name: DAT01 Beginning Inventory
- Dimensions: SKU Flat list, s Location Flat: Distribution Center? list
- Category: Master Data
| Beginning Inventory | Number | Beginning inventory count (opening stock) for each product SKU by Distribution Center |
| Filter | Boolean | Does this Distribution Center hold inventory for this product SKU? Filter for items containing data (not equal to 0) |
Import Data into DAT01 Beginning Inventory Module
- Download data file: Beginning Inventory.csv.
- Import the data file into the DAT01 Beginning Inventory module.
Before you continue, confirm the formula for the Filter line item: Beginning Inventory<>0
This line item will be used to filter the data to show only the product SKUs for which each Distribution Center carries inventory.
For the above activity, I am attaching the one I finished . Can u let me knw if its right?
_147619.png "2022-09-23 (4).png")
Comments
-
0
-
I have an issue it says Slocation Flat: Distrubution List? No items. Please advice
0 -
Hi @ademmagatur15 ,
If you mean the subset “s Location Flat:Distribution Centers?” in data hub model, please recheck 1.3.3 activity first, where you should be importing given locations file into respective location flat list - this should populate the mentioned subset as well, with proper mapping in the action.
Cheers!
0 -
Here ar the screenshots. I could not fugure it out yet.
0 -
Hi @ademmagatur15 ,
In these screenshots, you are trying to import data into DAT01 module, without first fixing the subset of location flat list. As I mentioned, as part of 1.3.3 activity (1.3.3.3 precisely), you can download "Locations.csv" file, which should be uploaded back into Location flat list:
After importing, verify that the subset holds few items. And then you can import beginning inventory into DAT01 module.
Cheers!
1 -
it worked. Thank you so much!
0
