Method Community

This is the error I am getting when trying to insert a new customer record. with the MethodAPIInsertV2 api call. I have no clue what the error is, any way to find out? Do I first need to create a company record in order to add a customer record?

Thank you for the reply. I'll have to give this a shot. In the meantime, I've looped through the Estimate table and pulled out the maximum TxnNumber. I then increment this and stick it in the Estimate # object which links to the RefNumber. Method seems to have no problem with me sticking an integer into a text field, I just can't do it ...

Johnny, If you select the January version of Method (select "Switch to the January version" at the bottom of the login screen) you can actually use a SQL override to sort the RefNumber of the sales orders in the grid.  You can cast the field as integers.  Method will then sort accordingly. A note about ...

Hello, Can you give me an update on this? Any news at all? Thanks, Alex

Hi Johnny, There is no function to turn it into an integer.  It would also still need to stay text in order to sync with the Quickbooks field. - Adam

Is it possible to do a type conversion? The RefNumber is of type 'text'. One of the Character functions is isNumeric which returns TRUE or FALSE. Is there also a function that would allow you to turn it into an integer.

Edit: I've created a case for your request and you've been added to the queue. We'll reach out to you as soon as possible. - Ashur

Understood, I don't believe you can edit those fields in Method, which makes sense why there's no screen for it. - Ashur

Andy, The team is aware of the issue and are working on it.  I can assure you it is a high priority, and I'll update this thread when I hear more. - Adam

I've spoken with your Account Manager and he will be reaching out to you. - Ashur