Method:Classic General Q&A

Re: New Problems syncing Bills and invoices

Method_Michael — Mon, 26 Mar 2012 20:02:09 GMT

Innovative-

If you want to go over this in detail you would need to book some paid consulting time.

One additonal thing that you could try is re-create the bill in QuickBooks the exact same way that you created it in Method and see if QuickBooks flags it. This does mean double entry but if this same issue ever comes up again you will know what the cause is.

-Michael

Re: New Problems syncing Bills and invoices

Innovative — Mon, 26 Mar 2012 15:07:39 GMT

Michael,

I am confused All of the items in the list are expense items, can i get some help with this to figure out what is going on?

Re: New Problems syncing Bills and invoices

Method_Michael — Mon, 26 Mar 2012 14:11:15 GMT

I did some more research on this and another potential issue is the account you have selected for the Bill line items, I believe it has to be an expense account, otherwise it will get rejected by QuickBooks.

-Michael

Re: New Problems syncing Bills and invoices

Innovative — Mon, 26 Mar 2012 13:59:02 GMT

Paul,

I resolved the issue of sales rep. THX!

As far as the Bills that wont post to qbooks i have tried several diff scenarios and still no luck. I have changed to "has been billed" " not billable" and " billable" and added a customer still wont sync

Re: New Problems syncing Bills and invoices

Method_Paul — Fri, 23 Mar 2012 16:36:57 GMT

Invoices and Bills aren't assigned to users. They are assigned to sales reps, customers and vendors.

If you are changing the employee assignment of a sales rep, it's best to just change that directly in QuickBooks - it'll then transfer over to Method.

Paul

Re: New Problems syncing Bills and invoices

Innovative — Fri, 23 Mar 2012 14:56:58 GMT

Paul,

Yes, that makes sense, Method will not allow me to EDIT 1 user so i can link it to another active employee in Qbooks. This was one of the issues i had with marathon that was left undone. When i try to edit this user it tells me its not a valid user. Marathon told me to create a new user and remove the other one. I could do this if needed but prefer not to. Can you look into this.

Re: New Problems syncing Bills and invoices

Method_Paul — Fri, 23 Mar 2012 14:16:52 GMT

@innovative - the conflicts look legit, but hard to decipher. These messages are coming straight from QuickBooks.

For the invoice, you can see the id it's complaining about is the sales rep. QuickBooks is saying that the sales rep assigned to the invoice no longer exists in your QuickBooks file.

You can click "More Info" to let you know which invoice it is talking about and which sales rep QuickBooks is reporting doesn't exist.

For the Bill, it is saying that the line items are marked as billable, but billable to "who"? It doesn't look like you've specified a customer that this items should be billable to. You can click More Info here to see more about which Bill it is referrng to.

Paul

New Problems syncing Bills and invoices

Innovative — Fri, 23 Mar 2012 14:03:23 GMT

I recently just had problems with bills and some invoices not posting. This just started and now i have many conflicts that i dont know how to resolve. Sometimes if i try to resync and push them thru after the conflict it goes. below are example of 2 conflicts of many:

This is example of invoice that wont post:

QuickBooks returned an error when adding/modifying a accInvoice record. The error was: Object "80000017-1199282837" specified in the request cannot be found. QuickBooks error message: Invalid argument. The specified record does not exist in the list.. 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:Invoice1531485312"><CustomerRef><ListID>8000147E-1331064246</ListID></CustomerRef><ARAccountRef><ListID>80000023-1199281052</ListID></ARAccountRef><TxnDate>2012-03-22</TxnDate><IsPending>0</IsPending><SalesRepRef><ListID>80000017-1199282837</ListID></SalesRepRef><IsToBePrinted>1</IsToBePrinted><IsToBeEmailed>1</IsToBeEmailed><InvoiceLineAdd defMacro="TxnLineID:Invoice1125602560"><ItemRef><ListID>800002DB-1274894436</ListID></ItemRef><Desc>(2) man Labor rate for Preferred Members only: replace 3 defective rotors. cap 2 rotors. repair leaking spray in center island.</Desc><Quantity>1.25000</Quantity><Rate>105.00000</Rate><ServiceDate>2012-03-21</ServiceDate></InvoiceLineAdd><InvoiceLineAdd defMacro="TxnLineID:Invoice1873633920"><ItemRef><ListID>80000147-1199282764</ListID></ItemRef><Desc>Hunter/KRAIN 4' Pop Up Rotor Adjustable w/#6 Nozzle</Desc><Quantity>3.00000</Quantity><Rate>25.00000</Rate><ServiceDate>2012-03-21</ServiceDate></InvoiceLineAdd></InvoiceAdd></InvoiceAddRq></QBXMLMsgsRq></QBXML>

This is example of 1 of many bills that wont post

QuickBooks returned an error when adding/modifying a accBill record. The error was: The "billable status" field has an invalid value "Billable". QuickBooks error message: Target is not reimbursable.. The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="8.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><BillAddRq requestID="qx_1"><BillAdd defMacro="TxnID:Bill1028793856"><VendorRef><ListID>80000A52-1199283052</ListID></VendorRef><APAccountRef><ListID>8000004A-1199282715</ListID></APAccountRef><TxnDate>2012-03-09</TxnDate><DueDate>2012-05-08</DueDate><RefNumber>4209907-00</RefNumber><TermsRef><ListID>80000007-1199224272</ListID></TermsRef><ItemLineAdd><ItemRef><ListID>800002CD-1274482144</ListID></ItemRef><Desc>PVC PIPE-WSE200. 75"</Desc><Quantity>400.00000</Quantity><Cost>2.66770</Cost><BillableStatus>Billable</BillableStatus></ItemLineAdd><ItemLineAdd><ItemRef><ListID>800001DA-1199282777</ListID></ItemRef><Desc>PVC PIPE - WSSE200 1"</Desc><Quantity>390.00000</Quantity><Cost>3.55692</Cost><BillableStatus>Billable</BillableStatus></ItemLineAdd><ItemLineAdd><ItemRef><ListID>8000044E-1319483297</ListID></ItemRef><Desc>WIRE: 12/2 x500' LO VOLT</Desc><Quantity>1.00000</Quantity><Cost>147.25999</Cost><BillableStatus>Billable</BillableStatus></ItemLineAdd><ItemLineAdd><ItemRef><ListID>8000025B-1263395448</ListID></ItemRef><Desc>Wire:18/1 x500' Red</Desc><Quantity>4.00000</Quantity><Cost>132.09000</Cost><BillableStatus>Billable</BillableStatus></ItemLineAdd><ItemLineAdd><ItemRef><ListID>8000025C-1263395594</ListID></ItemRef><Desc>wire:18/1 x500' Whit</Desc><Quantity>2.00000</Quantity><Cost>132.09000</Cost><BillableStatus>Billable</BillableStatus></ItemLineAdd><ItemLineAdd><ItemRef><ListID>80000201-1199282779</ListID></ItemRef><Quantity>1.00000</Quantity><Cost>203.64000</Cost><BillableStatus>Billable</BillableStatus></ItemLineAdd></BillAdd></BillAddRq></QBXMLMsgsRq></QBXML>