Enter Count Quantities
This page describes procedures for environments using Inventory Management (New Method).
If your screen layout differs from the one shown on this page, see the Inventory Management (Conventional Method) manuals.
Overview
This manual explains how to enter the quantities of stock counted during a physical inventory count for each location.
Purpose
You can enter the quantities of stock counted and record the results of the count.
You can enter count quantities using a method suited to your work, such as manual entry or barcode scanning.
Feature Description
Recording Count Quantities
Count quantities are entered for each place where counting is performed (location). When you select your assigned location, the SKUs to be counted appear in the count rows.
Count rows show SKUs based on stock information recorded during count session preparation and SKUs added during the count.
Count the products at the location and enter the quantities in the count rows for the corresponding SKUs. Even for the same SKU, separate count rows are shown for different lots or inventory segments, so enter the quantity in each row.
If you find a product that is not in the count rows, you can add its SKU.
Entering and saving count quantities or importing an Excel file alone does not change stock quantities in the system. Stock quantities are updated after the subsequent review and approval.
Preparing for a Count
Before entering count quantities, create a count session that specifies the facility and locations to count.
Once count session preparation is complete, you can start entering count quantities for the target locations.
To scan product barcodes, register barcodes for the products in advance.
To create a count session, see Create a Count Session.
Methods for Entering Count Quantities
You can choose an entry method suited to your work. You can switch entry methods to record quantities in the count rows.
| Entry method | How quantities are recorded |
|---|---|
| Manual entry | Enter the quantity counted. If a quantity has already been entered, it is replaced by the entered quantity. |
| Barcode scan | The count quantity increases by one each time a scan is accepted. |
| Excel import | Import the quantities entered in the template. If a quantity has already been entered, it is replaced by the quantity in the file. |
Barcode Scanning
You can use a barcode scanner to scan product barcodes and enter count quantities. The corresponding count quantity increases by one each time a scan is accepted.
If there are multiple count rows for the same SKU, the destination is selected automatically based on the conditions.
Excel Template Scope
The template contains the count rows for the location selected when the template is downloaded.
It also includes rows added after the count session started, regardless of the screen's search results or the page displayed.
It does not include count rows for other locations or rows added after the template was downloaded.
The location code, SKU information, lot, expiration date, disposition, and other details are included for each target row.
Counted Quantity and Memo are blank; previously entered count quantities and notes, as well as theoretical stock quantities, are not included.
Count Quantity Entry Status
On the count quantity entry screen, you can check the entry progress for the selected location, the number of rows not entered, and the number of rows with differences.
Count quantities entered manually or by barcode scan are saved automatically, and you can check the save status.
You can also click the Save entries button to save.
For each count row, you can check the difference between the count quantity and theoretical stock.
Instructions
Navigate to the Count Quantity Entry Screen
You can open the count session details page from the Merchant App or from the preparation completion notification email.
Open the count session details page using either method, then select the location to count.
Navigate to the Count Session Details Page
- Click the Inventory menu.
- Click the Counting tab.
- Search
Enter search criteria to narrow down the count sessions. - Click the Proceed with count button for the target count session.
The "Count session details" page opens.
If notification email addresses were specified when creating the count session, you can also open the "Count session details" page using the セッションを開く button in the preparation completion notification email.
Select the Location to Count
-
Click the Start count button for the location where you will enter count quantities.
The count quantity entry page for the selected location opens.To resume an interrupted count, click the Continue count button for the target location.
To recount a location whose entry is complete, click the Cancel completion button for the target location.
Enter Count Quantities
If you are counting multiple locations, enter count quantities for each location.
-
You can check the count entry status.
- Count entry progress: Check entry progress for the selected location.
- Not entered: Check the number of rows not entered.
- Has difference: Check the number of rows with differences.
- Session total: Check entry progress for the entire count session.
- Autosave: Check the save status of entered quantities.
-
Location being counted
The facility and location being counted are displayed.To change the location, click the Select Another Location button.
Follow the steps in Select the Location to Count to select a location. -
Enter count quantities.
You can use one of the following three methods. See the instructions for your chosen method.
Enter Count Quantities Manually
-
Input method
Select the Manual entry with search and list radio button. -
Search products and SKUs
You can search for the SKU for which you want to enter a count quantity.- Enter search criteria and click the Search button to narrow down SKUs.
- To filter by entry status, select Entry status from the dropdown and click the Search button.
- Click Reset to clear the filter.
-
Count rows
Enter the actual stock quantity counted for the SKU in the Counted Quantity field.If you manage stock by lot or inventory segment, enter the count quantity for the relevant lot and segment.
- Enter an integer greater than or equal to
0. - If the quantity is 0, enter
0instead of leaving the field blank. - You can also adjust the quantity using "+" and "−" in the quantity field.
- If the entered count quantity differs from the theoretical stock, the difference is displayed.
If the target SKU is not in the count rows, add it.
For how to add a count row, see Add an SKU Not Included in the Count. - Enter an integer greater than or equal to
Once entry is complete, proceed to Complete Count Quantity Entry.
Enter Count Quantities by Scanning Barcodes
-
Input method
Select the Barcode scan radio button.Use the Play a sound for each scan toggle to choose whether a sound plays when scanning.
- When Play a sound for each scan is enabled, a high tone plays when a scan is accepted and a low tone plays when it is not accepted.
- When Play a sound for each scan is disabled, no sound plays when scanning.
-
Click the Scan a barcode or SKU code field so it is ready for input.
-
Scan a barcode.
You can also enter an SKU code and press Enter to submit it.For each scan successfully accepted, the target row's count quantity increases by
1and is saved automatically.Under Last scan, you can check the target SKU, quantity, and other details.
For SKUs managed by lot or inventory segment, the assigned lot and inventory segment are also displayed.* If the scanned barcode is not registered in the product master, No item in the master matches this code is displayed.
tipIf you scan incorrectly, click the Undo The Last Scan button to undo the most recent quantity change.
If it cannot be undone or you need to correct an earlier scan, enter the correct quantity in the count quantity field.If necessary, click Open under Search products and SKUs to find the target SKU and enter the quantity in the count quantity field.
You can also adjust the quantity using "+" and "−" in the quantity field.If you are prompted to select a lot and inventory segment to add an SKU, the quantity is not recorded.
Follow the instructions on the screen to add an SKU not included in the count.
Once entry is complete, proceed to Complete Count Quantity Entry.
Add an SKU Not Included in the Count
When adding a scanned SKU, its SKU code may already be entered in the search field.
Check the displayed information. If the Counted Quantity input field is displayed, proceed to step 4.
-
Click the Add A SKU Outside Theoretical Stock button.
A product search field appears. -
Enter a registered SKU, product name, or other information in the search field to find the product to add.
-
Click the Add button for the SKU to add.
-
Enter an integer greater than or equal to 1 in Counted Quantity.
If the product is managed by lot or inventory segment, select the Lot or Inventory segment from the dropdown.If you select Enter a new lot under Lot, enter the Lot code.
-
Click the Add button.
Enter Count Quantities by Importing an Excel File
-
On the count input screen for the target location, click the Import From XLSX button.
The "Bulk Count Entry Import" modal appears. -
Click the Download template button.
The Excel template is downloaded. -
Open the downloaded Excel template.
The template contains the saved count rows for the target location at the time of download.
-
Enter the information in the Excel template.
-
Counted Quantity: Enter the actual stock quantity counted for the SKU.- If stock is managed by lot or inventory segment, enter
Counted Quantityin the corresponding row. - Enter an integer greater than or equal to
0. If the counted quantity is 0, enter0. - Rows with a blank quantity are not imported, and previously recorded quantities are not changed.
- If stock is managed by lot or inventory segment, enter
-
Memo: Enter a note if needed.
tipTo add an SKU, add an empty row to the template.
Enter the current
Location Codeand a registeredSKU Codein the added row, and enter the count quantity inCounted Quantity.
If barcodes are registered for the location and SKU, you can useLocation BarcodeandSKU Barcodeinstead of the codes.Enter
Lot Code,Actual Expiry Date,Disposition,Inventory Segment Code, andMemoif needed.If the added row matches an existing count row, a new count row is not added; the existing row's count quantity is replaced by the
Counted Quantityin the file. -
-
Save the file.
-
Follow the steps in Navigate to the Count Quantity Entry Screen to open the count input screen for the target location.
-
Click the Import From XLSX button.
The "Bulk Count Entry Import" modal appears. -
Click the Select File button and select the completed Excel file.
-
A preview appears. Check the target location, number of rows, and validation results.
- Open File rows to check the quantities and destinations of the rows to be imported. If you added an SKU, also check the lot, disposition, inventory segment, and other details.
- If quantities have already been entered, a message indicates that they will be replaced by the quantities in the file.
- If an error appears, check the details, correct and save the file, and select it again.
-
Review the preview and click the Import button.
A notification and count are displayed when the import is complete. Check the quantities and entry status of the count rows.
Importing alone does not complete count entry for the location. Once entry is complete, proceed to Complete Count Quantity Entry.
Complete Count Quantity Entry
-
Check the entered information and autosave status.
You can check entry progress under Count entry progress.
-
Click the Complete count entry button.
The "Confirm finishing count entry" modal appears. -
Check the displayed information and click the button.
-
If you entered count quantities for all rows, click the Complete count entry button.
-
If there are rows with no quantity entered, a button appears to record those rows as
0and complete entry.
Check whether it is appropriate to record them as0without counting, and click the button if you want to complete entry.For example, if one row has not been entered, Record 1 uncounted rows as zero without counting and complete is displayed. The number displayed changes according to the number of unentered rows.
If you do not want to record them as
0, click Return to entry and enter the count quantities.
If successful, count entry for the location is completed and the count session details page opens.
-
Important Notes
Entry Methods and Blank Fields
A blank count quantity field is not treated as 0. If the quantity is 0, enter 0.
- If you clear a manually entered quantity, the row returns to the not-entered state.
- Rows with a blank
Counted Quantityin the Excel template are not imported, and previously recorded quantities are not changed.
Checking Scans
If the same code is scanned again less than 0.5 seconds after the previous scan, it is treated as a duplicate and is not added. Quantities exceeding theoretical stock can also be recorded with a warning.
Barcode scanning does not automatically identify the lot or inventory segment of the physical item.
If stock is managed by lot or inventory segment, check the quantities for each lot or inventory segment and correct them manually if needed.
Entering and Importing the Excel Template
Before Downloading
Before downloading the Excel template, check that Autosave shows All entries saved.
Entering Information in the Template
When recording quantities for existing rows, do not change the SKU, location, lot, expiration date, disposition, or other information included at download. Do not delete or edit hidden columns or sheets in the template.
To add an SKU, enter the required information in an empty row. Do not copy an entire existing row, and leave the hidden identification information in the added row blank.
If lot, expiration date, disposition, or inventory segment is left blank, information from an existing count row may be applied. To record specific information, enter the relevant fields and check the import destination in the preview.
Importing the File
When you import a count row with an entered quantity, the quantity is replaced by the file's Counted Quantity. Changes made by another person after download or preview may also be overwritten, so coordinate work on the same location with other staff.
The file must be in .xlsx format, no larger than 5 MB, and contain no more than 5,000 data rows. Blank rows also count toward the row limit. If the target location exceeds 5,000 rows, a template containing the target data cannot be generated. A file containing rows for locations other than the current location cannot be imported.
If an error prevents import, valid rows cannot be saved separately; the entire import fails.
After an Excel import, scans made before the import cannot be undone using the Undo The Last Scan button.
Completing Entry with Unentered Rows
If unentered rows remain, you may be asked whether to record the uncounted rows as 0 and complete entry.
Reflecting Stock Quantities
Entering count quantities, autosaving, importing an Excel file, or completing entry for a location alone does not change stock quantities in the system. Stock quantities are updated through an inventory adjustment after count differences are reviewed and approved.
Checking Save Status
Before leaving the screen, check the autosave status and make sure the entered information has been saved.
Permissions for Entering Count Quantities
If you cannot enter or save count quantities, ask your manufacturer organization's primary owner, owner, or administrator to check your access to the target brand and inventory permissions.
For information on assigning roles, see Grant Roles to Members.