Home » Categories » Solutions by Business Process » System Features

Ledger Enquiries - Performance Tuning

 

Ledger Enquires – Performance Tuning

 

 

Over time as transaction sizes grow within the Datafile system, displaying transaction lists in LIFO sequence may take longer.

 

 

Some common ways to improve performance are as follows:

 

 

Ledger Enquiry

 

 

Function

 

 

Recommended Action

 

 

Sales Account

 

 

Transactions

 

 

Create a Secondary Index on the "ACCOUNT” field in the Sales Ledger Transactions (SLT) table.

 

 

Invoices

 

 

Set the Database Profiles to store the last Invoice document number in the Sales Ledger Account Table (SLA) and then re-index the Invoice file.

 

 

Sales Orders

 

 

Create a Secondary Index on the "ACCOUNT” field in the Sales Order Header (SOH) table.

 

 

Purchase Account

 

 

Transactions

 

 

Create a Secondary Index on the "ACCOUNT” field in the Purchase Ledger Transactions (PLT) table.

 

 

Invoices

 

 

Set the Database Profiles to store the last Invoice document number in the Purchase Ledger Account Table (PLA) and then re-index the Invoice file.

 

 

Purchase Orders

 

 

Create a Secondary Index on the "ACCOUNT” field in the Purchase Order Header (POH) table

 

 

Stock Record

 

 

Transactions

 

 

Create a Secondary Index on the "Stock-Code” field in the Stock Transactions (STT) table.

 

 

Sales Orders

 

 

Create a Secondary Index on the "Stock” field in the Sales Order Details (SOD) table.

 

 

Purchase Orders

 

 

Create a Secondary Index on the "Stock” field in the Purchase Order Details (POD) table.

 

 

Works Orders

 

 

Create a Secondary Index on the "Stock” field in the Works Order Header (WOH) table.

 

 

Job Record

 

 

Costs

 

 

Create a Secondary Index on the "JOB-CODE” field in the Job Costing Transactions (JCT) table.

 

 

Purchase Orders

 

 

Create a Secondary Index on the "JOB-CODE” field in the Purchase Order Detail (POD) table.

 

 

Sales Orders

 

 

Create a Secondary Index on the "JOB-CODE” field in the Sales Order Detail (SOD) table.

 

 

Sales Order

 

 

Details

 

 

Create a Secondary Index on the "ORDER-REF” field in the Sales Order Detail (SOD) table.

 

 

Purchase Order

 

 

Details

 

 

Create a Secondary Index on the "ORDER-REF” field in the Purchase Order Detail (POD) table.

 

 

Works Order

 

 

Details

 

 

Create a Secondary Index on the "ORDER-REF” field in the Works Order Detail (WOD) table.

 

 

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Document Design Manager - Print Preview and Test Print
Viewed 2478 times since Wed, Jun 13, 2012
Datafile Software - File Naming Conventions
Viewed 5113 times since Thu, Jul 26, 2012
Stock Enquiry - History / Detail Database Options
Viewed 9953 times since Mon, Nov 25, 2013
F8-Zoom - Allow Other Searches and Enquiries
Viewed 4106 times since Fri, Jun 8, 2012
Validate Account and Stock Groups Entries
Viewed 1922 times since Fri, May 27, 2016
Increase History List to Ten Items
Viewed 1996 times since Tue, Jun 12, 2012
Print Scans to PDF
Viewed 1962 times since Mon, Jun 11, 2012
Select Enquiry
Viewed 2015 times since Tue, Jun 12, 2012
Database Activity Alerts
Viewed 2515 times since Tue, Jun 12, 2012