Customer Balance Credit Memo Report


Customer Balance Credit Memo Report

Share this:

Price: $69.99

 

Product Description

This report displays total customer credit memo balance as of date for given customer number

 

What happens now?

Once you've decided on the report or view you'd like to buy, simply add it to your basket and proceed through the checkout. You will visit 2checkout.com who are our payment processor, and on successful payment you will return to our site and the code will be unlocked for you to use. There will be a direct link in the order confirmation screen, or you can view the code at any time in the future through your Account screen.

What am I buying?

There are a total of 31 lines of code in this product. Here is an example:
11.   WHERE TRUNC (ps.gl_date) <= :p_as_of_date
12.   AND cust_acct.account_number = :p_account_number
13.   AND ps.customer_id = cust_acct.cust_account_id
14.   AND ps.cust_trx_type_id = rtt.cust_trx_type_id
15.   AND ps.trx_date <= :p_as_of_date
16.   AND ps.CLASS = 'CM'

Report Fields

CUSTOMER_CM_BALANCE_AMOUNT