I/C Adjustments Screen

Open Inventory Control > I/C Transactions > Adjustments.

Click Delete to remove the current transaction.

Click Detail to display information for a selected detail line in a separate Details screen.

Click this button to post the current transaction.

Click Save to save changes you have made to the screen.

Enter the date for the adjustment or select it from the calendar (click the Calendar button beside the date field).

Inventory Control automatically displays the session date as the default date, but you can change it. (The session date is the date that you entered when you started Sage 300).

You can also enter a separate posting date, which determines the fiscal year and period to which a transaction is posted in the general ledger.

You can change the document date and the posting date, but you cannot directly change the fiscal period.

The program automatically assigns a number if you leave "*** NEW ***" in the Adjustment Number field. The program-generated adjustment number is determined by settings in the I/C Options screen.

You can also enter an adjustment number (for example, based on the date) as long as the number is unique to distinguish it from other, existing adjustments.

Adjustment numbers can contain letters, numbers, and special characters (for instance, *, & #). Letters automatically appear in uppercase when you type them.

Note that when you post an inventory reconciliation for which an adjustment number already exists, the Inventory Worksheet will create separate adjustments for every one hundred items, and append "1", "2", "3", etc. to the end of the document number.

Enter a description (optional) for the adjustment, using up to 60 characters.

This description appears with the transaction on the Adjustments Posting Journal.

It can also appear on the G/L Transactions report and in the general ledger batch (if Inventory Control uses Description for the G/L Entry Description field or the G/L Detail Reference field and you do not consolidate general ledger transactions).

This field displays the name of the person who entered the transaction.

Enter a reference (optional) for the adjustment, using up to 60 characters.

This reference appears with the transaction on the Adjustments Posting Journal.

It can also appear on the G/L Transactions report and in the general ledger batch, if the G/L Reference field or the G/L Description field uses Reference in one of its segments, and you do not consolidate general ledger transactions.

If optional fields are set up for use in this type of transaction (applying to the entry as a whole), you can enter information in these fields by clicking the Optional Fields Zoom Zoom button button in the top section of the transaction screen.

  • Optional fields are available only if you have Sage 300 Transaction Analysis and Optional Field Creator.
  • Optional field information can pass to the General Ledger—as long as the optional fields assigned to the transaction screens or transaction details are also assigned to the general ledger accounts.

Specify the date to which to post the transaction to the general ledger. The posting date determines the fiscal year and period , which you cannot change directly.

In a multicurrency system, currency revaluation also uses posting dates to select open documents for revaluation purposes and, thus, revaluation adjustments are posted to the general ledger in the correct fiscal year and period.

Depending on your settings in the I/C Options screen, Inventory Control displays the session date or the document date as the default posting date.

Note: If you consolidate G/L transactions, the posting date for consolidated entries is the last date of the fiscal period.

The displayed year and period is determined by the posting date. You cannot change it except by changing the posting date.

To change the general ledger account number, type over it. If you use Sage 300 General Ledger, you can also select another account from the Finder.

Inventory Control automatically displays the general ledger adjustment write-off account from the item record's account set.

Displays the average cost of the item as of the last day-end.

Select a bucket type from the list to specify the way in which the program is to process the adjustment. Inventory Control automatically displays Offset Bucket.

Enter comments you want to appear on the Adjustments Posting Journal for the detail line. Use up to 250 characters.

These fields appear if you have Sage 300 Project and Job Costing.

If you enter materials adjustments through Project and Job Costing, the transactions created by Project and Job Costing will appear in Inventory Control.

Note, however, that you cannot use the job costing fields in the Inventory Control program.

Enter an amount by which to adjust the extended item cost.

To change the date, type over it.

Inventory Control automatically displays the transaction date for the receipt number you specify in the Receipt Number field.

Displays the cost unit of measure.

If you selected Specific Bucket in the Bucket Type column, enter the receipt number of the transaction used to enter item units into inventory, or select the number from the Finder.

The receipt number you specify must appear in the Finder for this field.

Inventory Control automatically displays the description entered for the item in the Items screen. You cannot change it in the Adjustments screen.

Enter the item number of the item for which you are entering an adjustment, or select the number from the Finder.

You can enter manufacturers' item numbers that have been added to Inventory Control.

Once you press the Tab key, the program replaces the field contents with the inventory item number, and places the manufacturer's item number that you used in the Manuf. Item No. field (by default the second last field in the table).

Line numbers show the order in which you added each detail line to the adjustment. They are assigned in sequence by Inventory Control and you cannot change them.

If you want to insert a detail line ahead of an existing line (except for line 1), select (highlight) the previous line, then press Insert. You cannot insert lines before the first detail line you enter.

To delete a line, place the insertion point in the line, then press the Delete key on your keyboard.

Enter the code of the inventory location at which to make the adjustment for the item, or select the code from the Finder.

Locations in Inventory Control are either physical locations or logical locations.

You can adjust goods only at a physical location.

If you entered a manufacturer's item number in the Item Number field, the program replaces the Item Number field contents with the inventory item number, and places the manufacturer's item number that you used in the Manuf. Item No. field (by default the last field in the table).

You must have already added the manufacturer's item number using the Manufacturers' Items screen in the Items and Price Lists folder.

If optional fields are set up for use in details for this type of transaction, you can enter information in the detail optional fields by selecting the detail line, and then clicking the Optional Fields column heading in the Detail table.

  • Optional fields are available only if you have Sage 300 Transaction Analysis and Optional Field Creator.
  • If information is entered in optional fields for a transaction detail, Yes appears in the Optional Fields column for the detail.

    Optional fields can be set up to automatically contain information. If you have optional fields that are set up this way, Yes appears in the Optional Fields column for new transaction details.

  • Optional field information can pass to the General Ledger—as long as the optional fields assigned to the transaction screens or transaction details are also assigned to the general ledger accounts.

Enter the number of units by which to adjust the item quantity.

To decrease the quantity of an item in stock to below zero, you must have turned on the Allow Negative Inventory Levels option in the Options screen.

You specify the type of adjustment you want for each item you add to an adjustment transaction. There are six types of adjustments you can enter:

  • Quantity Increase, Quantity Decrease. Increases or decreases, respectively, the item quantity on hand at the location by the number you specify.

    Quantity increase and quantity decrease adjustments affect the item's average unit cost at the location, but the item's extended cost does not change.

    The program does not create general ledger transactions for these type of adjustments because the value of the inventory does not change.

  • Cost Increase, Cost Decrease. Increases or decreases, respectively, the extended item cost at the location by the amount you specify. Inventory Control recalculates the average unit cost at the location based on the item's adjusted extended cost.
  • Both Increase. Increases both the item quantity on hand and the extended item cost at the location by the increases you specify. Inventory Control recalculates the item's average unit cost at the location based on the increases.
  • Both Decrease. Reduces both the item quantity on hand and the extended item cost at the location by the decreases you specify. Inventory Control recalculates the item's average unit cost at the location based on the decreases.

Enter the unit of measure for the item, or select the unit from the Finder.

You must use a unit of measure that has been assigned to the item in the I/C Items screen.

Overview

Use this screen to:

  • Enter and post adjustments to item quantities and costs. More...

    For each transaction, you enter the following information:

    • Adjustment Number (a number to distinguish the transaction from other adjustments for audit control purposes).
    • Description (add any information you want about the adjustment; optional).
    • Adjustment Date (to which you want the transaction posted).
    • Year and Period (to which you want the transaction posted).
    • Reference (for example, the reason for the adjustment, or the purchase order number or invoice number; optional).
    • Optional Fields (add optional fields to Adjustments using the Optional Fields screen in the Setup Folder; optional).
  • Import adjustment transactions from other Sage 300 databases or from non-Sage 300 programs.
  • Assign serial and/or lot numbers to items in adjustments if you have a license to use Serialized Inventory and Lot Tracking.

Note: If you use Project and Job Costing, material adjustment transactions created in Project and Job Costing appear in Inventory Control showing adjustments to particular contracts, projects, job categories and overhead accounts. However, you cannot use the Inventory Control program to adjust materials for jobs.