PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/17/2017 2:11 PM by  Mike Bernhard
Cycle Count Transaction Report
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Chris2018
Supply Chain Manager
Private
New Member
(4 points)
New Member
Posts:2


Send Message:

--
11/17/2017 10:21 AM
    What report would help identify transactions after completing a cycle count. I am wanting to see detailed transactions.
    Mike Bernhard
    Lawson Supply Chain Consultant
    Trident Edge Consulting
    Veteran Member
    (257 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    11/17/2017 11:26 AM
    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.

    Chris2018
    Supply Chain Manager
    Private
    New Member
    (4 points)
    New Member
    Posts:2


    Send Message:

    --
    11/17/2017 1:29 PM
    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.


    Mike Bernhard
    Lawson Supply Chain Consultant
    Trident Edge Consulting
    Veteran Member
    (257 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    11/17/2017 2:11 PM
    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.)
    You are not authorized to post a reply.