Customer Balance Revaluation Report,TO PRINT CUSTOMER DATA IN SEPARATE PAGES

TICKET 5: Customer Balance Revaluation Report

What Is:Use this report to identify customers with credit (negative) balances. In many countries you are required to enter a manual journal entry to adjust the general ledger balance for such customers.

What it is:

Use this report to identify customers with credit (negative) balances. In many countries you are required to enter a manual journal entry to adjust the general ledger balance for such customers.

This report provides you with two results:

1)Independent from the accounting entries for your receivables account, this report gives you the balance of your customer and the open items that make up the balance. It takes into account paid deposits and on-account receipts; unpaid deposits are not included.

2)A report listing only customers with a negative balance only, customers with a positive balance, or both kind of customers at once. This is needed in some countries, where you need a separate entry on the balance sheet for customers with a negative balance.

Customization:

TO PRINT CUSTOMER DATA IN SEPARATE PAGES  & ADD A PARAMETER CUSTOMER NAME(SKIP FOR ALL)

Value set :XXCUSTOMERNAME_SAN(from HZ_PARTIES)

Parameters:

Revaluation Period, Include Up to due date, Customer Balance(-ve or +ve)

TABLES:

ra_cust_trx_types , hz_cust_accounts , hz_parties ,hz_cust_acct_sites ,               hz_party_sites ,hz_locations ,hz_cust_site_uses ,ra_customer_trx_all, ar_payment_schedules

QUERY:

  and party.party_name=nvl(:p_party_name,party.party_name)

In Paper Layout Structure We Added a Repeating Frame Print Data Customer Wise. And Added New Parameter Customer_Name

Navigation:

   Got To Layout ,select Field and click on field  click on parent Frame click F4 See Maximum Records Per Page=1