InterWeave Academy

DR Utilities – Date Range Utilities from QuickBooks to Salesforce

These settings would pick up Items from 01/01/2024 to 05/31/2024 (Put in next day to make sure we cover all 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) – must 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/2024 to 5/31/2024 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/2024 to 05/31/2024 (Put in next day to make sure we cover all today). 

Scroll to Top