Method Community

Justin, any idea why? This would be a very useful SQL function to access. Can you give me a list of all available SQL functions in Method, or at least a list of restricted ones?

A full sync was run overnight last night.  There are some conflicts under QB > Resolve Conflicts, but they are not related to this record.  Whereas before I merged the records on QBO, I could see the transactions under the old, merged record, now the older record shows "deleted" and the transactions are gone, and they have ...

Hi furrywombat, That function doesn't seem to be available through SQL overrides. It may be possible to emulate, however I'm not sure how that would be accomplished, and doing so isn't recommended. - Justin

Hi Craig, Have you tried running a full sync, to see if that updates the transactions in Method? Do you have any conflicts listed under QuickBooks > Resolve Conflicts? - Justin

Hi incognito, Glad to hear you've got it working. Let us know if you run into any other issues. - Justin

Is there any chance of this improvement happening again any time soon? FW

It seems to me that I made the captions on the screen for a few bill to and ship to fields identical  by eliiminating some leading spaces (city, state, zip, country). After putting "bill to" and "ship to" in front of the respective captions, the issue seems to have been resolved.

Hi Justin, That shared result is updated in a pop-up screen. It is just like a popup-dialog. What I'm doing is like: 1. in main screen, set argCLS_OKCancel = "Cancel" as a shared result. 2. call a popup screen, if user select "OK", then argCLS_OKCancel is updated as "OK", or it is updated as ...

i bypassed thr entire screen load routine in the advanced screen properties. Same result. I am now goning through each field and button looking for bad references. So far I do not see anything out of place.

GROUP_CONCAT: Can't seem to make this work on SQL override field. Is GROUP_CONCAT a restricted function for the override fields?