409 error for QBO bill update

[mcclowes]

Migrated question from old forum

I'm doing this update for QuickBooks and i receice a 409 error. I've done a sync for bills previously.

Any idea ?

Error : An error occurred in a downstream service. Correlation ID: 80c4013469dd9c2d81ee4e5d5935879f. Message: Failed to update Bill. Please make sure that you have synced the Bill data

Update :

companyId = 5c856bac-27ca-4565-a68d-f4d36ca8edb3
connectionId = 5c856bac-27ca-4565-a68d-f4d36ca8edb3
billId = 6

{
"id": "6",
"reference": "2001",
"supplierRef": {
"id": "27",
"supplierName": "Hayden Insurance Co"
},
"purchaseOrderRefs": [],
"issueDate": "2021-08-06T00:00:00",
"dueDate": "2021-08-06T00:00:00",
"currency": "GBP",
"currencyRate": 1,
"lineItems": [
{
"description": "Insurance - general liability 750",
"unitAmount": 750,
"quantity": 1,
"discountAmount": 0,
"subTotal": 750,
"taxAmount": 150,
"totalAmount": 900,
"accountRef": {
"id": "22",
"name": "Insurance Expense-General Liability Insurance"
},
"taxRateRef": {
"id": "3_Bills",
"name": "20.0% S Bills",
"effectiveTaxRate": 20
},
"trackingCategoryRefs": [],
"tracking": {
"categoryRefs": [],
"isBilledTo": "Unknown",
"isRebilledTo": "NotApplicable"
},
"isDirectCost": true
}
],
"withholdingTax": [],
"status": "Void",
"subTotal": 750,
"taxAmount": 150,
"totalAmount": 900,
"amountDue": 0,
"modifiedDate": "2023-01-22T15:25:23Z",
"paymentAllocations": [],
"metadata": {
"isDeleted": true
}
}

[mcclowes]

For an update push operation, we compare the sourceModifiedDate of the record that Codat has stored, to the modified date of the record in the 3rd party system (QBO in this case). If they don't match then we return this error as a safety mechanism against unexpectedly overwriting data. Now, there are two ways to overcome this:

Queue a data sync for the company and once complete, update the bill. Queuing a data sync can also be achieved in the portal by going into the company you're updating the bill for and pressing 'Refresh data'.
Use the query parameter, forceUpdate=true to override the safety mechanism.
Let me know how you get on.