Verify the sessions store:
- Go to the Sessions module.
- Open the session and confirm that it is assigned to the correct store.
- If the store is incorrect or has a status of processed export the session as a CSV file and import it manually into the Physical Inventory.
- Note: CSV format is recommended to avoid formatting issues.
Export the Session
- In the Sessions module, double-click the session to open it.
- Select Export.
- Choose Comma-Separated Values (CSV) and click OK.
- Name the file and note its save location
- You will need this file when importing counts into the Physical Inventory.
Create the Physical Inventory
- Go to the Physical Inventory module and select Physical Inventories.
- Click Create New Physical.
- Select the store for this physical inventory.
- If performing a full physical, ensure Add All Active Items is selected.
- For cycle counts, choose the appropriate options.
- Yellow Dog recommends leaving Skip items with zero on hand unchecked to avoid missing items.
- Continue to the next step and select the appropriate item set (for example, Select all items for a full physical).
Import Counts from the Session CSV
- On the import screen, select Add Counts from an Excel, CSV, or text file, then click Next.
- Click the three dots next to Import File and select the CSV exported earlier.
- If your file has headers, select Data has a header row with column descriptions.
- Map:
- The column containing the SKU or UPC
- The column containing the counted quantity
- These are the only required columns.
- Click Next.
- Choose Select ALL to import all items, or highlight items to omit and select Remove Selected
Figure: Example of a Physical Inventory with a session included that was imported as a CSV file
Confirm that a column appears with the same name as your file and that counts have populated correctly
Contact Yellow Dog support if:
-
The original handheld session was created under the correct store but still does not appear, or
-
The exported CSV cannot be imported into the Physical Inventory.