Method '~' of object '~' failed (6 replies)
Django, I can replicate your issue. Can you ensure:
- The view VI0700 is valid.
- The field "ORDNUMBER" (i.e. the 4th argument) is valid?
We do need to handle errors on the AccpacXXX functions in a much better manner.
VI0700 is a valid view. It is an Orchid Extender view. ORDNUMBER is a valid field within that table. We processed about 60 transactions this morning with no problems. Then the error appeared. We restarted IMan and processed another 80 transactions, including the one reported in the log as being affected by this error message.
Django, would it be possible for you to use an alternative function?
For example you could use just the standard Lookup function, or the AccpacCustomLookup (which uses CS0120).
Thanks
I'll try switching over to the custom lookup. I'm getting this message every other day.
Just an update - using AccpacERPCustomLookup appears to be more stable. This message hasn't appear today at all.
Closed due to inactivity.
I have a script in a Map transform used for validation. It appears that if I edit the script that there's a strong possibility that I'll get the error message within the header. The only way to get rid of the error is to restart the IMan services. If I edit the formula to remove the Sage 300 specific functions then I don't see the error.
Dim result Dim DuplicateOrder result = 0 Dim FoundOrder FoundOrder = ACCPACRECORDEXISTS("SAMS300INC",0,"VI0700","ORDNUMBER",%ORDNUMBER) DuplicateOrder = GetRegisteredValue(%ORDNUMBER) "" RegisterValue %ORDNUMBER, %ORDNUMBER if FoundOrder OR (DuplicateOrder) then result = 1 if %PAYTYPE="" then result = 5 if %PAYTYPE="CC" then if %CreditCardType="" then result = 6 WriteToLog 99, "Credit card type is blank" end if if %CreditCardType="CC" then result = 6 WriteToLog 99, "Credit card type is CC" end if end if result