Hi experts,
In Business Central cloud, I would like the sales order to work this way: When entering a line, it automatically makes a new line below with another item number. That works fine.
When the user change the Quantity field in the first line, it is also automatically updates the other line, it created automatically before. The two lines must have the same value in Quantity.
The problem is that when the Quantity field is changed in the first line, the second line is changed, BUT it is not visible on the screen. And after that, the second line is locked somehow so it is not possible to change it. The cursor cannot get into the fields in that line.
I have all my code in a table extension for Sales Line in the trigger OnAfterModify. Here is the code:
trigger OnAfterModify()
begin
if ... then begin
CreateDepositLines(Rec);
end;
end;
local procedure CreateDepositLines(SalesLine : Record "Sales Line")
var
Item: Record Item;
DepositType: Record "Deposit Type";
DepositSalesLine: Record "Sales Line";
begin
Item.GET("No.");
DepositSalesLine.Init();
DepositSalesLine.Validate("Document Type", SalesLine."Document Type");
DepositSalesLine.Validate("Document No.", SalesLine."Document No.");
DepositSalesLine.Validate("Sell-to Customer No.", SalesLine."Sell-to Customer No.");
DepositSalesLine.Validate(Type, DepositSalesLine.Type::Item);
DepositSalesLine.Validate("No.",DepositType."Item No.");
DepositSalesLine.Validate("Line No.",SalesLine."Line No." + 1000);
DepositSalesLine.Validate(Description, 'Well...');
DepositSalesLine.Validate(Quantity, SalesLine.Quantity);
DepositSalesLine.Validate("Location Code", '');
DepositSalesLine.Insert(true);
Commit();
end;
