AccpacERPLookup - Method '~' of object '~' failed (2 replies)
Please ignore this query as I have found the problem.
The User rights have been removed for the IMAN user within Accpac.
Great!
Raoul, we need to fix the exception handling on these functions as they don't give back the proper error.
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