|
|
|
|
This page allows you to update serial numbers and authorize the adjustment transaction. Tell me more
Select “Update Serial Nos.” link at the bottom of the “Edit Adjustment” page.
The “Update Serial Number.” page appears.
The system displays the following:
|
Status |
The status of the transaction. |
|
Transaction No. |
A unique number identifying the transaction. |
|
Transaction Date |
The date on which the transaction took place. |
|
Warehouse Code |
A unique code identifying the warehouse. |
|
Adjustment Type |
The type of stock adjustment. The system displays one of the values, “General”, “PI Plan” or “CC Sheet Based”. |
|
PI Plan No. |
The number identifying the physical inventory plan. |
|
Cycle Count Sheet No. |
The number identifying the cyclic count sheet. |
Modify the following if required:
|
Line No. |
Use the drop-down list box to specify the line number of the serially controlled item. The system generates this number sequentially for every line containing an item code in the main page. All the line numbers for the item codes defined in the “Edit Adjustment” main page for which the serial controlled option is set as “Yes” will be displayed here in ascending order. |
The system displays the following:
|
Item Code |
A unique code identifying the item. |
|
Variant Code |
Variant Code of the item. |
|
Item Variant Desc. |
A textual description of the item variant. |
|
|
Zoom facility available |
|
Stock UOM |
The unit of measurement of the stock stored in the warehouse. |
|
Adjustment Qty. |
The total number of units of the particular item adjusted in the warehouse. |
|
Stock Status |
The stock status of the items stored in the warehouse. |
|
Zone |
The unique number identifying the zone in the warehouse. |
|
Bin |
The unique number identifying the bin under the zone. |
|
Lot No. |
The number identifying the lot. |
The system displays the following in the “Serial No. Information” multiline:
|
Serial No. |
The unique number identifying the serial controlled item. |
Modify the following in the “Serial No. Information” multiline if required:
|
Status |
Use the drop-down list box to select the status of the serially controlled item. The system displays the following options:
|
Check the “Select” column in the multiline to modify the financial information of the adjustment transaction, create serial information and attach notes
Click the “Update Serial No.” pushbutton to update the serial number information.
The system checks whether the “Serial no. unique across items” is set as “Yes”. If so, the system checks whether the newly added serial numbers are available in stock for other item/variants in the OU. If serial numbers newly defined are already available, the system displays an error message.
The system sets the status of the transaction as “Active” if all the following conditions are satisfied. Else, the status is set as “Draft”.
Serial number details are specified for all serially controlled items.
The adjustment value is specified for all items having positive adjustment when the system parameter “Allow modification of value during positive adjustments” is set as “No”.
The adjustment value is specified for all items having negative adjustment
The system parameter “Analysis/Sub analysis Code applicable” is set as “No”. If the parameter is set as “Yes”, then account codes must have been mapped to the analysis/ sub analysis codes.
For zero quantity adjustments, either serial number or value adjustment has been performed.
Click the “Edit And Authorize Adjustment” pushbutton to modify and authorize the adjustment transaction.
The system sets the transaction as “Authorized”
The system updates the stock maintenance for addition or reduction of stock quantity and value depending on whether the adjustment is positive or negative. The system updates the serial management if serial number adjustments are being made.
The system updates the stock value for the item/variant directly if the adjustment is only for the value and not the quantity, the costing method is WAR/LFL and adjustment value method is specify value. The system updates the stock value for the item/variant directly if the adjustment is only for the value and not the quantity, the costing method is WAR/LIFO/FIFO and adjustment value method is specify receipts.
The system updates the dispositionable quantity if the adjustment is positive or negative, the stock status is nettable and the item/variant is disposition controlled.
Click the “Delete Adjustment” pushbutton to delete the stock adjustment transaction
The system sets the status of the transaction as ”Deleted”.
The system deletes the details of the selected transaction and saves the login id of the user and the date of creation along with the modification details.
To proceed, carry out the following
Select “Edit Financial Information” link at the bottom of the page to modify the financial information for the adjustment transaction.
Select “Maintain Serial No. Information” link at the bottom of the page to create and modify serial number information.
Select “Attach Notes” link at the bottom of the page to attach notes for the serial numbers.
Update Serial Numbers – An Overview
|
|
Serial number adjustment can be done only for items having zero quantity adjustment. Serial numbering of items is highly prevalent in discrete manufacturing industries. For example, airlines industry, automobile industry uses serial numbering widely for costly items like engine, shafts, etc. Serial Numbering enables easy traceability of items by pinpointing the exact physical location and condition of an item. This page is launched only if atleast one of the items in the “Edit Adjustment” main page is serial controlled. Else, the system displays an error message.
This adjustment is required when the serial numbers physically available and those displayed by the system do not match. In such cases, this page allows you to add serial numbers that are available in the warehouse and remove those that are not physically present from the system stock. For example, if the adjustment quantity is specified as +10 to make the system stock equal to the physical stock of 100, you need to specify 10 new serial numbers. However, if you detect that of the 10 new serial numbers added, 5 are physically present but another 5 are not, then you must delete the 5 serial numbers not physically available and add 15 new serial numbers to balance the system and physical inventory count.
If the adjustment type is PI based or CC sheet based, then system retrieves all the serial numbers saved in the main page for the selected number from the adjustment transaction and sets the status as “For addition”. If the serial numbers are to be deleted to perform adjustment for the selected line number, the system sets the status of the serial number as “For deletion”. The retrieved details cannot be modified for PI based and CC sheet based items.
If the adjustment type is “General”, the system retrieves all the serial numbers for the selected line number in the page that are available in the warehouse zone/bin combination and sets the status of the serial number as “In stock”. If new serial numbers have been added for the selected line number, then the status is set as “For addition”. The serial numbers to be marked for deletion are set to “For deletion” status. These details can however be modified using this page.
The adjustment quantity is calculated as follows for each of the three adjustment types:
Adjustment quantity = No. of serial numbers newly added – No. of serial numbers marked for deletion, if the adjustment type is positive.
Adjustment quantity = No. of serial numbers marked for deletion – No. of serial numbers newly added, if the adjustment type is negative.
Adjustment quantity = No. of serial numbers marked for deletion = No. of serial numbers newly added, if it is zero quantity or value adjustment.
