RecordID 394 stuck in Invoice table purgatory.
MethodAPI response = "Save Warning: The invoice is not ready to send to QuickBooks. The RecordID 394 does not exist."
to a MethodAPIDeleteV2 call (via HTTP POST) with parameters:
strCompanyAccount=***&strLogin=***&strPassword=***&strSessionID=&strTable=Invoice&intRecordID=394
I reproduced this via (the uber helpful) page https://www.methodintegration.com/MethodAPI/service.asmx?op=MethodAPIDeleteV2.
This is a left-over record in the Invoice table from an aborted insertion (due to an ephemeral MethodAPI-down event). I have successfully deleted the left-over InvoiceLine record(s), but cannot delete the Invoice record.
A MethodAPISelect_XMLV2 call confirms that RecordID 394 exists. So this error message is doubly strange.
On a whim I called MethodAPIActionSendToDesktopV2 (never got to that point during the original insert) which succeeded, but the delete still failed with the above message. The record will not go through the sync engine to QuickBooks either. No conflicts to resolve on the Method CRM console.
Urgent help appreciated, order(s) held up.