14.1.7 Registering actual stocktaking data (Confirm Stocktaking Device)
You can add to the Asset Management database the information for the devices for which stocktaking has been performed (results of stocktaking). This enables you to exclude those devices for which stocktaking has not been performed.
By default, only the administrator can register actual stocktaking data.
To register actual stocktaking data, start from the Confirm Stocktaking Device window, which is displayed by clicking the Confirm Stocktaking Device job menu. The following figure shows the Confirm Stocktaking Device window.
|
|
![[Figure]](GRAPHICS/ZU081300.GIF)
For Stocktaking data CSV file, specify the name of the CSV file that contains the actual stocktaking data.
You should check that the specified file is a CSV file. If a large file is specified and an error occurs, it might take a considerable amount of time before the error is reported.
- Format of the CSV stocktaking data file
-
The format of the CSV file to be registered to the asset management database as actual stocktaking data is shown below.
Table 14‒1: Format for registering stocktaking data Column
Item name
Description
Omissible
1
Asset No.
Specifies the asset number of the asset to be registered as a stocktaking-completed asset.
M
2
Stocktaking date
Specifies the stocktaking date according to the following format:
YYYY/MM/DD
O#
- Legend:
-
M: Mandatory
O: Optional
- #
-
If the stocktaking date is omitted, the date the CSV file is registered is used for the stocktaking date.
- Note
-
If you use Microsoft Excel to directly open and edit a CSV file to be registered into Asset Console, any leading zeros (0) are automatically deleted from codes, IDs, and other numbers that start with one or more zeros (0). As such, the values might be updated with values that are different from the original values. When using Microsoft Excel, use the Import Text File function to set the data format for columns to Text, and then read and edit the file.