Re: Can not sync some Bill to QuickBooks

alexhuang — Thu, 13 Aug 2015 21:36:14 GMT

Hi Mortaza,

That was it. Thanks, that saves me lots of time.

However, this issue also raises some questions:

1. It seems that order of RecordID and TxtLineID are not always the same. In my case, RecordID is in the order I inserted those BillLineItem, however, TxtLineID is not, it is quite random. Is it the correct behavior?

2. If this kind of random behavior is correct, then, does it mean we need to insert BillLineItem (and other transaction line item) in order of TxnLineID, but not in their RecordID?

Regards,

Alex

Re: Can not sync some Bill to QuickBooks

Method_Morty — Thu, 13 Aug 2015 20:25:38 GMT

Hey Alex,

Please take a look at the last post in THIS thread, it looks like it is very similar to your conflict.

- Mortaza

Can not sync some Bill to QuickBooks

alexhuang — Thu, 13 Aug 2015 19:20:22 GMT

Hi,

I'm using QuickBooks 2013 windows, and there are two Bills that are reported with conflict. The error message (of one bill) is like:

QuickBooks returned an error when adding/modifying a accBill record. The error was: The "LinkToTxn" field has an invalid value "TxnID=2962D-1439372359, TxnLineID=2964A-1439372359". . The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="12.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><BillAddRq requestID="qx_1"><BillAdd defMacro="TxnID:Bill1059266560"><VendorRef><ListID>800000D0-1305929644</ListID></VendorRef><APAccountRef><ListID>80000019-1272298004</ListID></APAccountRef><TxnDate>2015-08-12</TxnDate><DueDate>2015-10-11</DueDate><RefNumber>150233X</RefNumber><TermsRef><ListID>80000007-1270854529</ListID></TermsRef><ItemLineAdd><Desc>EQPU2019612</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>2965E-1439372359</TxnLineID></LinkToTxn></ItemLineAdd><ItemLineAdd><Desc>EQPU2019741</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>2965F-1439372359</TxnLineID></LinkToTxn></ItemLineAdd><ItemLineAdd><Desc>EQPU2020043</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>2964A-1439372359</TxnLineID></LinkToTxn></ItemLineAdd><ItemLineAdd><Desc>EQPU2020212</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>29649-1439372359</TxnLineID></LinkToTxn></ItemLineAdd><ItemLineAdd><Desc>EQPU2020357</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>2964C-1439372359</TxnLineID></LinkToTxn></ItemLineAdd><ItemLineAdd><Desc>EQPU2020378</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>29648-1439372359</TxnLineID></LinkToTxn></ItemLineAdd><ItemLineAdd><Desc>EQPU2020423</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>2964B-1439372359</TxnLineID></LinkToTxn></ItemLineAdd><ItemLineAdd><Desc>EQPU2020439</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>2964E-1439372359</TxnLineID></LinkToTxn></ItemLineAdd><ItemLineAdd><Desc>EQPU2020444</Desc><Quantity>1.00000</Quantity><Cost>1720.00000</Cost><LinkToTxn><TxnID>2962D-1439372359</TxnID><TxnLineID>2964D-1439372359</TxnLineID></LinkToTxn></ItemLineAdd></BillAdd></BillAddRq></QBXMLMsgsRq></QBXML>

It seems to me that the linked PurchaseOrderLine TxnLineID is not correct. I tried to do full synchronization several times, but still no luck. The TxnLineID I found in my Method table matchs the PurchaseOrderLine item. Does it mean that something mismatched about this TxnLineID between Method and QuickBooks? Or any suggestion to make it work? Thanks.

Alex

Method:Classic General Q&A

Re: Can not sync some Bill to QuickBooks

Re: Can not sync some Bill to QuickBooks

Can not sync some Bill to QuickBooks