•  Refresh
  • Tools
  •  
  • Expand All
  • Collapse All
  • Locales
  • Get File Link
  • Report Typo
  • Print
  • Export

Adjustments

Form ID: (IN303000)

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.

In This Topic [Hide/Show]

Back to TopForm 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.

Back to TopSummary 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.

Back to TopDetails 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.

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

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

Back to TopFinancial 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.

Back to TopManufacturing 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.

Back to TopRelated Articles