Skip to main content

Lot Batch Adjustment(screen not updated)

Posted Wed, 05/27/2009 - 16:39 by li.biao

If the inventory computer records are varied with physical records, especially after stock take, users are required to use the 'Adjust' function to adjust the on-hand quantity or amount. But users are required to adjust each lot number one by one which is not so convenient. So we have provided a new function 'Lot Batch Adjustment' for users to adjust the quantity for multiple lot numbers. Please remind that this is not a daily operation and should be done adhore.

Adjustment Process: Create the adjustment document, select the lot numbers which need to be adjusted, then output to excel. Perform physical stock take based on this excel. Input or import the on-hand quantity after stock take. Finally, confirm the adjustment document. After confirmation, system will automatic create the Adjustment (ADJ) or Opening (OPN+) transactions.
Adjustment transactions include:-
1. Adjust the existing lot number on hand quantity to zero
2. Create new lot number
3. Adjust the existing lot number including adjust on-hand quantity and amount (either add or subtract), modify dye lot number, bin number and lot remark

Attention:-
1. We do not support reverse function. If you find that the data is incorrect after you confirm the adjustment document, then you need to perform adjustment again.
2. Users are allowed to delete adjustment documents. This deletions only apply to adjustment documents, it will not delete the replated adjustment transactions.

The adjustment procedures are as below:-

1. Create a new adjustment document, select those lot numbers which need to be adjusted.
The lot numbers color, size, quantity, bin warehouse information will be displayed on directory. You can export the data to excel file and perform physical stock take.

Please remind that those in-transist lot numbers and un-confirmed adjustment document lot numbers will not be shown.

2. Input the actual stock take quantity or import from excel file.

After the physical stock take, users are required to edit the adjustment document. When you open the adjustment document, system will ask you whether you want to start the adjustment process. If answer no, you can continue to add other lot numbers. If answer yes, you can adjust the on-hand quantity, add or delete records.

Attention points:-
a. Adjustment date is the physical stock take cut-off date, not necessary equal to the input/import date
b. Adjustment document remark will be saved to adjustment(ADJ) and opening(OPN+) transaction remarks
c. If unit price is not filled in, the adjusted amount will be calculated based on the original lot number unit price. If unit price is filled in, amount will be adjusted too.
d. Data can be freely inputted, but system will validate it. Firstly, system will check the existence of lot number/warehouse/dye lot. If it exists, system will check whether the material class, material code and stock unit are matched. If it does not exist, system will check whether the material class and material code exist. If it has errors when save the records, system will display the error message on the bottom line.

3. Compare the difference between adjusted data and computer records

This function can help users to check whether the adjusted data is correct.

4. Confirm the adjustment if no error finds after checking

System will base on the adjustment data and date and will create a adjustment(ADJ) transaction for each adjusted lot number. For new lot number, it will create a new stock card and opening(OPN+) transaction.

Attention:Lot adjustment function will adjust balance quantity only, it will not adjust job allocation. So after adjustment, please use the 'Exceptional Lot Management' function to find those exceptional records and adjusted them.

During the adjustment process, you can use excel files to import/export. You can refer the manual for import/export function or refer the procedures below.
1. Export the adjusted data

2. Input the adjusted data in excel

Steps:-
a. The 2nd line is the labels for the import program, please do not change them. Otherwise, data cannot be imported. The 3rd line is the system field name.
b. Allow adjusted the data which is same as adjust in the system
c. If actual quantity is not filled in, it defaults to be zero
d. If unit price is not filled in, it defaults to be the existing lot number unit price
e. Allow to input new lot number at the bottom of the form. If the lot number does not exist in the system, system will create a new record.

3. Import the adjusted data

Import is completed if the status changes from 'Update' to 'OK.
>