Click Create New to clear the screen for a new entry.
Click Delete to remove the current transaction.
Click this button to post the current transaction.
Click Save to save changes you have made to the screen.
Use this field to specify the date of the adjustment.
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 an optional description 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 an optional reference 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 the optional fields by clicking next to the Optional Fields option and selecting Add/Edit to open the I/C Detail Optional Fields screen.
Note: Optional field information can pass to the General Ledger only if the optional fields 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.
Displays the year and period, which is determined by the posting date. You cannot change the year/period except by changing the posting date.
Use this field to change the general ledger account number
A description of the specified account displays in the Account Description field.
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.
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.
Enter an amount by which to adjust the extended item cost.
Use this field to change the cost date of the entry.
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, specify the receipt number of the transaction used to enter item units into inventory.
Inventory Control automatically displays the description entered for the item on the I/C Items screen. You cannot change it on the I/C Adjustments screen.
Use this field to specify the item number of the item for which you are entering an adjustment.
You can enter a manufacturer's item number that was associated with an item (using the I/C Manufacturers' Items screen). The program substitutes the inventory item number, and places the manufacturer's item number that you entered in the Manufacturer's Item Number column 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 the previous line, then click the Add Line button.
To delete a line, select it and click the Delete Line button.
Use this field to specify the code of the inventory location at which to make the adjustment for the item.
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 it with the inventory item number, and places the manufacturer's item number that you used in the Manufacturer's Item Number field (by default the last field in the table).
You must have already added the manufacturer's item number using the I/C Manufacturers' Items screen.
This column displays:
If optional fields are set up for transaction details, you can add or change optional fields by clicking in this column and then clicking to open the Optional Fields screen. An optional field can be set up to automatically contain information; if that optional field is associated with transaction details, this column automatically displays Yes.
Note: Optional field information can pass to the General Ledger only if the optional fields 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 on the I/C Options screen.
Use this field to specify the unit of measure for the item.
You must use a unit of measure that has been assigned to the item on the I/C Items screen.
Use this screen to enter and post adjustments to item quantities and costs. For each transaction, you enter the following information: