When a customer has multiple Ship to Addresses, QODBC can only display only one Ship to Address which is set as the “Default” in QuickBooks.
How to Get Specified ShipToAddress in QODBC
What is it?
The QODBC Connector is a distributable utility that connects calls from your InterWeave Smart Solution to your QuickBooks Company file (the database).
How fast may I expect the Integration to be completed?
The integration timeline is at the customers speed — it is directly regulated by:
1. the quality and amount of your data, duplicates, special characters, loading historical data, etc., and the number of flows you have selected.
2. As we have over 100 flows and 300 configurable options to choose from, we recommend a phased approach so you may manage expectations.
NOTE: Turn off Scheduled flows before starting Utility flows!!!
UTILITY FLOW DEFINITION
There are 2 types of Utility flows:
1. Bulk Load flows (with DR or DRS at the end of the flow name) DR = Date Range or DRS = Date Range & Size (Check radio button “Scheduled”)- for Bulk Load by period (Date Range) and batch size (S).
2. Single transaction flows (with N or NF at the end of the flow name) N = Name/Number (Check radio button “Single Run”) – for one time particular transaction sync or testing (Account/Opportunity/Product/Quote… etc.)
The Salesforce accounts that are not bound will not be able to connect with their QB Customer counterpart, so a QODBC error message will be produced and sent to the SF User identified in their InterWeave Solution. In addition, when invoices are run for this SF Account, additional error messages will be produced (there is no customer).
When we run a binding, binding flow takes the Salesforce Account Record ID and places this in the custom field “AccountID” that you created in your QuickBooks Customer Object. Same field can be activated for Vendor object as well. When you exposed that field (click on the Column title bar with the alt right button, then select “Customize Columns”) and drag and drop this from Available to Chosen. This column will now show which Customers have been bound and if blank, Customers which are not bound.
These settings would pick up Items from 01/01/2021 to 05/31/2021 (Put in next day to make sure we cover all of today).
The DR/DRS utility is used when you need to run a batch of a specific object. DR utilities are single run utilities that used for a small date intervals (couple of days top). DRS utilities are used to bulk load any amount of records. Parameters for both types are: