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 - Alternate Link Item for History Databases
Viewed 170 times since Tue, Oct 15, 2024
Document Design Manager - Inserting New Items
Viewed 2465 times since Wed, Jun 13, 2012
Ledger Enquiry – Improved Scans Option
Viewed 1112 times since Wed, Jun 13, 2012
Emails in HTML Format (Outlook 2007)
Viewed 4391 times since Mon, Jun 11, 2012
Extra 160 Items per Database
Viewed 1874 times since Wed, Jun 13, 2012
Additional Filter Option on Stock Transaction Enquiry
Viewed 1950 times since Tue, Jun 12, 2012
General System Options - Email Address Format Validation
Viewed 156 times since Thu, Oct 17, 2024
Document Design Manager - Page Set-up
Viewed 4647 times since Wed, Jun 13, 2012
Landing Pages – Data Item Aliases
Viewed 43 times since Wed, Oct 23, 2024