I am specifying the Order Number, and there is nothing written to Errors.txt. I see a similar issue reported here: https://www.realisable.co.uk/how-do-i/trying-to-update-sage-300-shipment-detail-line-pri/

Version:

Assembly Versions:

Realisable.IManWebUI.DLL 4.0.0.0

Product Update: PU1

Config Version: 4.04

DB Version: 4.01

Hi Arline,

Worth setting up auditing and running through the scheduler to see if this fails on the header or the line.

My first check would be to make sure the supplied line number is correct.

Looks like it's failing on the detail line, and I agree there may be an issue with the line number. But I'm confused about why. Here's what I'm seeing in Errors.txt (not seeing much in the Audit). 

Please also see the screenshot of the shipment number and line number matching in the database and in the Iman UI. Please help!

Subscript out of range
Time='06/26/19 07:58:47' App='IManEngine:3.2.100' ADO-version='10.0' Computer='CMA-APP01'
Method: AccpacOEShipment.CreateDetailEntry
Number: 9 = &H9 = vbObjectError + 2147221513 = ERRMAP_APP_FIRST + 2147216315
Source: IManEngine
Description: Subscript out of range
Call Stack: AccpacOEShipment.CreateDetailEntry(lLineNum=0, lShipmentNumber=10274375, bUpdatingShipment=True, bStandalone=False, bJobRelated=False)
Env: l=0, m=0, iLnType=1, sTaxClass='', sTaxIncBeforePrice='', sOrderNum='', bKitAssembly=False, bMiscCharge=False, bInsertingLine=False, bTaxIncBeforePrice=False
Call Stack: AccpacOEShipment.CreateShipment() ----------------------------------------------------
Env: l=0, lShipmentNumber=10274375, s='5', sOrderNum='', sDistTax='', bCalcTax=True, bDistTax=False, bProcess=True, bUpdate=True, bHasShipmentNum=True, bHasInitialised=False, bStandalone=False, bJobRelated=False
Call Stack: AccpacOEShipment.AccpacImport_CreateTransactions() -----------------------------------
Call Stack: TransformAccpac.PerformTransform() ---------------------------------------------------
Call Stack: TransformAccpac.ITransformController_Process() ---------------------------------------
Env: sCompany='', l=1, bSupportsDynamicCompanies=True
Call Stack: TransformCoordinator.RunTransform(sTransformId='UpdateShipLines') --------------------
Env: eTransformType=90, bWriteSummaries=False, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='FindShipments') ------------
Env: sTransformId='UpdateShipLines', l=0, m=0
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='FindShipments', l=1, m=1
Call Stack: TransformCoordinator.Process() -------------------------------------------------------
Call Stack: IntManEng.Main() ---------------------------------------------------------------------
Env: sCmd='"CMATST_OEORD20"'

Hi Arline,

Looking at the error text above, it seems the line number 

CreateDetailEntry(lLineNum=0

doesn't get set properly.

Could you please try creating a new field in a preceding map, then map that value to the line number.

New field  mapped to Line Number, throwing the same "Subscript Out of Range" error.

Errrors.txt:

Subscript out of range
Time='07/01/19 01:28:02' App='IManEngine:3.2.100' ADO-version='10.0' Computer='CMA-APP01'
Method: AccpacOEShipment.CreateDetailEntry
Number: 9 = &H9 = vbObjectError + 2147221513 = ERRMAP_APP_FIRST + 2147216315
Source: IManEngine
Description: Subscript out of range
Call Stack: AccpacOEShipment.CreateDetailEntry(lLineNum=0, lShipmentNumber=10988609, bUpdatingShipment=True, bStandalone=False, bJobRelated=False)
Env: l=0, m=0, iLnType=1, sTaxClass='', sTaxIncBeforePrice='', sOrderNum='', bKitAssembly=False, bMiscCharge=False, bInsertingLine=False, bTaxIncBeforePrice=False
Call Stack: AccpacOEShipment.CreateShipment() ----------------------------------------------------
Env: l=0, lShipmentNumber=10988609, s='5', sOrderNum='', sDistTax='', bCalcTax=True, bDistTax=False, bProcess=True, bUpdate=True, bHasShipmentNum=True, bHasInitialised=False, bStandalone=False, bJobRelated=False
Call Stack: AccpacOEShipment.AccpacImport_CreateTransactions() -----------------------------------
Call Stack: TransformAccpac.PerformTransform() ---------------------------------------------------
Call Stack: TransformAccpac.ITransformController_Process() ---------------------------------------
Env: sCompany='', l=1, bSupportsDynamicCompanies=False
Call Stack: TransformCoordinator.RunTransform(sTransformId='UPDATESHIPLINES') --------------------
Env: eTransformType=90, bWriteSummaries=False, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='UPDATESHIPLINES', l=0, m=0
Call Stack: TransformCoordinator.Process() -------------------------------------------------------
Call Stack: IntManEng.Main() ---------------------------------------------------------------------
Env: sCmd='"CHEDAT_OEORD30"'

Hello All, has a solution to this error been found? I have the same issue in my Shipment Update Job.

My errors.txt reads (see below). I have bound the order number and the line number in the map though, so I do not know why they are blank. 

Thanks.

Subscript out of range
Time='09/06/19 14:43:53' App='IManEngine:3.2.100' ADO-version='10.0' Computer='MN-DB2'
Method: AccpacOEShipment.CreateDetailEntry
Number: 9 = &H9 = vbObjectError + 2147221513 = ERRMAP_APP_FIRST + 2147216315
Source: IManEngine
Description: Subscript out of range
Call Stack: AccpacOEShipment.CreateDetailEntry(lLineNum=0, lShipmentNumber=764737, bUpdatingShipment=True, bStandalone=True, bJobRelated=False)
Env: l=0, m=0, iLnType=1, sTaxClass='', sTaxIncBeforePrice='', sOrderNum='', bKitAssembly=False, bMiscCharge=False, bInsertingLine=False, bTaxIncBeforePrice=False
Call Stack: AccpacOEShipment.CreateShipment() ----------------------------------------------------
Env: l=0, lShipmentNumber=764737, s='5', sOrderNum='', sDistTax='', bCalcTax=True, bDistTax=False, bProcess=True, bUpdate=True, bHasShipmentNum=True, bHasInitialised=False, bStandalone=True, bJobRelated=False
Call Stack: AccpacOEShipment.AccpacImport_CreateTransactions() -----------------------------------
Call Stack: TransformAccpac.PerformTransform() ---------------------------------------------------
Call Stack: TransformAccpac.ITransformController_Process() ---------------------------------------
Env: sCompany='', l=1, bSupportsDynamicCompanies=False
Call Stack: TransformCoordinator.RunTransform(sTransformId='QYMPIFNQ') ---------------------------
Env: eTransformType=90, bWriteSummaries=False, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='QYMPIFNQ', l=0, m=0
Call Stack: TransformCoordinator.Process() -------------------------------------------------------
Call Stack: IntManEng.Main() ---------------------------------------------------------------------
Env: sCmd='"HSSPF Import To Sage"'

JFrench, see my response to your issue on the Sage300 forum.