Adjustments

Form ID: (IN303000)
Attention: 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 record.

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.

Attention: 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 so you can view item availability data.
Add Lot/Serial Nbr.

Opens the Add Lot/Serial Nbr. dialog box, which you use to add units with particular lot or serial numbers to the adjustment.

The button is available if the adjustment has the On Hold or Balanced status.

This button is displayed on the table toolbar only if the Lot/Serial Attributes feature is enabled on the Enable/Disable Features (CS100000) form.

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.

Inventory Source

The inventory source for which adjustment is performed.

If a project is specified in the line, the system populates Project Stock in this column. If the non-project code is selected in the line, the system populates Free Stock in this column.

This column appears on the form if the Projects feature is enabled on the Enable/Disable Features (CS100000) form.

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.

If the Project Accounting feature is enabled on the Enable/Disable Features (CS100000) form, you should define a reason code to be used for the issue of items for projects. For more information, see Project Material Management: Accounting for Project Stock.

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.

Cost Layer Type

The type of the cost layer affected by the inventory transaction in the row.

Attention: This column is obsolete and is preserved for backward compatibility. By default, the column is hidden. The value in this column is inserted automatically based on the combination of the inventory source selected in the line and the inventory tracking mode selected in the corresponding project.

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.

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.
Table 4. Add Lot/Serial Nbr. Dialog Box

You use this dialog box to select the units of a stock item with lot or serial numbers to be added to the document and to view the availability details for these units. The system adds one row per unit for serial numbers, and for lot numbers, one row for all units of a particular lot number. You can also view the lot or serial attributes of these units if they have been configured and their values have been specified.

This dialog box is available only if the Lot/Serial Attributes feature is enabled on the Enable/Disable Features (CS100000) form.

Element Description
The Selection area of the dialog box has the following elements, which you can use to narrow the units listed in the table.
Lot/Serial Class The lot or serial class of the stock items whose units you want to view in the table.

You can select a lot or serial class only if the tracking method of the class is either Track Serial Numbers or Track Lot Numbers and the assignment method is When Received.

Inventory Item The stock item whose units you want to view in the table.

You can select units of a stock item whose lot or serial class has the Track Serial Numbers or Track Lot Numbers tracking method and When Received assignment method.

Search

A box that you can use to search for units by entering text that may be specified in the searchable table columns. You enter a text string, and the system narrows the listed units to show only those in which it finds the string in a column.

The system searches for the entered text in the following columns: Inventory ID, Description, Lot/Serial Nbr., Manufacturer Lot/Serial Nbr., and the columns with lot or serial attributes (if any are shown).

Show Available Items Only

A check box that indicates (if selected) that the table shows only items whose quantity on hand in the warehouse is greater than 0. You clear the check box to view units of all items.

By default, the check box is selected.

The dialog box has a table with the units of the stock item that meet the selection criteria you have entered. The system adds one row per unit for serial numbers, and for lot numbers, one row for all units of a particular lot number.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

The table of this dialog box contains predefined columns, as well as one column for each lot or serial attribute that has been defined for a listed item. These columns are described below.

Included An unlabeled check box that you select to add the unit or units of a stock item to the document if you click Add or Add and Close.
Qty. Selected The quantity of the stock item units to be added to the document expressed in the base unit of measure. By default, the column contains 0.00, but you can override this value.
Inventory ID The identifier of the stock item.
Lot/Serial Nbr. The serial number for the unit of a stock item or the lot number for the units of the stock item.
Manufacturer Lot/Serial Nbr. The manufacturer's serial number for the unit of a stock item or lot number for the units of the stock item.
Description The short description of the unit or units of the stock item in the line. This description is copied from the Lot/Serial Details (IN209600) form.
Warehouse The warehouse of the unit or units of the stock item in the line.
Location The location of the unit or units of the stock item.
Base Unit The base unit of measure for the unit or units of the stock item in the line.
Qty. On Hand The quantity on hand of this item at the warehouse specified in the line.
Qty. Available The available quantity of this item at the warehouse specified in the line.
Qty. Available for Shipping The quantity available for shipping of this item at the warehouse specified in the line.
Attribute columns

Columns that the system dynamically adds for all of the active lot or serial attributes that have been defined on the Stock Items (IN202500) form for the stock items selected in the table. In each row, you can see the value specified for the unit or units with the particular lot or serial number.

The column name of each column is the description specified for the attribute on the Attributes (CS205000) form.

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 you have made 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:

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.