Share
Report
890When I try to import inventory issues with lot serial numbers, all fields import correctly into inventory Issue screen except for the lot serial number.
With the simple import file I get the message
"The lot number you entered already exists for this item. Please enter a new one" does not make sense as one should only be able to issue serialized items that exist?
I get the same error with both simple and intelligent imports, even when importing in edit mode only.
When I enter the same information into the Issue screen, it goes through without a problem.
When I try to import the issue of a inventory item without a serial number in the system, it throws the error
"The lot number does not exist.............."
It is as if the serial number import sees the transaction as a receipt and not an Issue?
Example of Import File
Level0,,,H,200
Level1,II,M00001705,M00001705,HOSCOMP,HOSBLOKN ,1,,,,,,,10500000,,,,,NCECL1111111111
Level2,0195763,1
Control File
Level0,cbatnbrh,cperpost,cbathandling,cctrltot,cLotSerFxdVal,cLotSerNumVal,ckittotal
Level1,ctrantype,crefnbr,cinvtid,csiteid,cwhseloc,cqty,cunitdesc,cunitprice,ctranamt,cextcost,ctrandate,cReasonCode,cacct,xuser1,cprojectid,cbillable,ctaskid,csub
level2,LS_cLotSerNbr,LS_cQty,LS_cMfgrLotSerNbr,cls_expiredate,LS_cShipContCode,LS_cLotSerRef,LS_cLineNbr
I have spent many hours on this issue now and I would appreciate it if someone could let me know if they have imported inventory issues with serial numbers successfully or if this is an unsolvable issue.
Thank you in anticipation.
*This post is locked for comments
All responses (
Answers (
