The page "Prod. Order Components" (99000818) in the IT version is very slow on opening, when there is a significant number of records in the "Item Ledger Entry Table".
The problem is related to the field ???Qty. transf. to Subcontractor???
Adding this key we see a significant increase in performance:
tableextension 50000 AltTBILEKey extends "Item Ledger Entry"
{
keys
{
key(TrasfComp; "Entry Type", "Location Code", "Prod. Order No.", "Prod. Order Line No.", "Prod. Order Comp. Line No.","Subcontr. Purch. Order No.")
{ }
}
}
Expected behavior
Faster page loading and line browsing
Steps to reproduce
It is not possibile to replicate in a Cronus database because there a few lines in the Item Ledger Entry table
Additional context
No response
I will provide a fix for a bug
[X] I will provide a fix for a bug
Internal work item: AB#550940
Describe the issue
The page "Prod. Order Components" (99000818) in the IT version is very slow on opening, when there is a significant number of records in the "Item Ledger Entry Table". The problem is related to the field ???Qty. transf. to Subcontractor??? Adding this key we see a significant increase in performance:
tableextension 50000 AltTBILEKey extends "Item Ledger Entry" { keys { key(TrasfComp; "Entry Type", "Location Code", "Prod. Order No.", "Prod. Order Line No.", "Prod. Order Comp. Line No.","Subcontr. Purch. Order No.") { } } }
Expected behavior
Faster page loading and line browsing
Steps to reproduce
It is not possibile to replicate in a Cronus database because there a few lines in the Item Ledger Entry table
Additional context
No response
I will provide a fix for a bug