Financial - JDE1 (MOSC)

MOSC Banner

Search QBE by absolute value?

edited Mar 5, 2014 4:45PM in Financial - JDE1 (MOSC) 2 commentsAnswered ✓


One of the users I support asked if there is a way to search by absolute value in a numeric field in the QBE line.  Here are two examples of when he would like to do this:

 

1) In searching the Item Ledger, he is often looking for quantities that have gone in and out. For example, he may want to see all instances of 4,000 grams being received and issued out. Hence, he would like to see all +4000 & -4000 transactions.

2) Also, in searching the account ledger, the same idea applies with dollars. Instead of querying on just debits to the account for a value, or just credits to the account for that value, it would be beneficial to see both the debits and the credits at the same time.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center