• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.