Method Community

 

Invoice Sync Issues

Last post 11-18-2011 10:50 AM by GForce. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-18-2011 10:34 AM

    • GForce
    • Not Ranked
    • Joined on 10-12-2011
    • Posts 4

    Invoice Sync Issues

    I'm getting an error when we try to sync method to QuickBooks. It appears that there is a problem with the sales tax on invoices but we don't see anything wrong with the invoices in QuickBooks. Here is the text from the error, any ideas?

     

     

    QuickBooks returned an error when adding/modifying a accInvoice record. The error was: There was an error when modifying a Invoice. QuickBooks error message: The Transaction Sales Tax field cannot be left blank, even for non-taxable customers and sales which have no taxable items, so non-taxable sales will be correct for this district.. The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="8.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><InvoiceModRq requestID="qx_1"><InvoiceMod><TxnID>15BB6-1298990387</TxnID><EditSequence>1298990387</EditSequence><CustomerRef><ListID>C0000-962476034</ListID></CustomerRef><ARAccountRef><ListID>3E0000-962477453</ListID></ARAccountRef><TemplateRef><ListID>10000-965141881</ListID></TemplateRef><TxnDate>2011-02-22</TxnDate><RefNumber>LSI-2406</RefNumber><BillAddress><Addr1>THE SCOTTS COMPANY</Addr1><Addr2>14111 SCOTTSLAWN ROAD</Addr2><City>MARYSVILLE</City><State>OH</State><PostalCode>43041</PostalCode><Country>USA</Country></BillAddress><ShipAddress><Addr1>THE SCOTTS COMPANY</Addr1><City>OXFORD</City><State>PA</State></ShipAddress><IsPending>0</IsPending><PONumber>458559</PONumber><TermsRef><ListID>70000-965057131</ListID></TermsRef><DueDate>2011-04-23</DueDate><FOB>OXFORD, PA</FOB><ShipDate>2011-02-22</ShipDate><IsToBePrinted>0</IsToBePrinted><IsToBeEmailed>1</IsToBeEmailed><InvoiceLineMod><TxnLineID>15BB8-1298990387</TxnLineID><ItemRef><ListID>80000027-1202410351</ListID></ItemRef><Desc>LIGNOCELL BLOCKS/5:1 COMPRESSION</Desc><Quantity>20.00000</Quantity><Rate>433.00000</Rate><SalesTaxCodeRef><ListID>20000-1058534465</ListID></SalesTaxCodeRef></InvoiceLineMod></InvoiceMod></InvoiceModRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>Arrival date</DataExtName><TxnDataExtType>Invoice</TxnDataExtType><TxnID>15BB6-1298990387</TxnID></DataExtDel></DataExtDelRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>BOL #</DataExtName><TxnDataExtType>Invoice</TxnDataExtType><TxnID>15BB6-1298990387</TxnID></DataExtDel></DataExtDelRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>Container #1</DataExtName><TxnDataExtType>Invoice</TxnDataExtType><TxnID>15BB6-1298990387</TxnID></DataExtDel></DataExtDelRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>Container #2</DataExtName><TxnDataExtType>Invoice</TxnDataExtType><TxnID>15BB6-1298990387</TxnID></DataExtDel></DataExtDelRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>Container #3</DataExtName><TxnDataExtType>Invoice</TxnDataExtType><TxnID>15BB6-1298990387</TxnID></DataExtDel></DataExtDelRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>Container #4</DataExtName><TxnDataExtType>Invoice</TxnDataExtType><TxnID>15BB6-1298990387</TxnID></DataExtDel></DataExtDelRq><DataExtDelRq><DataExtDel><OwnerID>0</OwnerID><DataExtName>Container #5</DataExtName><TxnDataExtType>Invoice</TxnDataExtType><TxnID>15BB6-1298990387</TxnID></DataExtDel></DataExtDelRq><DataExtDelRq>&l

  • 11-18-2011 10:44 AM In reply to

    Re: Invoice Sync Issues

    GForce-

    Is there a Tax Item set for this invoice? If you are looking at this invoice on the Standard Invoice screen, what do you have listed under the Tax Item drop down? If its blank try selecting something.

    -Michael

    Michael Melo
    Product Manager
    Method Integration Inc.
    Website: http://www.method.me
    LinkedIn: http://www.linkedin.com/in/MichaelMelo
  • 11-18-2011 10:50 AM In reply to

    • GForce
    • Not Ranked
    • Joined on 10-12-2011
    • Posts 4

    Re: Invoice Sync Issues

    Answer

    I think i found the issue, we had this screen customized and there was no default Sales Tax item setup so there are alot of invoices that do not have a sales tax item selected. 

    I am working on a button to assign the sales tax item to all the invoices without one. 

    Thanks for your reply

Page 1 of 1 (3 items)