Adjustments

Form ID: (IN303000)

Note:

This form is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.

On this form, you can create, view, and edit adjustments. You can save adjustment documents with the On Hold or Balanced status and release them. The processing of adjustment documents depends on certain settings on the Inventory Preferences (IN101000) form. By default, adjustments are saved with the On Hold status 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 the general ledger if the Automatically Post on Release option is selected.

For more information about adjustments, see Inventory Transactions.

Form Toolbar

The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.


Command	Description
Hold	Changes the status of the adjustment to On Hold. You click this button when you want to make changes to the document or to pause its processing.
Inventory Edit Details	Navigates to the Inventory Edit Details (IN611000) report.
Inventory Register Detailed	Navigates to the Inventory Register (IN614000) report.
Release	Initiates document release, which changes the status of the adjustment to Released.
Remove Hold	Changes the status of the adjustment from On Hold to Open. You click this button when the adjustment is ready for further processing.

Summary Area

In this area, you can select an existing adjustment by its reference number or specify summary information about a new adjustment.


Element	Description
Reference Nbr.	The unique reference number of the adjustment, which the system automatically generates according to the numbering sequence assigned to adjustments on the Inventory Preferences (IN101000) form.
Status	The status of the adjustment. The following options are available: On Hold: The document is a draft and can be edited. An adjustment with this status cannot be released. Balanced: The document's data has been validated by the system, and the document can be released. A document with Balanced status can be modified or deleted, but changes can be saved only if the receipt remains balanced. Released: The document has been released. Documents with this status cannot be edited or deleted.
Hold	A check box that indicates (if selected) that the adjustment has the On Hold status. Clear the check box to save adjustment with the Balanced status. The Hold check box is selected for new adjustments by default if the Hold Documents on Entry check box on the Inventory Preferences (IN101000) form is selected.
Date	The date when the adjustment was created. All transactions included in this document will have this transaction date. You can enter only a date that corresponds to a financial period that has been generated on the Master Financial Calendar (GL201000) form. If the date that you enter belongs to a financial period that has not yet been generated in the system—for example, for a date in the distant future or past—the system will display an error message, and you will not be able to save the document.
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.
PI Count Reference Nbr.	The reference number of the physical inventory document related to the adjustment.
Description	A brief description of the document or the transactions entered.
Total Qty.	The total quantity of inventory items specified in the adjustment.
Control Qty.	The manually entered quantity of items specified in the adjustment. Enter this value manually to confirm the total adjusted quantity of inventory item as compared to the automatically calculated quantity of inventory 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. Control Qty. is available only if the Validate Document Totals on Entry option is selected on the Inventory Preferences (IN101000) form.
Total Cost	The total cost of inventory items listed in the adjustment.
Control Cost	The manually entered cost of inventory items listed in the adjustment. 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. Control Cost is available only if the Validate Document Totals on Entry option is selected on the Inventory Preferences (IN101000) form.

Details Tab

The Details 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. You should correct the data before you try to save or release the document.

Note:

If you import data from an Excel spreadsheet into a table, and an item in the spreadsheet has the Inactive or Marked for Deletion status, this item will not be uploaded.

Table 1. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Add Item	Opens the Inventory Lookup dialog box so that you can add items to the adjustment document.
Inventory Summary	Opens the Inventory Summary (IN401000) form as a pop-up so you can view item availability data.

Table 2. Table Columns
Column	Description
Branch	The branch that created the adjustment.
Inventory ID	The inventory item for which an adjustment is performed. Inventory items are maintained on the Stock Items (IN202500) form.
Subitem	The subitem code of the inventory item for which adjustment is performed. This column is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form. Important: The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Warehouse	The warehouse where the inventory item (whose quantity or cost is being adjusted) is located. This column appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Location	The warehouse location where the inventory item is located. This column appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Cost Layer Type	The type of the cost layer affected by the inventory transaction in the row. The following options are available: Normal (default): The cost layer for inventory transactions that are not related to project tracked by quantity and cost. This option is used if the non-project code is selected in the line, or if the selected project has the Track by Location or Track by Project Quantity option selected in the Inventory Tracking box on the Summary tab of the Projects (PM301000) form. Project: A project-specific cost layer for inventory transactions which are created for project items. This option can be used only for projects that have the Track by Project Quantity and Cost option selected on the Inventory Tracking box on the Summary tab of the Projects (PM301000) form. This column appears only if the Project-Specific Inventory feature is enabled on the Enable/Disable Features (CS100000) form. For more information, see Project Inventory Tracking: Item Availability Tracking.
Quantity	The quantity of the inventory item for adjustment (in the units of measure indicated below).
UOM	The unit of measure (UOM) used for the inventory item.
Lot/Serial Nbr.	The lot or serial number of the inventory item (enabled for selection only if the line item requires the lot or serial number). This column appears only if the Lot and Serial Tracking feature is enabled on the Enable/Disable Features (CS100000) form.
Expiration Date	The expiration date of the inventory item with the selected lot or serial number if the expiration dates are tracked for the item. This column appears only if the Lot and Serial Tracking feature is enabled on the Enable/Disable Features (CS100000) form.
Unit Cost	The cost of a single unit of the inventory item.
Ext. Cost	The extended cost of the inventory item in the adjustment, calculated automatically as the unit cost multiplied by the quantity on the adjustment line. The value can be edited manually later—for example, to round the value.
Manual Cost	A read-only check box that indicates (if selected) that the value in the Unit Cost box has been edited. The system automatically selects this check box when you edit the unit cost of an item in the Unit Cost box.
Receipt Nbr.	The reference number of the receipt to be adjusted by this adjustment line.
Reason Code	The reason code of the inventory item's adjustment transaction.
Description	A brief description of the adjustment transaction.
PI Line Number	The line number of the item of the current line in the PI document that corresponds to the adjustment.

Table 3. Inventory Lookup Dialog Box
You use this dialog box to view the item availability information for various warehouses and warehouse locations (if the *Multiple Warehouse Locations* feature is enabled on the Enable/Disable Features (CS100000) form) and to add the required quantity of the item to the document. To find an item, you can type a string from its inventory ID in the Inventory box.

The dialog box has a Selection area and a table with items that meet the criteria you specify.
Element	Description
Inventory	The identifier or description of the stock item that you want to find. You type a string from the item's inventory ID or description to find the item or leave the box blank to filter information by other criteria.
Barcode	An alternate ID of a stock item that you want to find. You can type a string from the item's alternate ID of the Barcode or GTIN/EAN/UPC/ISBN type specified for the item on the Cross-Reference tab of the Stock Items (IN202500) form. You can also leave the box blank to filter information by other criteria. For more details on alternate IDs, see Managing Item Cross-References.
Item Class	The item class of the items whose information you want to view. Leave the box blank to view information on items of all classes.
Show Available Items Only	A check box that you select if only items whose available quantities are greater than zero should be listed in the table.
Subitem	The subitem code. Leave the box blank to view information on items with different subitems. This box is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form. Important: The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Warehouse	The warehouse where the item are stocked. Leave the box blank to view items from all warehouses. This box is available for selection only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Location	The location in the warehouse. Leave the box blank to view items in all locations. This box is available for selection only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
The table in the dialog box has the following columns.
Included	An unlabeled check box that, if selected, indicates that the item of inventory has been chosen to be added to the document.
Qty. Selected	The quantity of sales units of the stock item (under the specified inventory ID and subitem code) that you want to add to the document.
Site	The warehouse where the items are stocked. This box is available for selection only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Location	The location in the warehouse. This box is available for selection only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form.
Inventory ID	The stock item by its inventory ID.
Subitem	The subitem code for the particular size, color, or other variation of the product. This column is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form. Important: The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Description	The description of the item with the specified inventory 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 and location.
Qty. on Hand	The quantity on hand of this item at the specified warehouse and location.
The dialog box has the following buttons.
Add	Adds the selected items.
Add & Close	Adds the selected items and closes the dialog box.
Cancel	Cancels the changes and closes the dialog box.

Financial Tab

This tab displays the reference number and branch of the batch generated upon release of the adjustment. A batch is not generated if the Update GL option on the Inventory Preferences (IN101000) form is not selected.


Element	Description
Batch Nbr.	The reference number of the batch generated for the transfer. Click the number to open the Journal Transactions (GL301000) form and view the transactions' details.
Branch	The branch associated with the adjustment.
Ignore Item Allocations	A check box that indicates (if selected) that you can release an adjustment with a negative quantity of a stock item. The negative quantity will affect allocations in the following documents: Sales orders on the Sales Orders (SO301000) form Kit assembly documents on the Stock Components tab of the Kit Assembly (IN307000) form Service orders on the Service Orders (FS300100) form Production orders on the Production Order Details (AM209000) form By default, the check box is cleared for an adjustment that has been generated from a physical inventory count or created directly on the current form. By default, the check box is selected for an adjustment related to manufacturing. As a result, this adjustment is automatically released.
Currency	The currency ID of a base currency. This box appears only if the Multiple Base Currency feature is enabled.

Manufacturing Tab

This tab displays the reference number and branch of the batch generated upon release of the adjustment if the adjustment was created on forms related to production management. For these adjustments, the Description box in the Summary area contains Production Transaction.

This tab is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features (CS100000) form.


Element	Description
MFG Batch Nbr.	This is a link to the production management transaction that created the inventory adjustment. Clicking on the link opens the source form.
MFG Document Type	This identifies the source form that created the adjustment and will be the batch number created by using the Materials (AM300000) or Labor (AM301000) form.