Parts Inventory Control System

keyboard_double_arrow_right

We want to efficiently manage the receipt of goods that are received in bulk by case...

We want to streamline the paper-based checks and management tasks from receipt to shipping...

In such cases!

・Register receipt and shipping records by scanning the QR code attached to the case using a handy terminal for each sequentially numbered case
・Adopting a handy terminal that can be operated with one hand so that both hands are not occupied during checks

keyboard_double_arrow_right

Manage the status of receipt, inspection, and shipping operations by grouping assembly parts of products at the level of component parts.

We want to check the number of received components and confirm any shortages after inspection...

In such cases!

・Display the receipt status of components for each assembly (Assy), including total received quantity, good product rate, and remaining shipping quantity in a list
・Check the registered receipt, inspection, and shipping records on a sequential number basis
・Possible to display the status of component operations by date

devices

Introducing the App Screens

① Select operation ② Scan the tag
Select the operation and scan the QR code
Each operation is assigned to a button on the handy terminal, allowing for one-handed operation.
Perform various operations by scanning the QR code attached to the case containing the product.

③ Enter quantity ④ Enter serial number ⑤ Register
Workflow for receipt operations
The operations for receipt, inspection, and shipping are fundamentally simple: "enter serial number," "enter quantity," "confirm details and register." The handy terminal supports one-handed operation and simple functions, and it also allows for consecutive registration of serial numbers, enabling smooth execution of each task.

⑤ List of receipt records ⑥ Component receipt status
Group products by assembly (Assy) and components, displaying the receipt, inspection, and shipping status by serial number.
Display the status of receipt, inspection, and shipping in order, allowing you to visually understand the current status and quantity of each serial number.
In the inspection and shipping status, the quantity of defective parts, which cannot be shipped, is also displayed. Quickly identifying defective parts is important for arranging replacements or adjusting supplier invoices.

⑦ Receipt status by date
Display the receipt status by date, showing which tasks were completed on which day.
To reduce visual clutter due to the large amount of data, sequential numbers with the same work date and status are grouped using the "〜" symbol, and the total number is displayed below.
In addition to viewing by date, you can also grasp the total status by component and by status.
In response to requests for a table format similar to the traditional Excel management, we provide an interface resembling Excel.

library_books

List of Features

Functionality	Details
WEB Management Screen
Login	Log in with login code and password
User Management	Display a list of registered users
└ CSV Download	Download registered user information as a CSV file
└ CSV Upload	Add and upload users to register them
└ External User Management	Create, enable/disable, and reset passwords for external users
Product/Assy/Component Transaction History	List of receipt records
└ Component Receipt Status	Check the receipt, inspection, and shipping status of each component by Assy code
└ CSV Download	Download the current component receipt status as a CSV file
└ Receipt Status by Date	Check the component receipt status data by date
└ Quantity Change / Record Deletion	Change/delete the registered quantity of selected records
└ CSV Download	Download the current component receipt status as a CSV file
└ Product Receipt Status	Check the receipt status of finished products
Outbound History	Display the history of outbound transactions (shipments)
└ Deletion	Delete the record of the corresponding line
└ Modification	Change the shipment date for the corresponding day
└ CSV Download	Download outbound history as a CSV file
Terminal Application
Login	Enter user ID to begin
Operation Selection	Select operation from receipt, inspection, shipping, to label printing
QR Code Scan	Scan the QR code on the product sheet
Receipt
└ Quantity Input	Enter the quantity to be received
└ Serial Number Input	Enter the serial number to be received
└ Next Serial Number Input	Enter the next serial number with the same product code
└ Register	Confirm entered serial numbers and quantities, then register
└ Print & Register	Print sequential labels, confirm serial numbers and quantities, then register
└ Substitute Product	Enter the number of boxes and issue
└ Print	Issue labels
└ Register	Confirm entered number of boxes and quantities, then register
└ Duplicate Serial Number	Proceed with registration as A serial number
└ Print	Issue labels
└ Register	Confirm entered A serial number and quantity, then register
Inspection
└ Serial Number Input	Enter the serial numbers for inspection. Check the box if the serial number is an A serial number or D serial number
└ Quantity Input	Enter the quantity of good items
└ Register	Confirm entered serial numbers, receipt quantity, and inspection quantity, then register
Shipping
└ Determine Shipping Pallet	Select existing or new pallet
└ Scan Product Invoice	Scan the target product invoice
└ Print Label	If it's a new pallet number, print a label
└ Confirm Pallet Number	Pallet numbers are automatically assigned
└ Use Existing Pallet	Select an existing pallet
└ Enter Pallet Number	Enter an existing pallet number
└ Reprint Label If Necessary	Reprint labels for entered pallets
└ Clear Pallet	After confirmation dialog, the result is deleted, and it returns to the product invoice scan screen
└─ Ship	Scan product invoice
└ Enter Serial Number of Interest	Check if the serial number is A or D serial number
└ Change Quantity	Enter the quantity
└ Continuous Input	Enter the next serial number for the same product, Assy, or part code
└ Input Another Part	Return to the product invoice scan screen
└ Complete This Pallet	Move to the shipping registration screen
└ Transfer Shipping	Move to the shipping registration screen as a transfer shipping if it's a different product invoice associated with the pallet
└─ Shipping Registration Screen	Confirm pallet number and other part information
└ Register	Register the results and return to the product invoice scan screen
Label Printing
└ Display Serial Information	Displays the information of the last serial number registered by the logged-in user for the relevant product invoice
└ Print	Print labels for the entered serial numbers

build

Customization Success Stories

We are creating reports using Excel VBA, but I want the system to generate reports instead...
We want to register the work results of subsidiaries that are not provided with handheld terminals...

ー Customization Details ー

①Added a custom report download feature tailored to user-defined formulas.

By default, the system allows downloading CSV files of registered actual data. However, it's now possible to create custom reports based on the calculation methods desired by the user. This eliminates the step of importing downloaded data into user-created tools like Excel VBA, enabling users to directly download the desired reports from the system.

②Added a data registration feature via CSV upload.

By writing data into a CSV file and uploading it, users can now register data in bulk from the web management interface. This allows for checking the overall status of arrivals.