Stock adjustment

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

To search and display a stock adjustment, go to the Stock journal inquiry page. All costs are in the financial site currency.

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.
You can select different stock lines to split the quantity between different stock details until the total quantity reaches the Required quantity.

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 receipt.

      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 expiration 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 receipt.

    • 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 receipt.

  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 Draft or 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 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. Select Set default dimensions on the Document lines grid.
  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.
You can only set dimensions for all lines of a stock issue when you initially create it and before you save the document.
The Dimensions dialog box at record level displays the dimensions set for the site, if any, and if default dimension rules are set for the company. You can use this dialog box to apply dimensions to all lines, but changes are not saved in this dialog box. The dimensions on the lines, not the ones in this dialog box, are transferred to the subsequent document lines. A dimension from an item is inherited when the item is added to a line, not from the dimensions set at the record level.
Dimensions apply to lines that are Draft.

Post a stock adjustment

Select Post stock to generate the stock movements.

The Stock status changes automatically from Draft to In progress, then to Completed.

The Stock status column no longer displays after posting the stock adjustment.

Edit or delete a stock adjustment

You can edit the stock adjustment only when the Stock status is Draft.

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.