Method Community

 I am getting the message below in the resolve conflicts log – What I don’t understand is why method is attempting to use the Billing Address 4 field during the sync when it isn’t used on the form (and at other times uses Billing Address 3, working fine). This error doesn’t occur all the time, even when testing with the same customer and address.

QuickBooks returned an error when adding/modifying a accPurchaseOrder record. The error was: There was an error when composing an address in "". QuickBooks error message: There is not enough address lines to compose the address. Please rearrange the individual fields, so that they can fit in the 5-lines block.. The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="8.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><PurchaseOrderModRq requestID="qx_1"><PurchaseOrderMod><TxnID>E15B-1298400629</TxnID><EditSequence>1298400780</EditSequence><VendorRef><ListID>800003E0-1284489403</ListID></VendorRef><ShipToEntityRef><ListID>800003F0-1284753842</ListID></ShipToEntityRef><TemplateRef><ListID>80000012-1282250932</ListID></TemplateRef><TxnDate>2011-02-22</TxnDate><RefNumber>CMP-LASP-68</RefNumber><VendorAddress><Addr1>Xiamen Feeling Garment and Textile Co LTD</Addr1><Addr2>No.14-16</Addr2><Addr4>Xiamen, Fujian,</Addr4><City>Xingmei Road</City><State>Xinglin</State><Country>Xiamen, Fujian, China</Country></VendorAddress><ShipAddress><Addr1>Greenlayer Sports</Addr1><Addr2>Attn: Kim Bilancio</Addr2><Addr3>1723 SW Taylor St.</Addr3><City>Portland</City><State>OR</State><PostalCode>97205</PostalCode></ShipAddress><DueDate>2011-02-22</DueDate><ExpectedDate>2011-02-22</ExpectedDate><VendorMsg>Salesman Samples</VendorMsg><IsToBePrinted>0</IsToBePrinted><IsToBeEmailed>0</IsToBeEmailed><Other1>FEE-RETSAL-111</Other1><PurchaseOrderLineMod><TxnLineID>E15D-1298400629</TxnLineID><ItemRef><ListID>8000070B-1294269309</ListID></ItemRef><Desc>Evolution SS, Men''s Large, White</Desc><Quantity>17.00000</Quantity><Rate>3.51000</Rate><CustomerRef><ListID>800003F0-1284753842</ListID></CustomerRef></PurchaseOrderLineMod><PurchaseOrderLineMod><TxnLineID>E15E-1298400629</TxnLineID><ItemRef><ListID>80000697-1294269292</ListID></ItemRef><Desc>Evolution SS, Men''s Large, Charcoal</Desc><Quantity>17.00000</Quantity><Rate>3.51000</Rate><CustomerRef><ListID>800003F0-1284753842</ListID></CustomerRef></PurchaseOrderLineMod><PurchaseOrderLineMod><TxnLineID>E15F-1298400629</TxnLineID><ItemRef><ListID>8000069D-1294269293</ListID></ItemRef><Desc>Evolution SS, Men''s Large, Chili Pepper</Desc><Quantity>17.00000</Quantity><Rate>3.51000</Rate><CustomerRef><ListID>800003F0-1284753842</ListID></CustomerRef></PurchaseOrderLineMod><PurchaseOrderLineMod><TxnLineID>E160-1298400629</TxnLineID><ItemRef><ListID>80000794-1294269339</ListID></ItemRef><Desc>Evolution LS, Men''s Large, Charcoal</Desc><Quantity>17.00000</Quantity><Rate>4.10000</Rate><CustomerRef><ListID>800003F0-1284753842</ListID></CustomerRef></PurchaseOrderLineMod><PurchaseOrderLineMod><TxnLineID>E161-1298400629</TxnLineID><ItemRef><ListID>80000B59-1298400417</ListID></ItemRef><Desc>Evolution Zip, Men''s Large, Chili Pepper</Desc><Quantity>17.00000</Quantity><Rate>5.75000</Rate><CustomerRef><ListID>800003F0-1284753842</ListID></CustomerRef></PurchaseOrderLineMod><PurchaseOrderLineMod><TxnLineID>E162-1298400629</TxnLineID><ItemRef><ListID>8000

I Would appreciate any help I can get

Tracy

Tracy,

I've seen this kind of thing before, especially with international addresses.  It's actually a problem with QuickBooks / QuickBooks SDK at the root of the problem.  Method just gets caught in the middle, unfortunately.

Here's what happens.....you enter an address correctly in Method or in QuickBooks directly.  QuickBooks then tries to make sense of it, and ultimately tries to figure out an address, city, state, zip and Country from it.  If it's international, it sometimes has a hard job figuring out what's what.  Next, we request that address from QuickBooks, and it delivers it to us with its assumptions.  Finally, using what we got from QuickBooks, we try to send it back with updated information, and it no longer recoginizes the format.

Let me see if I can duplicate this on our end.

1. What was the *original* address format? (I can see the final result, but need to know how it was originally entered)

2. Was it originally entered in Method or in QuickBooks?

3. How does it appear in the customer screen for this customer?

Paul

Paul - 

The original address was created in QuickBooks and the quickbooks vendor window looks like this 

Xiamen Feeling Garment and Textile Co LTD

No.14-16

Xingmei Road, Xinglin,

Xiamen, Fujian, China

I have screenshots of both vendor records (method, QB) if you need them

Tracy,

I tried it out in QB, and was able to duplicate the problem.  As suspected, QB is very confused by the address.

Check out this screenshot, as proof.  This is what you have when you click Edit for the address in QuickBooks:

It doesn't know how to deal with the address at all, and start duplicated parts of the address ("Xiamen, Fujian") and sticking it into address notes.  After a few times of syncing the same record back and forth, QuickBooks and has stuck Xiamen, Fujian in so many places that it breaks.

Now try the same thing with:

Xiamen Feeling Garment and Textile Co LTD
No.14-16, Xingmei Road
Xinglin, Xiamen, Fujian
China

When you click Edit this time, QuickBooks is somewhat happy. 

It would much rather have a US zip code, but at least it knows that China is a country, and doesn't start repeating addresses in different spots.

I tried this with a fresh purchase order and was able to sync back and forth over and over, and the address didn't go haywire.

So, recommendation for the future, if you have an unusual international address, click Edit in QuickBooks and make sure it understands the address.  Otherwise you'll break 3rd party program like Method that are trying to understand what QuickBooks thinks the address is.

Now, onto the issue at hand, this PO. Try changing the address in QB on the PO and syncing again. Hopefully that clears it up. If not, we may have to go in and clean up all the extra address info that is stuck on that record behind the scenes (or if you want to make a copy of the purchase orders screen and show ALL address fields, you can clean it up yourself and save it.  Then you can discard the screen).

Paul