Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

IC81 add-in template?

 5 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Mary Porter
Veteran Member
Posts: 337
Veteran Member
1/25/2013 9:26 PM
    Due to JT-181562 we are getting a "No Charge flag mismatch; Par/Car Loc vs. Replenish From Loc" error.
    if we go to IC81 and just add a FC of "C" on the item that we get the error on, and then click on Change, the item goes through.

    Does anyone have an add-in template that can accomplish the same thing? I have tried but haven't been able to accomplish this without getting an "Item already exists" message.
    There are about 25000 items that have to be updated this way.
    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
    1/29/2013 11:34 AM
      _f3,ICL-COMPANY
      _f5,ICL-LOCATION
      _f19,PT-BGD-BIN-SEQ
      _f20:0,LINE-FC1
      _f21:0,BGD-BIN-SEQ1
      _f22:0,ITL-PREFER-BIN1
      _f23:0,ITL-ITEM1
      (H),_f58:0,ITL-NO-CHARGE-FL1
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      JonA
      Veteran Member
      Posts: 1163
      Veteran Member
      1/29/2013 11:36 AM
        C in the FC field and select Change Only on the upload.
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
        1/29/2013 8:38 PM
          That map only returns the error "Bin sequence already exists" for me. We also get this error mapping them the f32-34.

          I've got this issue on my production as well and have never been able to find an upload fix for it. Please let me know if you do!

          We do have a query to make finding them easier for the inventory users pushed out to our report center -

          select l.COMPANY, l.LOCATION, l.PREFER_BIN as "PT", 'C' as "FC", b.BIN_SEQ, l.PREFER_BIN, l.ITEM, l.CHARGEABLE_FL, l.NO_CHARGE_FL
          from ITEMLOC L
          inner join BINGRPDTL b on l.COMPANY = b.COMPANY and l.LOCATION = b.LOCATION and l.PREFER_BIN = b.BIN
          WHERE l.NO_CHARGE_FL = ' '
          order by l.LOCATION desc, b.BIN_SEQ
          JonA
          Veteran Member
          Posts: 1163
          Veteran Member
          1/29/2013 9:16 PM
            Just verified that it works for me. You have to load to IC81.1
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            Kat V
            Veteran Member
            Posts: 1020
            Veteran Member
            2/6/2013 6:19 PM
              Just had another request and retried - yep.  Whatever's causing it seems to be giving the add-ins hiccups as well.  Oddly enough - a few of the lines scattered in the report DID fix themselves even though they all returned the "bin sequence already exists" error.