Back to forum list… Back to How Do I?...

Subscript out of range: Sage 300 O/E Shipment Line Update (5 replies)

Arline Welty
2 months ago
Arline Welty 2 months ago

Hmm...I've tried deleting & re-adding the Sage 300 connector but can't seem to get around this error when I Refresh the connector: "Subscript out of Range". I'm updating Shipment Header & detail lines. I'm sensing that something is missing but can't discern what it is. I've looked at other Shipment Update connectors and it's not clear to me that this one is different. How do I figure out what data is needed?

Here is a screen snap of the setup for Shipment Header and Detail.

The connector is set to update, not insert.

Ideas on troubleshooting?

 

https://www.realisable.co.uk/wp-content/uploads/2019/06/ShipmentHeaderandDetail.jpg
Arline Welty
2 months ago
Arline Welty 2 months ago

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

Support
2 months ago
Support 2 months ago

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.

Arline Welty
2 months ago
Arline Welty 2 months ago

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"'

https://www.realisable.co.uk/wp-content/uploads/2019/06/ShipNumber_LineNumber.png
Support
2 months ago
Support 2 months ago

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.

Arline Welty
2 months ago
Arline Welty 2 months ago

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"'

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close