Posting Inventory Quantities

This process posts the quantities to the Quantity On-Hand field for each inventory item and creates any entries to the journal for any adjustments.

Note: We recommend you run the Cycle Count Variance Report before posting the cycle counts. This report provides an accounting audit trail for any variances encountered from the original quantities.

When you run the Cycle Count Posting activity, records that have the count quantity within the Cycle Tolerance cutoff quantity (and that are not exceptions) are posted and deleted.

To post cycle counts:

  1. On the Cycle Count Posting form, specify this information:
    Cycle Status
    Select whether you want to post records with a cycle status of counted or exception.
    Warehouse
    Select the warehouse from which you are posting cycle count records.
  2. Click Process.
  3. After posting is complete, review any records that have a status of Exception.

    These are records that did not post due to errors.

  4. (Optional) Use the Cycle Count Purge form to purge any records that were not posted.

The Cycle Count Posting activity processes the cycle record through these steps:

  • The system checks to see if the actual count is different from the on-hand count:
    • If the count is the same, there is nothing for the system to update, and it simply deletes the record.
    • If the count is different, the system updates the location's on-hand quantity and the item's on-hand quantity.
  • A material transaction record is created with these settings:

    • Trans Type - B
    • Ref Type - I
    • Qty - the difference between actual (cycle) count and the computer-recorded count (for the item).
  • The system posts the new quantity to the Inventory Control Ledger Distribution journal (if the Cost Method field is not set to None).

    Cycle Count Adjustment Journal reference INV CC-A; uses these account numbers:

    • Product Codes Inventory Adj account

      Note: If an account number is specified in the Product Codes Cycle Inventory Adj account field, that account is used instead.
    • Item Location Inv Acct
  • Lastly, the system deletes the cycle count records and sets the Last Count field to today's date.

    If no other cycle count records exist for this item, the Cycle Triggered and Count in Process check boxes are cleared.