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
Trans Sub Contract (Purchase Ledger) - Database Profiles
Viewed 2035 times since Mon, Jul 2, 2012
Account Currency Turnover - Database Profiles
Viewed 2543 times since Mon, Jul 2, 2012
Year End Reporting
Viewed 1997 times since Wed, Jun 13, 2012
Ledger Control Summary
Viewed 1961 times since Mon, Jul 2, 2012
System Profiles Screen 4 (excluding Compact)
Viewed 1869 times since Mon, Jul 2, 2012
Cost Price Checks - Omit Warning if No Change in Selling Price (SOP Only)
Viewed 176 times since Thu, Jan 2, 2025
Scan / Input Bar Code for Stock Code
Viewed 234 times since Thu, Jan 2, 2025
Currency Aged Analysis in Auto Period End Reports
Viewed 18592 times since Tue, Oct 12, 2021
Include Currency Accounts in Auto-Payment Procedures
Viewed 1801 times since Fri, May 27, 2016
Lookup during Invoice Entry (P/L only)
Viewed 1903 times since Wed, Jun 13, 2012