Process Adjustments Automatically

Sage ERP Accpac Inventory Control 6.0

Process Adjustments Automatically

Which form should I use to process adjustments?

  • Follow the instructions on this page for the Process Adjustments form to automatically create adjustments that:

  • Write off the cost of items with zero quantities.

  • Write off the quantities of items with zero cost.

  • Adjust the total costs of items with non-zero quantities and zero total cost to a new cost.

  • Use the Adjustments form to change item costs and quantities as needed.

  • To update the quantity on hand at a location to agree with your physical inventory count.

  • To return goods to a vendor after you have completed the receipt.

  • To remove additional cost remaining on a receipt when you return the total quantity received for an item at a location to the vendor.

  • Use the Post Inventory Reconciliation form to post the counts and costs that you entered in the Physical Inventory Quantities form. The program creates adjustment transactions when you post inventory reconciliations.

Can I adjust material usage for a project?

If you use Project and Job Costing, material adjustment transactions created by Project and Job Costing will appear in Inventory Control showing adjustments to particular contracts, projects, job categories and overhead accounts.

Note, however, that you cannot adjust materials for jobs from the Inventory Control program.

Before you start

Usually, you process adjustments after printing the Item Valuation Report and finding that your costs are out of balance with inventory amounts.

In other words, you use this form to automatically fix problems that you have already found.

We suggest that you:

  • Print the Item Valuation Report.

  • Physically check inventory quantities to make sure that the items will be adjusted properly.

To process adjustments automatically:

  1. Open Inventory Control > I/C Periodic Processing > Process Adjustments.

Click here for help on Process Adjustments fields.

  1. Enter the range of item numbers for which you want to create adjustments.

  2. Enter the range of locations for which you want to create adjustments.

  3. Choose one of the following types of adjustments:

  4. Total cost to zero for items with zero quantities

  5. Total quantity to zero for items with zero total cost

  6. Total cost for items with non-zero quantities and zero total cost.

If you choose "Total cost for items with non-zero quantities", you must also choose the type of cost to which you want the cost adjusted:

    • Standard cost

    • Most recent cost (includes the tax)

    • Last Unit cost (does not include the tax)

    • User defined cost 1

    • User defined cost 2

  1. Click Process.

After using

  • Print the Item Valuation Report and compare it to the report that you printed earlier.

  • Print the Adjustment Posting Journal to check the actual posted adjustments.

Related topics