PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/25/2017 4:20 PM by  Stacy Fitzgerald
Item Master Sync
 10 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Neil Allen
Supply Chain IS Analyst
Private
Veteran Member
(165 points)
Veteran Member
Posts:81


Send Message:

--
03/08/2017 2:50 PM

    Hi All,

     

    Looking to see what anyone knows about Item Master Sync that's available in 10.0.6 and beyond.  From what I'm seeing it helps with ensuring your item master data is synced throughout the various screens.  IC11, IC12, PO13, IC82, PO25.  Of course we're on 10.0.5 so we don't have access to it but would like to know exactly how it works and if it works.  We could definitely use some help with keeping our data synced.

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    03/08/2017 3:44 PM

    I had thought it was only for Contract Management (which I don't have) but per the kb article, it may be accessible otherwise.  Anyone else ever seen it?

     

    KB1846139 attached

    Attachments
    Lloyd Warnes
    Application Analyst
    Providence Health and Services
    Basic Member
    (18 points)
    Basic Member
    Posts:6


    Send Message:

    --
    03/08/2017 5:31 PM

    Item Synchronization can work with S3 and use IC77.

    If you are a Contract Management user, you need to initiate the sync in CM.

    I've attached a more detailed document from Infor describing the settings and process.

    Attachments
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    03/09/2017 6:28 AM
    What security is needed to see this? This all I see on these screens.

    IC00

     

    IC01

     

     

    IC02



    Since we upgraded to V10 I'm finding I'm missing a lot of the new functionality.

    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    03/09/2017 6:40 AM
    Hi Jon.

    Similiar issue here. User Lawson did not have the screen and it turns out there is a CTP needed that seems pretty intense for our current interest. We're going to stick with our report and housekeeping uploads at month end. They seem simpler for us at this junction.
    Sheri
    MMIS Specialist
    Holland Hospital
    Veteran Member
    (319 points)
    Veteran Member
    Posts:125


    Send Message:

    --
    03/09/2017 8:13 AM

    Hi Kat, can you share what report and methods you are using to keep the screens in sync?

     

     

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    03/13/2017 3:15 PM

    We're running different sql through our report center (we don't use Crystal) that show:

    • IC11 Manufacturer Info doesn't match PO13
    • IC11 Part Number doesn't match PO13
    • PO13 Manufacturer is blank
    • IC11 Manufacturer Info doesn't match IC12
    • IC11 Part number doesn't match IC11
    • GL Category on IC11 doesn't match the one on IC12
    • PO13 Description  doesn't match IC11
    • IC11 is active but there's no PO25.6 not on hold
    • PO25.6 has more than one line for an item not on hold

    They're set to email a group box once a month and we have uploads mapped to the report outputs. We just look through them, delete the row if there are questions to look at later and upload the rest.

    Because the amount of lines seen aren't enough to justify what it would take to get the security and testing done on this and because the uploads do work, we are sticking with them.

    Either the forum or our firewall isn't letting me attach sql files, but the IC11 to PO13 manufacturer one is attached as a text.

    Attachments
    Red
    Content Manager, Supply Chain
    Sutter Health
    Veteran Member
    (203 points)
    Veteran Member
    Posts:69


    Send Message:

    --
    03/13/2017 3:54 PM
    Folks,
    One thing I would add to Kat's list above is when a UoM string changes on the IC11 to synch it to the PO25 (technically, the PO25.6). What we saw was when the conversions rates were adjusted/corrected, the PO25 was maintaining the original information for the Buy UoM. The fix was to change the line with an FC="C" and no other changes--which caused the line to re-synch. In the end, we had a Cobol program written that does this en masse for all of the PO25.6 lines. I think it still runs today.
    Red
    Neil Allen
    Supply Chain IS Analyst
    Private
    Veteran Member
    (165 points)
    Veteran Member
    Posts:81


    Send Message:

    --
    03/15/2017 10:36 AM
    Thanks to all for the great responses and information!
    Stacy Fitzgerald
    Senior Systems Analyst
    Mayo Clinic
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    05/23/2017 9:45 AM
    We recently upgraded to 10.0.7 and I came across this functionality - required a patch JT-921406 which we installed. I can get the sync to run from IC77 - fairly confusing - no form help, limited field help, and very limited documentation on factsheet listed above. I am now trying to build an upload, as doing this manually is not much of a benefit, but can not get it to work - anyone have any better instructions / documentation?
    Stacy Fitzgerald
    Senior Systems Analyst
    Mayo Clinic
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    05/25/2017 4:20 PM

    I confirmed with Lawson support that add-ins uploads into IC77 do NOT work for adding records - form requires an inquiry prior to an add.  Add-ins will work to change a record previously loaded into IC77 (and not already processed) - but limited value in that.

    I am currently attempting to load a file through IC177 - but no documentation on directory or file format other than csv

    You are not authorized to post a reply.