Cycle Count Transaction Report

Great question. From an auditable (permament record) perspective, Lawson only records the adjustments (in the ICTRANS file) and the date last counted (in the item location tables). The adjustments can be view from IC50/IC50.2 inquiry screens and/or the IC220 report. I think that the LAST COUNT DATE can be viewed in IC12. 

 

So, said another way, you won't find transactions in ICTRANS to show that the item was counted in situations where the count quantity matches the freeze quantity.   

In the near term (shortly following the count event), there is a table called ICFREEZE that you can extract and/or run queries from - this table shows the SELECT ID, the frozen quantity and the counted quantity, among other things and will likely give you what you are looking for. Be advised that this file is deleted quite often as you perform your physical inventory / cycle count process (records can be deleted when you post counts (IC175) or when you run IC179), so you will want to make sure your process supports your reporting needs.

Let me know if you want to chat more about this.

I am still not able to see the transactions. Here is my process, can you let me know if we are missing a step?
1) Freeze Records
2)Complete counts
3)Update Variances in update mode and delete freeze records.

Hi Chris,

If you look at the IC275 report that was ran to update the counts (this report will be in the print manager of the user that ran the report), then find an item that had a discrepancy (count quantity <> freeze quantity). Then go to IC50 and inquiry on that location and item and you will see a "PI" adjustment. (This assumes you actually ran the IC275 report in update mode since the PI transaction does not post until you run in update mode.)