PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/16/2016 3:00 PM by  brupp
Crystal Report for PO23 Orphaned Items
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
brupp
Sr. Data Analyst
UC Health
Veteran Member
(303 points)
Veteran Member
Posts:127


Send Message:

--
09/15/2016 6:18 AM
    Hello - I have a Crystal Report for POINTERFAC with ORIGIN_CD=IC to catch those items that do not add to or create a PO due to having the wrong replenishment vendor (or whatever the reason). It works fine except for 6 items that I cannot find either in PO23 or on a PO100 error report. I just need them to go away & cannot figure out the required action in Lawson. Any ideas? Thanks.
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    09/15/2016 8:10 AM
    Are you saying that without any filters used these items do not appear in PO23 but they show in your Crystal report?
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    brupp
    Sr. Data Analyst
    UC Health
    Veteran Member
    (303 points)
    Veteran Member
    Posts:127


    Send Message:

    --
    09/15/2016 10:18 AM
    That is correct. I've tried with no filters, or filtered by ship to location without Origin = IC. Just can't seem to locate the reason these are hitting my report.
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    09/15/2016 3:14 PM
    That is strange. Maybe some corrupted data? Can you trace the records to a single document number. When IC140 runs it assigns a sequential document number to the batch.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    brupp
    Sr. Data Analyst
    UC Health
    Veteran Member
    (303 points)
    Veteran Member
    Posts:127


    Send Message:

    --
    09/15/2016 4:28 PM
    No I can't get to a document number but I ran POINTERFAC wide open just to try to spot something weird & sure enough - all 6 items have a six digit LINE_NBR. Would there be a paint screen to delete those, do you know?
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    09/16/2016 7:37 AM
    You should open a case with Infor. There may be more tables that should be corrected than just POINTERFAC.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    brupp
    Sr. Data Analyst
    UC Health
    Veteran Member
    (303 points)
    Veteran Member
    Posts:127


    Send Message:

    --
    09/16/2016 3:00 PM
    OK will do, thanks for your help!
    You are not authorized to post a reply.