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
Ledger Enquiry - New Interface
Viewed 2641 times since Wed, Jun 13, 2012
Customer / Product History Enquiry
Viewed 3395 times since Tue, Jun 12, 2012
Screen Design - Allow 64 Data Items per Screen Layout
Viewed 1499 times since Mon, Jun 11, 2012
Ledger Enquiry – New Label Print Option
Viewed 685 times since Wed, Jun 13, 2012
F8-Zoom - Allow Other Searches and Enquiries
Viewed 3056 times since Fri, Jun 8, 2012
Spooled Reports - Clear Selected Spool Files
Viewed 2663 times since Mon, Jun 11, 2012
Print Scans to PDF
Viewed 923 times since Mon, Jun 11, 2012
Landing Grids
Viewed 406 times since Mon, Jun 26, 2017
Pick Lists – All Records Button
Viewed 1820 times since Wed, Jun 13, 2012
Ledger Enquiry – New Notes Option
Viewed 403 times since Wed, Jun 13, 2012