Stock adjustment

Use this page to change the quantity for an item on existing transactions or movements.

Create a stock adjustment

You can increase or decrease the quantity for a standard costed item or an average costed item:

1. Select Create.
2. Select the Site, the Adjustment reason and the Date.
3. Leave the number blank to generate the next sequential stock adjustment number or enter your own reference.
4. Select the Add line icon from the Documents lines grid.
5. Select the Item.
6. Enter the Adjustment quantity. The New stock quantity is automatically updated.
7. If locations are managed in the site, select the Location.
8. Select the Status.
9. Select the More actions icon from the grid line to add stock details.

Stock quantity decrease

If you decrease the stock quantity, the Stock issue details window displays all the stock lines that are available for the selected item.

Lot managed items

1. Select the stock lines and enter the Quantity to issue on each selected line.
2. Select the lot number.
3. Select OK, then Save.

Serial number managed items

1. Select the stock lines and enter the Quantity to issue on each selected line.
2. The Serial numbers grid displays. You need to select the serial numbers to issue.
   1. Select Add line.
   2. In the From serial number field, select the first serial number.
   3. The quantity defaults to 1. You can change it to select a range of serial numbers. In this case, the quantity you enter needs to match the quantity of serial numbers available in the range. The last serial number from the serial number range displays in the To serial number field.
   4. You can add different lines to select different ranges of serial numbers or select the serial numbers one by one.
3. Select OK, then Save.

Stock quantity increase

1. Select Add line from the grid.

2. Enter the stock line information. You can add different stock lines to split the total quantity on different stock details.

   • When the item is lot managed, you can select an existing lot number or enter a new one. For a new lot number, the New label displays in the list next to the lot number and the New lot checkbox is automatically selected. You can also leave the lot number blank. In this case, the New lot checkbox is automatically selected. The new lot number is automatically assigned based on the sequence number when you post the adjustment.

     When you enter a lot number that already exists, it could display several times in the selection list. It means that different sublots are already associated with this lot number. Select a lot number and enter the sublot number.

     You can enter the Supplier lot number. It is automatically displayed, and you cannot change it when the lot number already exists and is already associated with a supplier lot number.

   • When the expiry date is managed, you need to enter the date if it is a new lot number.

   • When the item is sublot managed, you need to enter the sublot number. The sublot number is automatically displayed if the lot number is already associated with a single sublot. You can change it and create a new one. If the lot number is associated with different sublots, you need to enter the sublot number or create a new one.

     When you enter or change the sublot number, the New lot checkbox is automatically selected. It means that a new combination of lot number and sublot number is created when you post the adjusment.

   • When the item is serial numbered, To be generated is displayed in the Serial number field. Serial numbers are automatically generated based on the sequence number when you save the adjustment.

3. Select OK, then Save.

   When the item is serial numbered, you can display the generated serial numbers. From the More actions icon, go to the Stock receipt detail window. From the More actions icon, select Serial numbers.

Assign dimensions

You can assign dimensions to lines that have a Details required, Details entered or Stock posting error status.

1. Select the More actions icon from the line, then select Dimensions.
2. You can select a dimension for each dimension type.

Manage dimensions

Stock adjustment lines can inherit dimensions and attributes from the site, item or from both. For this, dimensions and attributes need to be set on the site record or item record, and default dimension rules need to be set on the company record, on the Dimensions tab. When you create a stock adjustment, the dimensions default on the lines from those defined for the site, item or both.

If default dimension rules are not set for the company, you can add dimensions directly on the stock adjustment lines. You can add and change dimensions on each line individually. Or, when you create the stock adjustment you can add the dimensions for all lines and then change them individually later if required.

To manage dimensions for individual lines:

1. From the More actions icon on the line, select Dimensions.
2. Select the dimensions you want for the line.
3. Save.

To manage dimensions for all lines:

1. From the More actions icon on the record, select Set dimensions.
2. Select the necessary dimensions.
3. Select Apply to all lines to apply the dimensions to all the existing and future lines or Apply to new lines only to apply the dimensions to future lines only.

Post a stock adjustment

Select Post stock to generate the stock movements.

The status changes automatically from Details entered to Stock posting in progress, then to Adjusted if the post is successful or Stock posting error if the post fails.

When you successfully post the stock adjustment, the Posting tab displays, where you can navigate to the associated journal entry record and monitor the posting status of the stock adjustment.

Edit or delete a stock adjustment

To edit or delete a line in the Documents lines grid:

1. Select the stock adjustment from the list.
2. Make the changes as needed.
3. Select Save or Delete from the grid line.

To edit or delete the stock adjustment record:

1. Select the stock adjustment from the list.
2. Make the changes as needed.
3. Select Save or Delete.