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
Report Generator - Mail Merge Documents
Viewed 15406 times since Mon, Jun 11, 2012
Pick Lists – Saved Selection Criteria
Viewed 695 times since Thu, Jun 18, 2020
Print Scans to PDF
Viewed 2557 times since Mon, Jun 11, 2012
Ledger Enquiry Hyperlinks on Application Report Output to Excel
Viewed 11141 times since Mon, Jun 11, 2012
Ledger Enquiry – Print Sales / Purchase Account Statement
Viewed 1281 times since Wed, Jun 13, 2012
Allow Four Application Enquiry Screens
Viewed 2213 times since Fri, May 20, 2016
Printing to Tobit Faxware / David
Viewed 9576 times since Wed, Jun 13, 2012
Ledger Enquiry / Display Notes by Department
Viewed 2766 times since Mon, Jun 11, 2012
Ledger Enquiry - Application Panels – Allow Up to Ten Items / Faster Display
Viewed 76 times since Tue, Oct 15, 2024
Document Design Manager - Save and Exit
Viewed 4258 times since Wed, Jun 13, 2012