Inventory Adjustments

This screen allows you to make miscellaneous Inventory Adjustments. These adjustments can be either positive (Receipts) or negative (Issues) quantities.

The process for Inventory Adjustments comprises the following Steps

•	Create an Adjustment Batch

•	‘Save’ the Batch Header and go to the ‘Lines’ tab

•	Add Lines to the Batch - separate line to cover each stock adjustment

•	Go back to the Batch Header

•	Post the Batch - Ostendo generates the stock movements

Note: Until a Batch is ‘Posted’ the stock movement will not be recorded against the included Item(s)

List Tab

Display fields

Adjustment No: This is the Adjustment Number as generated by Ostendo and provides a unique reference to the Batch.

Reference: The Reference attached to this Adjustment Batch as entered into the Details screen,

Status: The status of this Adjustment Batch. There are two statuses (In Progress and Updated), which are maintained by the program.

Adjustment Date: The date held against the Adjustment Batch. Initially this is the system date but it can be amended at any time prior to updating the Batch

Site Name: The name of the Site where this adjustment batch was made

Data Display Options

Field Position - On the List screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.

Filtering and Sorting - If you ‘check’ the checkbox then the displayed data is available for filtering and sorting:

•	To sort the data in a selected column simply click on the column heading. Clicking against will sort in descending order.

•	Click on the black ‘down arrow’ to the right of your selected column heading and you can either select a specific entry to display all records containing that entry, or you can select (Custom) to enter detailed selection criteria.

Include Updated Status - By default the display will only show Adjustment Batches that have not been updated. If you wish to see all batches including those that have been updated then ‘check’ this checkbox.

Searching - If you enter some text into the ‘Search’ field and click on the ‘binoculars’ Icon then all records will be interrogated and those records that contain the entered text will be displayed. To revert back to displaying all records click on the ‘Eraser’ Icon

Buttons

Close: This will close the Inventory Adjustments screen. If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

Add: This will bring up the ‘Detail’ tab for entry of a new Adjustment Batch.

Save: Not applicable to the List panel

Cancel: Not applicable to the List panel

Delete: This only becomes ‘active’ when linked to an Adjustment Batch with status ‘In Progress’. In this instance it enables you to delete the selected Batch.

Related: This will bring up a list of functions that are related to the Inventory Adjustment. You may open and maintain information in those screens whilst still remaining in the Inventory Adjustment screen.

Reports: This will bring up a list of Reports that are related to the Inventory Adjustment. You can immediately run the report whilst still remaining in the Inventory Adjustment screen.

Detail Tab

This tab enables you to create and maintain an Adjustment Batch Header. After creation of a Batch Header it must be saved (click on the ‘Save’ Button) before Lines can be added

Entry and Display fields

Adjustment No: This is a unique number automatically allocated by the program. It cannot be amended.

Status: This is the status of the Adjustment Batch and is maintained by the program. The displayed variants are:

In Progress - The Adjustment Batch is still being worked on

Updated - The Adjustment Batch has been ‘Posted’ and Stock movements created for the included Items

Reference: Enter a brief description of the Adjustment Batch. No validation checks will be carried out on this field.

Site Name: From the drop-down list select the Site at which the Adjustment is to be made.

Adjustment Date: This is prefilled with the system date. It can be amended at any time up to Posting the Batch by entering the date or by clicking on the drop-down menu and selecting the date.

Financial Category: Select the Financial Category for this Adjustment if applicable.

Post All Adjustments: If this button is selected then all the adjustments contained in the ‘Lines’ panel will be actioned and stock movement transactions created. The status of this Batch will then be amend to ‘Updated’

Company Style: (Customer / Supplier / None - default): This allows you to link the Chep pallet transaction to a Customer or Supplier.

Company Name: Select the name of the customer or supplier.

Notes: Extended Notes for your own information can be attached to this Adjustment Batch. Whenever you click on this field an icon will appear in the top-right. By clicking on this Icon you can bring up the Frequently Used Text table. Select the text to be copied and either press the OK Button in that screen or double-click the selected record.

Buttons

Close: This will close the Inventory Adjustments screen. If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

Add: This will bring up a blank ‘Detail’ screen for entry of a new Adjustment Batch.

Save: This will save the current data without exiting the screen

Cancel: Any changes made to the current Adjustment Batch Header record or the last time the ‘Save’ Button was pressed will be lost.

Delete: Not applicable to the Detail panel

Reports: This will bring up a list of Reports that are related to the Inventory Adjustment. You can immediately run the report whilst still remaining in the Inventory Adjustment screen.

Lines Tab

This tab enables you to add and maintain Adjustment lines. The Adjustment Batch Number and status will be displayed at the top of the panel.

Entry and Display fields

Warehouse: From the drop-down list select the Warehouse against which the adjustment is being made.

Location: From the drop-down list of Locations within the above Warehouse select the location where the adjustment is being made.

Item Code: From the drop-down list select the Item Number against which the adjustment is being made.

Description : The description of the item.

Unit: From the drop-down list of Units linked to the above Item Code select the Unit of Measure that applies to this Adjustment

Adjustment Type: From the drop-down list of Adjustment Types select the Type of adjustment being made against this Item. Adjustment Types are user-defined under Inventory>Settings>Adjustment Types.

Adjustment Quantity: Enter the quantity being adjusted. Note the following:

•	If the Adjustment is a Receipt then this quantity is a positive number

•	If the Adjustment is an Issue then this quantity is a negative number

•	If the Item is Serial Controlled then the Quantity must be 1 or -1

If the Adjustment Quantity is a negative then:

•	If it is Serial Numbered the Serial Number must exist

•	If it is Revision Level controlled then the Revision Level must exist

Adjustment Unit Cost: The current Cost of the Item is displayed. You have the option to adjust this cost if necessary. Note:- If it is a Receipt transaction then this Cost will be taken into account when re-calculating the current Average Cost.

Notes: Enter brief notes if required.

Variants: If the Item has ‘sub-level’ variants such as Serial Number, Batch Number, Colour, etc then the fields applicable to the Item will be available for entry of the variant. All variant fields that are not applicable will be ‘greyed out’. If the variation value is not entered then the Adjustment Transaction will not be accepted.

Buttons

Close: This will close the Inventory Adjustments screen. If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

Add: This will send the cursor to a new line for creation of a new Adjustment record.

Save: This will save the current line’s data without exiting the screen

Cancel: Any changes made to the current line record or the last time the ‘Save’ Button was pressed will be lost.

Delete: This will delete the selected Adjustment Line

Reports: This will bring up a list of Reports that are related to the Inventory Adjustment. You can immediately run the report whilst still remaining in the Inventory Adjustment screen.