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
SMB2, SMB3 and Opportunistic Locking
Viewed 26394 times since Tue, Apr 8, 2014
Customer / Product History Enquiry
Viewed 5055 times since Tue, Jun 12, 2012
F4 Search - Default Search Method
Viewed 2151 times since Fri, Jun 8, 2012
Scanned Documents - Save As PDF
Viewed 3109 times since Mon, Jun 11, 2012
Emails in HTML Format (Outlook 2007) 2
Viewed 1023 times since Thu, Sep 4, 2014
Record Groups as Items in Discount and Supplier Matrix
Viewed 3420 times since Fri, May 27, 2016
Document Design Manager - E-Mail Settings
Viewed 2600 times since Wed, Jun 13, 2012
Printing to Tobit Faxware / David
Viewed 9559 times since Wed, Jun 13, 2012
Ledger Enquiry - Additional CRM Categories
Viewed 5341 times since Fri, Jun 8, 2012
Automatically Display Linked Files - Allow Items from Lookup Database in History/Details List - Link to BOM Detail Pick List
Viewed 2579 times since Fri, Jul 21, 2017