How to adjust item quantities and costs on Sage 300 Inventory Control
Steps:
- Open Inventory Control > I/C Transactions > Adjustments.
- With ***NEW*** displayed in the Adjustment Number field, press the Tab key to start a new assembly.
- Tip: If ***NEW*** does not appear, click the New button.
- The program automatically assigns a document number when you save or post the
transaction. - Alternatively, you can enter a new transaction number yourself, and then press Tab.
- In the Adjustment Date field, enter the date for the adjustment, or select it using the calendar icon beside the 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.
- In the Posting Date field, enter the date to which to post the transaction in the general ledger.
- Enter an optional description and reference for the adjustment.
- Click the Zoom button beside the Optional Fields check box (if one appears) to add optional
field information for this adjustment. - Add the detail lines, specifying the item number, adjustment type, and location for each, then:
- If the item uses the FIFO or LIFO costing method, specify the bucket type, receipt
number, and cost date.- 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.
- If the adjustment type is Quantity Increase, Quantity Decrease, Both Increase, or Both Decrease, specify the quantity and unit of measure. If the item is serialized and/or lotted, you are prompted to assign serial/lot numbers. (For more information see “Assigning Serial/Lot Numbers to Adjustments” (page 217).)
- If the adjustment type is Cost Increase, Cost Decrease, Both Increase, or Both
Decrease, specify the cost adjustment and adjustment/write-off general ledger account. - Enter any comments you want to keep with the detail.
- Click the Zoom button for the Optional Fields column (or check box), if one appears, to add optional field information for this adjustment detail.
- 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.
- If the item uses the FIFO or LIFO costing method, specify the bucket type, receipt
- When you are finished, click Post or Save, and then click OK at the confirmation message.
- If you choose Save, Inventory Control saves the transaction so you can edit and post it
later. - If you choose Post, Inventory Control posts the transaction immediately.
- Important! If you use the option to allow you to delete transactions after posting, Inventory Control asks if you want to delete the transaction. Click No, unless your company always deletes posted transactions. If you delete the posted transaction, you will not be able to drill down to the transaction details from General Ledger.
- If you choose Save, Inventory Control saves the transaction so you can edit and post it
Support
If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.