Adjustment details in Generate Revenue Update Batch are not carried over to Batch for 'Posted (activity pending)' status transactions

When attempting to create a Revenue update batch for GL Posted transactions that have been adjusted and are showing with a status of 'Posted (Pending Activity)', the Adjustment details do not carry over from the Generate Revenue Update Batch process to the Uncommitted Revenue Update Batch.

Adjustment Details not updated in Batch:
  •     Adjustment date: Current date
  •     Adjustment post date: Current date
  •     Adjustment reason: (Reason code used above)
  •     Adjustment details: (Reason description that you entered above)
  •     Adjustment post status: Not posted
The process, in order, is recommended to update revenue, which does process/save the Adjustment details correctly:
  1. Edit the Revenue directly in the Revenue Update Batch and/or through the Generate Revenue Update Batch process initially (while still in a status of Posted)
  2. If the status is Posted (Activity Pending), the Revenue will need to be Posted again through the Post to GL Process before further updates/edits can be made

 

Steps to Duplicate

  1. In CRM, create add a Payment to a Constituent Record
  2. Go to Revenue > Post Revenue to GL
  3. Post the recent payment
  4. Go back to the Payment and click Edit posted payment
  5. Adjust payment as follows:
    1. Adjustment date: Current date
    2. Adjustment post date: Current date
    3. Adjustment reason: (Any available reason code)
    4. Adjustment details: (Enter a reason description as appropriate)
    5. Adjustment post status: Not posted
  6. Click Save
  7. Note that the Post Status is now shows as follows: Posted (activity pending)
  8. Go to Revenue, click Generate revenue update batch
  9. Add a new process that is using a Revene Update Batch template and create a Revenue Selectio to locate the adjusted Payment create/edited above
  10. Update process with the following setup:
    1. Filter selection and overwrite with new value: Check
    2. Filter by: Date
    3. Current value: Current date
    4. Overwrite with: Current date + 1 year
    5. Include posted transactions: Check
    6. Adjustment date: Current date + 1 year
    7. Adjustment post date: Current date+ 1 year
    8. Adjustment reason: Reason - 2
    9. Adjustment details: Reason detail 2
    10. Adjustment post status: Do not post
  11. Click Save
  12. Click Start Process
  13. Note that the Process Completes successfully
  14. Go to Revenue > Batch Entry
  15. Locate the Revenue Update Batch that was created from the process above and edit it
  16. Notice adjustment field values are not updated as per the setup in GRUB process above:
    1. Adjustment date: Current date
    2. Adjustment post date: Current date
    3. Adjustment reason: (Reason code used above)
    4. Adjustment details: (Reason description that you entered above)
    5. Adjustment post status: Not posted

Environment

 Blackbaud CRM
 4.0

Was this article helpful?