Geography Summary
The QQube Geography Dimension contains billing and shipping address information stored on QuickBooks transactions. It reflects the address recorded on each document rather than the current address maintained on the related customer or vendor record.
Dimension Type QuickBooks document dimension | Geography Represents Billing, shipping, and ship-or-bill address attributes from a transaction |
QuickBooks Source Addresses stored on the QuickBooks transaction | Primary Use Analyze transaction activity by city, state, postal code, or country |
Included Data Models Customers: Sales, Open Sales Orders, Accounts Receivable Operations: Purchases, Accounts Payable, Inventory, Job Cost Details Finance: Cash Position | |
QuickBooks Source
Geography information comes from the billing and shipping addresses saved on the QuickBooks transaction. These fields do not come directly from the current customer or vendor address record.
Source Transactions
Billing and shipping addresses are available on:
- Estimate
- Sales Order
- Invoice
- Credit Memo
- Sales Receipt
- Purchase Order
Billing addresses only are available on:
- Vendor Bill
- Check
- Sales Tax Payment
Source Example
Ship OR Bill address
The Ship OR Bill fields use the shipping address when it exists and substitute the billing address when the shipping address is missing or unavailable.
Transaction-level address
The Geography Dimension reflects the address stored on the transaction. It does not substitute the current address from the associated customer or vendor record.
Available Fields
| Display Order | Field Name |
|---|---|
| 1 | Billing Address 1 |
| 2 | Billing Address 2 |
| 3 | Billing Address 3 |
| 4 | Billing Address 4 |
| 5 | Billing Address 5 |
| 6 | Billing Address City |
| 7 | Billing Address State |
| 8 | Billing Address Postal Code |
| 9 | Billing Address Country |
| 10 | Billing Address Note |
| 11 | Shipping Address 1 |
| 12 | Shipping Address 2 |
| 13 | Shipping Address 3 |
| 14 | Shipping Address 4 |
| 15 | Shipping Address 5 |
| 16 | Shipping Address City |
| 17 | Shipping Address State |
| 18 | Shipping Address Postal Code |
| 19 | Shipping Address Country |
| 20 | Shipping Address Note |
| 21 | Ship OR Bill Address City |
| 22 | Ship OR Bill Address State |
| 23 | Ship OR Bill Address Postal Code |
| 24 | Ship OR Bill Address Country |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article