Adjustments (IN303000)
In this window, you can create, view, and edit adjustments. You can save adjustment documents with the status On hold or Balanced and release them.
The processing of adjustment documents depends on certain settings in the Inventory preferences (IN101000). By default, adjustments are saved with the statusOn hold if the Hold documents on entry option is selected.
Adjustment totals are validated on entry if the Validate document totals on entry option is selected. When an adjustment is released, its transactions are posted to general ledger if the Automatically post on release option is selected.
For more information about adjustments, see About inventory transactions.
## Search line in list window If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view. There are two types of search fields: + White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or **%** and get different results: + space: the result contains the words in any order, + **%**: the result contains the words in the specific order, and the **%** functions as a wildcard as well. + Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.The window toolbar
| Button | Description |
|---|---|
| Release | Initiates document release, which changes the status of the adjustment to Released. |
| Reports | Provides direct access to the following inventory reports: |
The top part
In this area, you can select an existing adjustment by its reference number or specify summary information about a new adjustment.
| Element | Description |
|---|---|
| Ref. no. | The unique reference number of the adjustment, which the system automatically generates according to the numbering sequence assigned to adjustments in the Inventory preferences (IN101000). |
| Status | The status of the adjustment. The following options are available:
|
| Hold | A check box that, if selected, indicates that the receipt has the On hold status. Clear the check box to save adjustment with the Balanced status. |
| Date | The date when the adjustment was created. All transactions included in this document will have this transaction date. |
| Post period | The financial period to which the transactions from the adjustment should be posted. |
| External ref. | Any external reference number of the inventory adjustment document. |
| Description | A brief description of the document or the transactions entered. |
| Total qty. | The total quantity of stock items specified in the adjustment. |
| Control qty. | The manually entered quantity of items specified in the adjustment. Note This field is only available if the Validate document totals on entry option in the Inventory preferences (IN101000) is selected. Enter this value manually to confirm the total adjusted quantity of stock item as compared to the automatically calculated quantity of stock items included in this document. If the Control qty. and Total qty. values do not match, the system generates a warning message and the document cannot be saved. |
| Total cost | The total cost of stock items listed in the adjustment. |
| Control cost | The manually entered cost of stock items listed in the adjustment. Note This field is only available if the Validate document totals on entry option in the Inventory preferences (IN101000) is selected. Enter this value manually to confirm the total cost as calculated automatically for the document. If the Control cost and Total cost values do not match, the system generates a warning message and the document cannot be saved. |
The Transaction details tab
This tab contains the list of transactions included in the adjustment document. The system automatically validates the data upon entry, flagging incorrect data with error indications. Correct the data before you try to save or release the document.
| Button | Description |
|---|---|
| Add item | Opens the Item lookup dialog box so that you can add items to the adjustment document. |
| Inventory summary | Opens the Inventory summary (IN401000) window as a pop-up so you can view item availability data. |
The Item lookup dialog box
You use this dialog box to view the item availability information for the selected source warehouse and its locations and to add specific quantities of the items to the transfer document.
To find an item, you can type a string from its item ID in the Item field.
| Element | Description |
|---|---|
| Item | The identifier of a particular item whose information you want to view. Leave the field blank to filter information by other criteria or type a string from the item ID to find the item. |
| Barcode | The barcode of the item to be listed. Leave the field blank to filter information by other criteria. |
| Item class ID | The item class of the items whose information you want to view. Leave the field blank to view information on items of all classes. |
| Show available items only | If you select this check box, the system will list only items whose available quantities are greater than zero in the table. |
| Warehouse | The warehouse where the item are stocked. Leave the field blank to view items from all warehouses. Note This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location in the warehouse. Leave the field blank to view items in all locations. Note This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Column | Description |
|---|---|
| Qty. selected | The quantity of the stock item (under the specified item ID and subitem code) in the base units that you want to add to the transfer. |
| Warehouse | The warehouse where the items are stocked. |
| Location | The location in the warehouse. Note This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Item ID | The stock item by its item ID. |
| Description | The description of the item with the specified item ID and subitem code. |
| Base unit | The unit of measure used as a base unit for the stock item. |
| Qty. available | The available quantity of this item at the specified warehouse. |
| Qty. on hand | The quantity on hand of this item at the specified warehouse. |
| Button | Description |
|---|---|
| Add | Adds the selected items. |
| Add and close | Adds the selected items and closes the dialog box. |
| Cancel | Cancels the changes and closes the dialog box. |
The Financial details tab
This tab displays the reference number and branch of the batch generated upon release of the adjustment. If the Update general ledger option in the Inventory preferences (IN101000) window is not selected, there will be no batch.
| Element | Description |
|---|---|
| Batch no. | The reference number of the batch generated for the transfer. Click the number to open the Journal transactions (GL301000) window and view the transactions’ details. |
| Branch | The branch associated with the adjustment. |