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.

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

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 adjustment is performed. The list of inventory items is maintained using 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 form.

Important: The Inventory Subitems check box has been removed from the Enable/Disable Features 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 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 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 on 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 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 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 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 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 of a particular item whose information you want to view. Leave the box blank to filter information by other criteria or type a string from the item's inventory ID to find the item.
Barcode The barcode of the item to be listed. Leave the box blank to filter information by other criteria.
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 form.

Important: The Inventory Subitems check box has been removed from the Enable/Disable Features 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 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 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 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 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 form.

Important: The Inventory Subitems check box has been removed from the Enable/Disable Features 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.
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.