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
Alternate Panels in Ledger Enquiry
Viewed 2081 times since Tue, Jun 12, 2012
Output to Pivot Tables - Accept and Save Options
Viewed 4700 times since Tue, Jun 12, 2012
Password Security
Viewed 1024 times since Thu, Jun 18, 2020
User-Definable Ledger Enquiry Applications Extended
Viewed 1006 times since Wed, Jun 17, 2020
General System Options - Hide Post/Collect Messages Options
Viewed 152 times since Thu, Oct 17, 2024
General System Options - My Reports
Viewed 180 times since Thu, Oct 17, 2024
Extra Secondary Indexes
Viewed 1591 times since Wed, Sep 21, 2016
Windows 10 1803 Update / Windows Defender
Viewed 2647 times since Wed, May 30, 2018
Document Design Manager - Setting and Applying Font Defaults
Viewed 2316 times since Wed, Jun 13, 2012
SMB2, SMB3 and Opportunistic Locking
Viewed 24782 times since Tue, Apr 8, 2014