DR Utilities - Date Range Utilities from QuickBooks to Salesforce

Created by Bruce F Magown, Modified on Tue, 5 May, 2020 at 10:23 AM by Bruce F Magown

These settings would pick up Items from 01/01/2020 to 05/31/2020 (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:

StartDate or StartDateTime – beginning of the interval (exclusive)

EndDate or EndDateTime – end of the interval (inclusive)

Return String (optional) – has to be ignored

Besides, DRS flows have additional parameter

BatchSize – number of records for one batch load

Recommended Batch Sizes may vary from 4 to 50 depending on record size.

Also DRS flows must start with a value 0 in a Counter Column

For example to load invoices from 1/1/2011 to 5/31/2011 you can use QBInvoices2SFAcctOppDRS with

  • Batch Size 8
  • Start Date format of 2020-01-01 00:00:00
  • End Date format of 2020-05-31 00:00:00


These settings would pick up Items from 01/01/2020 to 05/31/2020 (Put in next day to make sure we cover all of today).

Title

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article