Skip to Content
0
Former Member
Oct 26, 2018 at 09:23 AM

Issue with order line item number during impex execution

115 Views

We use linenumber attribute from AbstractOrderEntry for order line item number. We receive order line details from external ERP system. We used to receive line number as 1.1, 2.1, 3.1... etc. But some occasions we receive line number as 1.1.1, 1.1.2 or 1.1..1, 1.1..2 and in this case this line items are not getting updated in order entry.

Sample Order Impex for your reference:

insert_update orderentry;order(OrderNumber)[unique=true];lineNumber[unique=true];reqShipDate[dateformat=yyyyMMdd];entryNumber;itemSubNum;product(code,$catalogVersion) ;"ORDID";"1.1";"20180913";"0000000000000011";"11";"PDT_CODE_1"; ;"ORDID";"2.1";"20180913";"0000000000000021";"21";"PDT_CODE_2"; ;"ORDID";"1.1.1";"20180913";"0000000000000011";"11";"PDT_CODE_3"; ;"ORDID";"1.1.2";"20180913";"0000000000000011";"11";"PDT_CODE_4"; ;"ORDID";"1.1.3";"20180913";"0000000000000011";"11";"PDT_CODE_5"; ;"ORDID";"1.1.4";"20180913";"0000000000000011";"11";"PDT_CODE_6"; ;"ORDID";"1.1..5";"20180913";"0000000000000011";"11";"PDT_CODE_7";

FYI - We already have millions of order existing in table. Could you please let us know what we can do here.