Back to connectors… Back to Sage 300...

AccpacERPLookup - Method '~' of object '~' failed (2 replies)

Raoul Duke
9 years ago
Raoul Duke 9 years ago

For Accpac 6.2 PU3, are there any patch/upgrade requirements with IMAN as I am having issues with the AccpacERPLookup formulae. Below is an example of a Lookup formula being used and I can confirm that there were no errors running this on PU2.

AccpacERPLookup("TSTVIS", 0, "AR0024", "IDCUST", %CustNo , "IDNATACCT")

The error being returned is ;

Error whilst evaluating field [NatAcc] on transaction type [invoice].
Resolved Function - AccpacERPLookup("TSTVIS", 0, "AR0024", "IDCUST", "BBC" , "IDNATACCT")
Error - Description: Method '~' of object '~' failed

There is No National Account allocated to this customer but on Customers where a National Account has been applied, the same error is occurring.

And this is the same error for all AccpacERPLookup formulae used in the transforms.

The AccpacRecordExists function is not returning any errors.

AccpacRecordExists("TSTVIS", 0, "AR0024", "IDCUST" , %CustNo) returns a value of TRUE where the %CustNo = “BBC”

I have also checked that the updates to the new AOM tables have had no effect on these fields

Raoul Duke
9 years ago
Raoul Duke 9 years ago

Please ignore this query as I have found the problem.

The User rights have been removed for the IMAN user within Accpac.

Support
9 years ago
Support 9 years ago

Great!

Raoul, we need to fix the exception handling on these functions as they don't give back the proper error.

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