Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to fix Journal Approval Rule based on total running debit for large amounts using CAST to double

Summary:

We have three journal approval rules.

  1. For identified journal sources in "USD", if amount is same or more than 5000 - Approval Group
  2. For identified journal sources in "USD", if amount is less than 5000- Auto Approve
  3. For journals in "STAT"- Auto Approve

When we are creating a journal of 4 billion, it is getting auto approved instead of going to approval group.

As per Note: Journal Approval Rule Is Not Followed When Amount Is Greater Than 2.1 Billion (Doc ID 2237077.1)

, need help in relation to which additional condition of doublevalue/longvalue is to be added in which rules above.


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!