A zero receipt amount default or import file value is ignored in Enhanced Revenue Batch

Receipt amount default or import file value ignored in Enhanced Revenue Batch.  The value for the receipt amount field if imported as a zero value defaults to the revenue amount.   
  1. Open your import file and add a column with the header "User modified receipt amount", and enter the value of "TRUE" in each row.
  2. Navigate to Administration and select Import.
  3. In the list of imports, find the import process you are working with.
  4. Click the drop-down and select Edit.
  5. On the Map fields tab, map the Batch template column "User modified receipt amount" to the Import file column "User modified receipt amount".
  6. Save the import process.
  7. Click Start process to reprocess the import. This time the Receipt amount should import with the value defined in the import file.  

Steps to Duplicate

1.    Create a new batch ERB template and set the default value for receipt amount to 0.00
2.    Create a new import process using the template created in step 1
3.    Create an import file with the amount value populated and the receipt amount set to 0 or blank
4.    Import the file created in step 3
5.    Review the batch and note that the receipt amount value is automatically updated to the revenue amount


 Blackbaud CRM

Was this article helpful?