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:
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.
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.
Use the result of this report to determine the amount you need to manually adjust your general ledger balance to reflect the difference between the original balance and revaluated balance. You would then reverse this entry at the beginning of the following period to resynchronize your receivables with general ledger accounts.
You can run this report for a revaluation period, up to a particular due date, and to include customers with a negative balance, customers with a positive balance, or both.
Attention: Make sure you have entered an End-Of-Period (EOP) rate for each currency used. If any EOP is missing, the report will notify you that the results calculated may be wrong.
Use either the Submit Request or the Print Accounting Reports window to submit this report.
Revaluation Period: Select the period for which you want to revaluate.
Include Up To Due Date: If you want to differentiate short-term, midterm, and long-term Receivables activities, you can enter a date; otherwise, you should leave this field empty.
Customer Balance: Select from the following values:
Show Positive Balance: List only customers with a positive balance.
Show Negative Balance: List only customers with a negative balance.
Show Positive and Negative Balance: List all customers, regardless of their current balance. This is the default.
Customer Balance: The total balance due for this customer.
Customer Name/Number: The customer name, customer number, and customer site that have open items.
Transaction Number: The number of the transaction.
Transaction Type: The name of the transaction type.
Transaction Date: The date of the transaction.
Due Date: The due date of the transaction.
Currency: The currency used to enter the transaction.
Open Original Amount: The balance of the transaction in its original currency.
Exchange Rate: The exchange rate for foreign currency transactions. This value is 1 for functional currency transactions.
Open Functional Amount: The balance of the transaction valuated at the exchange rate used when the transaction was approved.
EOP Rate: The End-Of-Period rate, which the report uses to revaluate the balance of the transaction.
EOP Open Amount: The balance of the transaction, revaluated using the EOP rate.
Open Revaluated Amount: Receivables uses the lower of the Open Functional Amount and the EOP Open Amount to determine the market value of the open item.
Credit/Debit: The sum of the positive open items (Debit) and the sum of the negative open items (Credit). These figures help you determine the amount of the adjustments to your general ledger balances.