Method Community

I have some invoices with multiple taxes which won't post to Quickbooks. I'm getting this error trying to export the tax line item:

QuickBooks returned an error when adding/modifying a accInvoice record. The error was: The "line item rate/ratepercent" field has an invalid value "You cannot set the the rate for the given sales tax item line, use the amount field instead". . The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="12.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><InvoiceModRq requestID="qx_1"><InvoiceMod><TxnID>C2-1400092957</TxnID><EditSequence>1400092957</EditSequence><CustomerRef><ListID>80000006-1377912277</ListID></CustomerRef><ARAccountRef><ListID>80000024-1372873729</ListID></ARAccountRef><TemplateRef><ListID>80000003-1372615734</ListID></TemplateRef><TxnDate>2014-05-14</TxnDate><RefNumber>10</RefNumber><BillAddress><City>Test</City><PostalCode>08302013</PostalCode></BillAddress><ShipAddress><City>Test</City><PostalCode>08302013</PostalCode></ShipAddress><IsPending>0</IsPending><PONumber /><DueDate>2014-05-14</DueDate><FOB /><ShipDate>2014-05-14</ShipDate><ItemSalesTaxRef><ListID>80000008-1387833669</ListID></ItemSalesTaxRef><Memo /><IsToBePrinted>0</IsToBePrinted><IsToBeEmailed>0</IsToBeEmailed><CustomerSalesTaxCodeRef><ListID>80000001-1372615735</ListID></CustomerSalesTaxCodeRef><Other /><InvoiceLineMod><TxnLineID>C4-1400092957</TxnLineID><ItemRef><ListID>80000001-1372872995</ListID></ItemRef><Desc /><Quantity>1.00000</Quantity><Rate>50.00000</Rate><SalesTaxCodeRef><ListID>80000001-1372615735</ListID></SalesTaxCodeRef><Other1 /><Other2 /></InvoiceLineMod><InvoiceLineMod><TxnLineID>C5-1400092957</TxnLineID><ItemRef><ListID>8000000C-1400092562</ListID></ItemRef><Desc /><Other1 /><Other2 /></InvoiceLineMod><InvoiceLineMod><TxnLineID>C6-1400092957</TxnLineID><ItemRef><ListID>8000000B-1400081355</ListID></ItemRef><Desc>Sales Tax</Desc><RatePercent>2.50000</RatePercent><Other1 /><Other2 /></InvoiceLineMod><InvoiceLineMod><TxnLineID>C7-1400092957</TxnLineID><ItemRef><ListID>80000002-1372873067</ListID></ItemRef><Desc /><Quantity>1.00000</Quantity><Rate>50.00000</Rate><SalesTaxCodeRef><ListID>80000002-1372615735</ListID></SalesTaxCodeRef><Other1 /><Other2 /></InvoiceLineMod><InvoiceLineMod><TxnLineID>-1</TxnLineID><ItemRef><ListID>80000009-1393270807</ListID></ItemRef><Desc /><Quantity>1.00000</Quantity><Rate>20.00000</Rate><SalesTaxCodeRef><ListID>80000002-1372615735</ListID></SalesTaxCodeRef><Other1 /><Other2 /></InvoiceLineMod></InvoiceMod></InvoiceModRq></QBXMLMsgsRq></QBXML>

Hi rgatton,

This could be happening if the tax item was added as a line item, rather than being selected in the Tax Item field:

Can you please try deleting the tax from the line item, and adding it to this dropdown?

-Russell

Thanks for responding. I need multiple taxes applied to the invoice. I have one tax in the tax item drop-down and the additional taxes as line items. I'm able to do this in Quickbooks following the instructions on this page: http://dataservices.intuit.com/support/articles/how13181

But if I create an invoice using the same instructions on Method or if I edit an invoice like that which was synched from Quickbooks, I get the error when Method tries to push it back to Quickbooks.

Hi rgatton,

Thanks for the clarification. Instead of adding the tax as line items, can you create a tax group? This can be done in QuickBooks or Method. In Method you would go to the QuickBooks tab group > Lists > Items > New... > Sales Tax Group. Then you can add all the taxes that you require. After saving, the tax group will be available to select in the Tax Item dropdown (screenshot above).

Will this work for you?

-Russell

Thanks. I guess I can make that work for now. Are there any plans to support having tax items as line items?

-Robert

Hi Robert,

Unfortunately, the QuickBooks SDK does not allow tax line items. Because Method communicates with QuickBooks through the SDK, Method can't use tax line items.

-Russell

OK, thanks Russell. I will start using tax groups then.

-Robert

If your problem did not solve till now, i would suggest you recovery tool that  repair your corrupt QuickBooks file And Quickbooks  All  Error

• C=44, C=43, C=88, C=342 or similar cIndex error (Usually appears in older versions of Quickbooks) -6000, -301, -6150, -1006, -6189, -82 or similar error codes. (Usually appear in 2006 and newer versions of Quickbooks)
• Password Recovery and/or Removal
• Converting Accountants copies to a Regular Quickbooks Database

Efficiently removes inconsistencies from your QuickBooks file and helps you resolve any erroneous situation for quickbook error.
So Try Free Trail Version Software :- http://www.filesrecoverytool.com/quickbooks-recovery.html

Feel free to if you have any further questions about QuickBooks anything related to set-up. Good luck - QuickBooks is awesome Software

rgatton:

I have some invoices with multiple taxes which won't post to Quickbooks. I'm getting this error trying to export the tax line item:

QuickBooks returned an error when adding/modifying a accInvoice record. The error was: The "line item rate/ratepercent" field has an invalid value "You cannot set the the rate for the given sales tax item line, use the amount field instead". . The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="12.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><InvoiceModRq requestID="qx_1"><InvoiceMod><TxnID>C2-1400092957</TxnID><EditSequence>1400092957</EditSequence><CustomerRef><ListID>80000006-1377912277</ListID></CustomerRef><ARAccountRef><ListID>80000024-1372873729</ListID></ARAccountRef><TemplateRef><ListID>80000003-1372615734</ListID></TemplateRef><TxnDate>2014-05-14</TxnDate><RefNumber>10</RefNumber><BillAddress><City>Test</City><PostalCode>08302013</PostalCode></BillAddress><ShipAddress><City>Test</City><PostalCode>08302013</PostalCode></ShipAddress><IsPending>0</IsPending><PONumber /><DueDate>2014-05-14</DueDate><FOB /><ShipDate>2014-05-14</ShipDate><ItemSalesTaxRef><ListID>80000008-1387833669</ListID></ItemSalesTaxRef><Memo /><IsToBePrinted>0</IsToBePrinted><IsToBeEmailed>0</IsToBeEmailed><CustomerSalesTaxCodeRef><ListID>80000001-1372615735</ListID></CustomerSalesTaxCodeRef><Other /><InvoiceLineMod><TxnLineID>C4-1400092957</TxnLineID><ItemRef><ListID>80000001-1372872995</ListID></ItemRef><Desc /><Quantity>1.00000</Quantity><Rate>50.00000</Rate><SalesTaxCodeRef><ListID>80000001-1372615735</ListID></SalesTaxCodeRef><Other1 /><Other2 /></InvoiceLineMod><InvoiceLineMod><TxnLineID>C5-1400092957</TxnLineID><ItemRef><ListID>8000000C-1400092562</ListID></ItemRef><Desc /><Other1 /><Other2 /></InvoiceLineMod><InvoiceLineMod><TxnLineID>C6-1400092957</TxnLineID><ItemRef><ListID>8000000B-1400081355</ListID></ItemRef><Desc>Sales Tax</Desc><RatePercent>2.50000</RatePercent><Other1 /><Other2 /></InvoiceLineMod><InvoiceLineMod><TxnLineID>C7-1400092957</TxnLineID><ItemRef><ListID>80000002-1372873067</ListID></ItemRef><Desc /><Quantity>1.00000</Quantity><Rate>50.00000</Rate><SalesTaxCodeRef><ListID>80000002-1372615735</ListID></SalesTaxCodeRef><Other1 /><Other2 /></InvoiceLineMod><InvoiceLineMod><TxnLineID>-1</TxnLineID><ItemRef><ListID>80000009-1393270807</ListID></ItemRef><Desc /><Quantity>1.00000</Quantity><Rate>20.00000</Rate><SalesTaxCodeRef><ListID>80000002-1372615735</ListID></SalesTaxCodeRef><Other1 /><Other2 /></InvoiceLineMod></InvoiceMod></InvoiceModRq></QBXMLMsgsRq></QBXML>

Similar with Error importing chart of accounts into quickbooks you can solve the probl;em causing Error posting invoice with multiple taxes, Or you can have a thired party quickbook technical support to get things done as well. !

Hi Mcgrager,

If the above-posted solution doesn't work for you, can you please email us on Success@method.me and our support team can help you with this over screen sharing session?