QuickBooks Desktop allows you to save and select different shipping addresses for each customer when creating a transaction.
Unfortunately, this is not implemented in our stock apps at the moment. So although the shipping address data syncs to and from QuickBooks, it will not appear nor be reflected in transactions.
If you wish to add this functionality to your transaction apps via customization, here are the basics to give you the foundation to create this on your own.
First, here are a few restrictions to keep in mind when customizing your app to support multiple shipping addresses.
- Shipping addresses cannot be renamed in Method: Each individual shipping address has an associated name. This cannot be edited within Method and can only be done through QuickBooks. All other fields, however, are supported for edits in Method.
- Shipping addresses cannot be deleted in Method: Once created, you cannot delete a shipping address in Method. You can, however, delete it in QuickBooks.
- Shipping addresses are not available for jobs/subcustomers: Jobs/subcustomers will not have multiple shipping addresses. The list of addresses for a job/subcustomer must be retrieved from their parent instead.
The Shipping Address Table
There is a new table called “ShippingAddress” which holds the data for the new shipping addresses for each customer and syncs with QuickBooks Desktop.
This table contains the following fields:
- Customer - Dropdown field connecting to the Entity table, FullName field.
- DefaultShipTo - Yes/No: This indicates the shipping address as the default shipping address. QuickBooks will also automatically store this shipping address within the Customer Table.
- Name - Text (41): For each customer, this must be a unique name to describe the shipping address. Two customers can have a shipping address called “Home”, but one customer cannot have two shipping addresses called “Home”.
- ShipAddressAddr1 - Text (41)
- ShipAddressAddr2 - Text (41)
- ShipAddressAddr3 - Text (41)
- ShipAddressAddr4 - Text (41)
- ShipAddressAddr5 - Text (41)
- ShipAddressCity - Text (31)
- ShipAddressCountry - Text (31)
- ShipAddressNote - Text (41)
- ShipAddressPostalCode - Text (13)
- ShipAddressState - Text (21)
Using Multiple Shipping Addresses
At the very minimum, you will need to create a dropdown on each transaction screen where you want the option to select a different shipping address. When selected, you can copy the appropriate fields from the shippingaddress table into the transaction’s shipping address fields.
If you want them to create or edit shipping addresses within Method, you can create the appropriate screens to do so, however, remember the restrictions as covered earlier.