Back to connectors… Back to Sage 300...

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

Arline Welty
5 years ago
Arline Welty 5 years 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
5 years ago
Arline Welty 5 years 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
5 years ago
Support 5 years 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
5 years ago
Arline Welty 5 years 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
5 years ago
Support 5 years 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
5 years ago
Arline Welty 5 years 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"'

JFrench
5 years ago
JFrench 5 years ago

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

Support
5 years ago
Support 5 years ago

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

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