Posting an Inventory Reconciliation

When you post an inventory reconciliation, the program creates adjustment transactions for any discrepancies between your physical inventory count and the figures calculated by Inventory Control.

  • Print the Inventory Reconciliation report (optional) before posting to check that the information you entered in the Physical Inventory Quantities screen is accurate for each location.

    The Inventory Reconciliation report lists the quantities and costs that the program will post the next time you use the Post Inventory Reconciliation screen. The only items that will be posted are those that have the status "Ready to post."

  • You can also check item statuses by displaying the worksheet in the Physical Inventory Quantities screen.

To post an inventory reconciliation:

  1. Open Inventory Control > I/C Physical Inventory > Post Inventory Reconciliation.

  2. Specify the range of locations for which you want to post reconciliation adjustments.
  3. Enter the transaction date, fiscal year, and period to which you will post the transaction.
  4. Enter a reconciliation number and, optionally, a description or reference.
  5. Click Post, and then click OK on the message that appears.
  6. Click Close to close the Post Inventory Reconciliation screen.
  • Confirm that all items were posted, except those with a status of "On Hold". You can do this in the following ways:
    • Check the Physical Inventory Quantities screen.

      If any items were not posted, the status of each item indicates the reason it was not posted.

    • Print the Inventory Reconciliation report.

      The report lists all items that were not posted, including items that had the posting status "On hold" prior to posting. Items that were posted successfully do not appear on the report.

      Note: If all items were posted, the Inventory Reconciliation report is blank.

    For more information about inventory reconciliation errors and how to resolve them, see Inventory Reconciliation Errors.

  • Run day end processing to update the company's costing and statistical data (this is not necessary if you cost items during posting). For more information, see I/C Day End Processing Screen.
  • Print the Adjustments Posting Journal to check the adjustment transactions posted by the program for the reconciliation. For more information, see I/C Posting Journals Screen.

    Note: 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.

  • Delete inventory worksheets that you do not need. For example, delete worksheets that contain only items that you do not want to post.