Method Community

[quote user="viret56"]I have examine my code and logic from several angels.  The 'Go To Tab Link' action has the correct parameters.  I have many 'why' questions but no answers.  Does anyone recognize this unexpected behavior? [/quote] I have not seen this behaviour so it's hard to determine what ...

Greetings, I cant seem to find any info on this. What happends when Quickbooks Home>Bill. and i enter a expense or Item and enter the customer and make it billable.  What happens when i make it billable? Thanks! John M

Greetings, When i create a work order from a case i put in the comment section a brief note about the nature of the work order.  When i go into field services work order list, that brief note or job name, its a space down so its hard to see.   Thanks!  John M

Greetings, Home>Quickbook reports I am looking for a Budget VS Actual report but i dont see it in Method.  Its in quickbooks.  Is it possible to make a new report? Thanks

Hi Dave, I think I can see a way forward from here. Thanks a lot. Jason

 Hi Jason L, We do not grant programmatic SQL access. That would be a severe security policy violation (among other issues....). The synchronization between your method account and quickbooks is handled via the method synchronization engine. (You can read up on that in the documentation at ...

And this may seem like a stretch, but I even tried SQL script of ISNULL(viewCustomer.Notes,'') and this didn't work, either.

I've successfully added another column for my Addresses.  I needed the SQL override for this column since it conatined multiple items (Address, City, State, and Zip), and it's working just fine.  Here's the script I used to that: SQL script: ISNULL(viewContacts.BillAddressAddr3,'') + '<br />' + ...

[quote user="Jason_L"]Can you give me ideas on how I can do that?[/quote] I'm going to move this thread to the API forum and I can say I don't think what you're trying to do is possible ouside the Method API.  From my knowledge there is no direct access to our database without going through the API.

As part of our business plan, we are devloping a java applet that will be run atuomatically and needs to write to our SQL database directly, without human interaction. Therefore, we need to be able to connect with the database directly. We're using Java and the JDBC standards. I've found the correct MS SQL driver for the database, but ...