Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Update Saved Aged Analysis on Payment Entry (S/L only)

Datafile Software

Update Saved Aged Analysis on Payment Entry (S/L only)

Discussed earlier in conjunction with the Credit Control Manager, the option to update the saved aged analysis values on payment entry can be used even when not using the Credit Control feature.

The Sales Ledger allows the option to calculate the aged analysis of the outstanding transactions for an account – showing the amount overdue by 30, 60, 90 days, etc. These values are available for enquiry, via the Ledger Enquiry, or on a report, the Aged Debtors report, but are not recorded on the database.

An existing feature allows you to run a routine (say) once a day to record the aged analysis values against the account record. These details then become available for use in reports or Word documents, and for use in selection criteria.

Up to now these values have only been updated when running the Save Aged Analysis routine – a process which requires exclusive locks on the accounts and transaction files and relies on operators to keep it up to date. In a fast moving business, generation of new invoices are unlikely to have an impact on your debtor chasing processes but the failure to update these details for a payment may result in you chasing a customer for money they have already paid – sometimes not a good customer relations move!

This new feature allows, on entry of the payment and allocation via either the Sales Ledger or Cashbook, to update the saved aged analysis details on an account based on the current outstanding transactions. You will still need to run the ‘Save’ process – as invoice, credit generation will not update these details – but the timing on the rebuild of these values is no longer as critical due to credit terms.

Installation

The Sales ledger System Profiles has a new prompt on Screen 1 to update the saved aged analysis.

Update saved aged analysis on receipts – set to update the saved aged analysis data items on entry of a payment transaction (in Sales Ledger) or a receipt transaction (in Cashbook).

Custom Fields
  • Release ID: 5.7
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Manually Generate Payments - Purchase Ledger
Viewed 2051 times since Mon, Jul 2, 2012
Transfer Outstanding Invoices
Viewed 1840 times since Mon, Jul 2, 2012
Set Account Group on Stop
Viewed 13448 times since Fri, Oct 26, 2012
Auto-Increment Account Codes
Viewed 2362 times since Wed, Jun 13, 2012
Trans Mandatory - Database Profiles
Viewed 2260 times since Mon, Jul 2, 2012
Provide for Bad Debts - Sales Ledger
Viewed 1981 times since Mon, Jul 2, 2012
Trans Currency - Database Profiles
Viewed 1915 times since Mon, Jul 2, 2012
Turnover History Report
Viewed 3555 times since Mon, Jun 11, 2012
Transaction / Detail Enquiries
Viewed 13571 times since Mon, Jul 2, 2012
Nominal Analysis Report – Totals Only
Viewed 1204 times since Wed, Jun 13, 2012