Author Topic: Push customer to QB: ZIP information is appended to State  (Read 1137 times)

RedLarry

  • Member
  • *
  • Posts: 2
Push customer to QB: ZIP information is appended to State
« on: March 24, 2013, 03:53:25 PM »
Push customer from FMP to QB is OK.  But, when I goto QB, Edit customer, Edit Address Information, I can see the ZIP will be appended to State field and leave ZIP field empty.  It is OK for QB to process/print invoice.  But, when I query customer back to synchronized records on both systems, the State and ZIP field to field comparison does not match.  How can I push ZIP to ZIP field?  Below is my script.

PCQB_RqAddFieldWithValue( "BillAddress::City";  Customers_SoldTo::CitySold)
PCQB_RqAddFieldWithValue( "BillAddress::State"; Customers_SoldTo::StateSold)
PCQB_RqAddFieldWithValue( "BillAddress::PostalCode"; Customers_SoldTo::ZIPSold)
PCQB_RqAddFieldWithValue( "BillAddress::Country"; Customers_SoldTo::CountrySold)

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Push customer to QB: ZIP information is appended to State
« Reply #1 on: March 25, 2013, 11:51:30 AM »
What values are you seeing returned in your Query Request's Response for State and Zip? What are they in QB? What version of QB, and is it localized for US or another country?

RedLarry

  • Member
  • *
  • Posts: 2
Re: Push customer to QB: ZIP information is appended to State
« Reply #2 on: March 25, 2013, 10:24:25 PM »
I find the issue.  It works fine it is Canada or USA.  ZIP code will be moved to State for some other country.  Thanks.