Back to connectors… Back to Sage 300...

Error Updating Shipment Lines (9 replies and 1 comment)

JFrench
5 years ago
JFrench 5 years ago

Hello All,

I am getting this error "Subscript out of range" when attempting to update shipment lines. Without the Detail Lines in the sage connector there is no issue. But when I add the details I get this error.

I've bound Ordernumber, Shipmentnumber, Line match method, orderlinenum and Line Number, but despite filling these out I am getting a 0 line number, as well as a blank order number. Can you kindly let me know what I am missing? Or if you have any advice to try to solve this I would appreciate it.

Thanks!

Subscript out of range
Time='09/08/19 16:03:28' 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=771329, 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=771329, 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='GVNQPKBP') ---------------------------
Env: eTransformType=90, bWriteSummaries=False, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='GVNQPKBP', l=0, m=0
Call Stack: TransformCoordinator.Process() -------------------------------------------------------
Call Stack: IntManEng.Main() ---------------------------------------------------------------------
Env: sCmd='"TestingShipmentUpdateBASIC"'

Support
5 years ago
Support 5 years ago

JFrench, this is a bug (which will be rolled in 4.1 PU2).

Which version of IMan are you using?

JFrench
5 years ago

We are using Iman 4.1

JFrench
5 years ago
JFrench 5 years ago

Hello Support.

Do you have a timeline on when this update will be ready? Is there a hotfix or patch we can apply to just that one area for now? Let me know what our options are (if we have any).

Thanks,

Support
5 years ago
Support 5 years ago

We sent you a patch through our support.

JFrench
5 years ago
JFrench 5 years ago

Hello support, we have installed the patch. I am getting an error Matching Shipment Detail could not be found. I noticed in error logs it is still not filling out the order number even though I have filled it in. Is this possibly related to my previous issue, or have I set something up in error?

Matching Shipment Detail could not be found for [ORDNUMBER - / ITEMNO - 640].
Time='09/13/19 12:12:13' App='IManEngine:3.2.100' ADO-version='10.0' Computer='MN-DB2'
Method: AccpacOEShipment.PositionShipmentDetailLine
Number: 11105 = &H2B61 = vbObjectError + 2147232609 = ERRMAP_APP_FIRST + 2147227411
Source: HuntERR.Check
Description: Matching Shipment Detail could not be found for [ORDNUMBER - / ITEMNO - 640].
Call Stack: AccpacOEShipment.PositionShipmentDetailLine(sOrdNum='', bThrowErrorOnNotFound=True, bUpdatingShipment=True, lShipmentNumber=831430)
Env: bUsesOELineSeqMatching=False, sItemNo='640'
Call Stack: AccpacOEShipment.CreateDetailEntry(lLineNum=0, lShipmentNumber=831430, 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=831430, 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='Ship1') ------------------------------
Env: eTransformType=90, bWriteSummaries=False, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='Ship1', 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, the error is telling you that you're attempting to update a line based on the shipment number and item number, however the specific item (640) cannot be found on the shipment.

Is this correct? Perhaps if you can provide a couple of screenshots of the IMan mapping/preview & the Sage300 shipment you're trying to update and we can provide guidance.

Thanks

JFrench
5 years ago
JFrench 5 years ago

Hello Support, 

It was a problem with my setup. I had only set the Line Number and not the appropriate matching number from the Order Line.

I do however have another question for you. I am trying to update lot numbers on a shipment line. I am trying to first 0 out and remove the quantity on the existing lot. (using the same lot number, and the quantity 0 inside the Shipment Detail Lots part of the sage 300 transform). but I am getting an error that says this line already exists which makes me think it is doing an Insert instead of an update (but the transform is set to update only). 

Is this possible? If so can you provide me with an idea of how to update/modify the lots for a given shipment? 

 

Thanks,

Support
5 years ago
Support 5 years ago

JFrench, glad to see you have sorted this.

I don't think you're going to be able to replace lot numbers. This isn't tested or supported presently.

This is something we could do, but don't be waiting on this.

If this is a problem, please contact us separately off the forum.

JFrench
5 years ago
JFrench 5 years ago

Hello Support, would it be possible to change the quantity of an item on a specific lot? To sell for example 5 item ABC on lot 123 instead of 4 ABC(s) ?

Support
5 years ago
Support 5 years ago

JFrench, there is presently no support to update lot or serial numbers, including:

  1. Clear existing serial & lot numbers to replace them.
  2. Update quantity or other fields on existing lots.

Thanks

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