Search results by user ID 6819

Update QB group quantities

smwarren — Fri, 13 Jan 2017 17:57:26 GMT

We enter a lot of our products as QuickBook groups and then show each item in the group on the invoice. When the salesperson changes the quantity of the group, it doesn't update the quantity of each part. Is there a way to do this? Also, keep in mind that there are sometimes several groups on an invoice.

Re: Integration Engine Sync Error

smwarren — Fri, 24 Jun 2016 20:03:08 GMT

So it miraculously healed itself while I was preparing to send you my info. I guess it didn't want you poking around. :)

Thanks for your help and we'll probably never know why it happened (I was signed into QB as admin, BTW, so it wasn't that)

Re: Integration Engine Sync Error

smwarren — Fri, 24 Jun 2016 16:07:33 GMT

There was this message on Monday. I did a verify and rebuild but it didn't resolve the problem, although this message hasn't returned:

There was an issue with the sync. Try doing a File > Utilities > Verifiy and Rebuild in QuickBooks, and trying again. Also, make sure QuickBooks has all updates installed. If this persists, contact technical support.
Now for the technical stuff! QuickBooks SDK response was: Insufficient permission level to perform this action.
The request was: <?xml version="1.0" ?> <?qbxml version="13.0"?> <QBXML> <QBXMLMsgsRq onError = "stopOnError"> <TimeTrackingQueryRq requestID = "0"> <ModifiedDateRangeFilter><FromModifiedDate>2016-06-20T14:05:25-08:00</FromModifiedDate></ModifiedDateRangeFilter> <IncludeRetElement>TxnID</IncludeRetElement> <IncludeRetElement>TimeModified</IncludeRetElement> <IncludeRetElement>TxnDate</IncludeRetElement> </TimeTrackingQueryRq> </QBXMLMsgsRq> </QBXML>
The response was: <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <TimeTrackingQueryRs requestID="0" statusCode="3260" statusSeverity="Error" statusMessage="Insufficient permission level to perform this action." /> </QBXMLMsgsRs> </QBXML>

Also, I watched while the Integration Engine did a full sync and the error happens when it is syncing the invoices table.

Integration Engine Sync Error

smwarren — Thu, 23 Jun 2016 21:59:22 GMT

Method has not been syncing with QB desktop 2015 for several days. The integration engine says that it is connected, and it runs through the process, but it displays this message and the sync preferences don't show that a sync has been performed:

6/23/2016 2:47:48 PM ERROR'MESSAGE'Index was outside the bounds of the array./MESSAGE'STACKTRACE' at SyncServices_Service.WebService.fnClearServerTimeModified(String sDataBaseName, String sTableName, Int32 intRecordID, String sListIDfromDesktop, String sDesktopIDField, enumClearServerTimeModifiedOption ClearOptionChoice, String sEditSequence, String sWebServiceEncryptionKey, Int32 intSecurityID) in C:\TeamCity\buildAgent\work\a43c154e2b2d27f8\SyncServices Service\SyncServices Service\WebService.asmx.vb:line 52882/STACKTRACE'/ERROR''Template' 1 modification(s)

What do you suggest?

Re: Question about filtering Pivot Grid

smwarren — Mon, 26 Oct 2015 19:27:20 GMT

That worked, but it turned out I wanted to filter out two different IncomeAccounts and also filter out any empty fields, so I created a grid and set up different filters becaue I couldn't see a way to filter out two negatives. Another question -- If I group the data in my pivot grid by month based on the transaction date, only the month shows in the date field, if I change the formatting to MM-dd, it groups by that. Is there a way to both group by month and show the actual date?

Question about filtering Pivot Grid

smwarren — Sun, 25 Oct 2015 00:11:58 GMT

I have a Pivot Grid set up for the InvoiceLine table showing the IncomeAccount as the row header. Everything is set up how I want, but I would like to filter out one of the IncomeAccounts so it nevr shows. Is there a way to do this?

QuickBook conflict with Vendors

smwarren — Fri, 23 Oct 2015 15:49:46 GMT

Hello -

I am getting repeated QuickBooks sync errors, but only with Vendors. As far as I know, we don't do anything in Method with Vendors (that's done by the accounting department in QuickBooks). These all seem to be for vendors that we haven't used for several years and the errors look like this:

QuickBooks returned an error when adding/modifying a accEntity record. The error was: There has been an internal error when processing the request.. The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="13.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><VendorModRq requestID="qx_1"><VendorMod><ListID>8000004D-1197588445</ListID><EditSequence>1346349127</EditSequence><Name>Dex Media West LLC</Name><IsActive>0</IsActive><CompanyName /><Salutation /><FirstName /><MiddleName /><LastName /><VendorAddress><Addr1>Dex Media West</Addr1><Addr2>PO Box 79167</Addr2><Addr3 /><Addr4 /><Addr5 /><City>Phoenix</City><State>AZ</State><PostalCode>85062</PostalCode><Country /><Note /></VendorAddress><Phone>800-422-1234</Phone><AltPhone /><Fax /><Email /><Contact>Dex Media West LLC</Contact><AltContact /><NameOnCheck>Dex West</NameOnCheck><AccountNumber>100595187</AccountNumber><Notes>as of 9/10: Seattle Yellow Pages through 6/14/11 (Greater Eastside ended 9/19/10)</Notes><TermsRef><ListID>80000005-1197497544</ListID></TermsRef><VendorTaxIdent /><IsVendorEligibleFor1099>0</IsVendorEligibleFor1099></VendorMod></VendorModRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>Send 1099?</DataExtName><ListDataExtType>Vendor</ListDataExtType><ListObjRef><ListID>8000004D-1197588445</ListID></ListObjRef></DataExtDel></DataExtDelRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>W-9 on File?</DataExtName><ListDataExtType>Vendor</ListDataExtType><ListObjRef><ListID>8000004D-1197588445</ListID></ListObjRef></DataExtDel></DataExtDelRq></QBXMLMsgsRq></QBXML>

Should I resolve these by clicking on Delete From Method or is there something else I should to stop these errors?