• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Cycle Counts - Transaction History

 2 Replies
 2 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
ChrisMac
New Member Send Private Message
Posts: 1
New Member
1/26/2017 1:25 AM
Do cycle counts create a transaction in transaction history as reported in IC220?
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
1/26/2017 5:46 AM
Yes, I believe they create PI (Physical Inventory) transactions.
David Williams
Mike Bernhard
Veteran Member Send Private Message
Posts: 101
Veteran Member
1/26/2017 7:16 PM
Yes and No. Let me explain.

Cycle Counts will only post to transaction history to the Item Transaction History (IC50 / IC220) when there is an adjustment. In other words, if the count quantity does not equal the freeze quantity, then the transaction will be posted to the item transaction history as a PI Adjustment.

If you are wanting to know when an item was last cycle counted, the item's LAST COUNT DATE is saved to the inventory record each time it is counted, regardless of adjustment - you will find this value in the ITEMLOC table in the field "LAST-COUNT-DT"