The Customer masterfile is flagged to indicate whether an account is an Open Item account (Y) or Balance Forward account (N). The system still stores the transactions as Open item (each transaction is stored separately). The Cash Entry screen displays as Open item and the Unallocate function will change the display to age by balance.
The cash and journals are allocated to one or more of the account balances. The same process can be used to enter unallocated cash to accounts defined as open item accounts.
The customer statement will also print in a Balance Forward format.
- In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > Entry and then double-click Debtor Cash/Journal Entry. ARE005 Cash Entry payment selection panel appears.
- On the Payment function field, select CSH from the drop down list and click OK.
- On the next panel enter the customer with balance forward account, the amount and reference details and click OK. ARE005 Cash Entry detail panel appears.
- Click Unalloc.
- Flag the aged balance for payment and click OK.