BI Publisher (MOSC)

MOSC Banner

AP Checks - Group By Amount (<5000 and >=5000, then sort Alpha on RTF

edited Apr 1, 2013 9:31AM in BI Publisher (MOSC) 11 commentsAnswered ✓
Within our company, all checks $5000 and over must be hand-signed; any under this are 'auto-signed'.When a check batch is printed, we would like all checks that are $5000 and over to print first, in alpha order - then those under $5000 in alpha order.
I'm using an RTF template to do this.

Using format_payments_evergreen - (APXPBFEG) - elements that matter listed below
<LIST_G_CHECKS>
   <G_CHECKS>
       <C_CHECK_AMOUNT>5001 </C_CHECK_AMOUNT>
       <C_VENDOR_NAME>SAMPLE COMPANY </C_VENDOR_NAME>
   </G_CHECKS>
   <G_CHECKS>
       <C_CHECK_AMOUNT>400 </C_CHECK_AMOUNT>
       <C_VENDOR_NAME>COMPANY B</C_VENDOR_NAME>

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