Method Community

emailed account name and no its just the cutomer portal its the ask question screen i believe.  

Aaron - we checked the logs, and there was an issue with exporting one of your QuickBooks custom fields that started with a number rather than a letter. We've resolved it, so you should be okay going forward. Paul

Hello Dave,   I was on the CUSTOMIZE | INTEGRATION TOOLS | Export a file. I had chosen to export all fields.  NOTE: I tried again: I unchecked all and then checked what I needed – it worked.   Thanks! AG

That was the original failing case. The field in Table B that is linked to Table A's record ID cannot be written if I write a new row to table A and then pull the record ID from that new row. It appears that Table B does not know that the record ID for the new row is valid, and so balks at my insert. For example (using brief pseudo ...

Hi aarongoens, Can you please tell me what API function you are using that is causing the problem? Dave

 Jason L, Sorry to keep you waiting...it's been kinda a manic Monday....anyway... It sounds like you've added an extra field for recordid to table B, and have made it required. So it should be part of your insert list. Extending my example from above  string[ arrInsertFieldsArray = new string[ { "ArAccount", ...

If I choose to use the first option of adding a sort field to the table - have you used that with group items?  The client uses group items and in one template they need the detail printed and in another template they just print the group item name.  So I am wondering if this would make it a complex piece to figure out.  If they did ...

I'm just pinging on this. If I'm going about table construction or insertion wrong, please let me know. Thanks.

Hello,    I am trying to export my customer file so i can then use it as a template for importing. This is the error I am receiving: ERROR:Failure. There were problems with running the query, please verify your parameters My profile is set as ADMIN, the API, Table & Tab access is set correctly. What am I doing wrong? Thank ...

Depending on the importance of the feature.  There are 2 different approaches you could consider. You could add a field to the table that would contain the sort order or you could insert a new record (higher record id) then you could re-insert & delete the records with the smaller record id.  The later would have the effect of ...