Method:Classic General Q&A

Re: Insert Record Error

Method_Ashur — Tue, 11 Jun 2013 19:04:18 GMT

Hey Garrett,

How are you inserting the invoice record, are you simply using the Insert Record into Table action, or are you clicking Save on the Invoice screen?

This is most likely due to that Account name being available separately for several tenants. For example, the account name across the board is Accounts Receivable, however the main account's RecordID for this account is 1, and the tenant accounts RecordID for the account is 7. So it's technically a different account, but it doesn't look that way to you because you're looking at the name of the account (Accounts Receivable).

You'll most likely need to speak with an in-house Consultant or one of our Method Solution Providers (MSP) to get assistance with this issue because Multi-Tenancy is more involved and there could be other things we're overlooking right now.

- Ashur

Re: Insert Record Error

bcr_garrett — Tue, 11 Jun 2013 17:13:45 GMT

Thanks for the clarification Ashur - it will come in handy. Here's some more info on what is happening...

If I am signed into the tenant account, the button works fine (insert actions for a new invoice). The tenant id is specified on both the invoice header and line item insert command. However, if I am using the same button from our "main" account, I get the invoice error related to AR Account. Is there anything that comes to mind that would cause this error - anything from a multi-tenancy perspective?

Thanks,
Garrett

Re: Insert Record Error

Method_Ashur — Tue, 11 Jun 2013 16:46:29 GMT

Hey bcr_garrett,

Perform a search for the Object number (80000029-1249501594) and you'll see it show up twice within that message. The first time it shows up in the error message and the second time it shows up in the request data. If you look carefully, the object number is surrounded by ListID, which is in turn surrounded by ARAccountRef. ARAccountRef is a field in the Invoice table which is a dropdown linked to the Account table. A ListID is a unique number given to records in QuickBooks, so if one of your records in Method has a different ListID than in QuickBooks your QB file may be corrupted.

So this message is basically saying that this particular ListID (80000029-1249501594) in the Account table cannot be found in QuickBooks. If you click on the More Info... link for this conflict you'll be able to locate the invoice using the RefNumber field (Invoice #). Look up that particular invoice and ensure a valid Account is selected. Hope this helps!

FYI - These messages all come from QuickBooks so you can perform a search online using the first or second sentence and find a solution.

- Ashur

Insert Record Error

bcr_garrett — Tue, 11 Jun 2013 16:19:32 GMT

When inserting a record - an invoice (header and line item) - from our main account into a tenant account, I am getting the following error:

QuickBooks returned an error when adding/modifying a accInvoice record. The error was: Object "80000029-1249501594" specified in the request cannot be found. . 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:Invoice2050155008"><CustomerRef><ListID>8000000A-1370958938</ListID></CustomerRef><ARAccountRef><ListID>80000029-1249501594</ListID></ARAccountRef><TxnDate>2013-06-11</TxnDate><IsPending>0</IsPending><IsToBePrinted>0</IsToBePrinted><IsToBeEmailed>0</IsToBeEmailed><InvoiceLineAdd defMacro="TxnLineID:Invoice300694400"><Quantity>1.00000</Quantity><Rate>0.00000</Rate></InvoiceLineAdd></InvoiceAdd></InvoiceAddRq></QBXMLMsgsRq></QBXML>

I have verified the information is valid by creating the invoice manually. I have also verified that the invoice is being created in the proper tenant file - will not sync to QB due to the error. I have tried using only the required fields (along with the proper tenant id) as well.

Any ideas what "Object" the error is referencing?