Sage 300: 10 Steps to Counting and Reconciling Inventory

Sage 300: 10 Steps to Counting and Reconciling Inventory
  1. Run Day End Processing.
  2. Change Costing Method to Day End Processing in IC Options
  3. Generate inventory worksheets.
  4. Print the inventory worksheets that you generated.
  5. Count the items in stock.
  6. Enter counted item quantities.
  7. Print the Inventory Reconciliation report.
  8. Post the inventory reconciliation.
  9. Confirm that all items were posted, except those with a status of On Hold.
  10. Print the Adjustments Posting Journal to check the adjustments posted.
  11. Change Costing Method back to Posting in IC Options
  12. Delete inventory worksheets that you do not need. For example, delete worksheets that contain only items that you do not want to post.

Things to remember that are important:

If you generate an inventory worksheet for a location that already has a worksheet, the program replaces the old worksheet with a new one. The program warns you if there are existing worksheets for locations and lets you choose whether to replace them.

Warning! To ensure quantities and costs on worksheets are current, do not post transactions (receipts, shipments, transfers, adjustments, assemblies, or internal usage), and then run Day End Processing between the time you generate inventory worksheets and the time you the post the inventory reconciliation.

Before posting the inventory reconciliation run Day End Processing if you want to include the latest costing information in the report.

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.