Item Master Sync

 11 Replies
 3 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Me
Veteran Member
Posts: 96
Veteran Member

    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
    Veteran Member
    Posts: 1020
    Veteran Member

      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
      Basic Member
      Posts: 9
      Basic Member

        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
        Veteran Member
        Posts: 1163
        Veteran Member
          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 - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          Kat V
          Veteran Member
          Posts: 1020
          Veteran Member
            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
            Veteran Member
            Posts: 163
            Veteran Member

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

               

               

              Kat V
              Veteran Member
              Posts: 1020
              Veteran Member

                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
                Veteran Member
                Posts: 87
                Veteran Member
                  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
                  Learn from the Past. Prepare for the Future. Act in the Present.
                  Me
                  Veteran Member
                  Posts: 96
                  Veteran Member
                    Thanks to all for the great responses and information!
                    Stacy Fitzgerald
                    New Member
                    Posts: 2
                    New Member
                      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
                      New Member
                      Posts: 2
                      New Member

                        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

                        Sharon Kalister
                        New Member
                        Posts: 1
                        New Member
                          We are successfully adding records to IC77 using an add-ins upload.  You need to have add-ins upload permissions set to AAAAAA so that you have the “Ignore Pre-Inquire Status” option available.  On your upload spreadsheet, use A as the function code on each line.  Use the Change action, making sure to check the 'Ignore Pre-Inquire Status' checkbox.  To Sync items after you add them with the upload, you can either sync them all at once in IC77 using the Sync special action, or use S as the function code on each line to sync each line individually.