Method Community

Below is the beginning of a conflict error that I received after syncing.  Using ProSvcs Invoicing, did not realize that QB was not running when invoice created.  Please advise.

QuickBooks returned an error when adding/modifying a accInvoice record. The error was: The "LinkToTxn" field has an invalid value "TxnID=117-1313269139, TxnLineID=119-1313269139". . The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="8.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><InvoiceAddRq requestID="qx_1"><InvoiceAdd defMacro="TxnID:Invoice803064064"><CustomerRef><ListID>8000000C-1313269136</ListID></CustomerRef><ARAccountRef><ListID>80000028-1308018598</ListID></ARAccountRef><TxnDate>2011-08-22</TxnDate><RefNumber>265</RefNumber><BillAddress><Addr1>lt;/InvoiceAddRq></QBXMLMsgsRq></QBXML>

m.mehr,

This is most likely related to linking a sales order line to an invoice. Did you happen to create an invoice for a sales order that was deleted?

-Michael

I am using Pro Services, and the sales order related to my budget/contract has NOT been deleted, but it is marked as fully invoiced, and it appears that the four hours that I am billing was not added to the quantity on the sales order, because the sales order has the quantity billed on the first invoice.  This is the second invoice for this budget/contract.

m.mehr,

Try undeleting the conflict. I will try to duplicate this issue on my end.

-Michael

I undeleted the conflict per your instructions, did a full sync and error returned.  I think the root of the problem is in the underlying sales order related to the budget/contract.  It appears that the quantity on order was not increased for the additional time recorded.

I deleted the invoice from Method and the sales order appeared to have been updated with the additional hours, I re-invoiced and it worked.

m.mehr,

Thanks for updating me with this info. I will use what you mentioned to better test this issue on my end.

-Michael