Update Line from Header automatically?

Tiwaz · 2016-09-20

Hi guys.

I have a table Header (prim.key=No.) and Line (prim.key=Line No., Header No.) where Header No. is No. from header table because Header Card is connected to Lines listpart using this field.

In my Line table, in OnInsert() i have the code which makes sure i get the date from Header on Line:
IF Header.GET("Header No.") THEN
Date := Header.Date;

It works fine when i first enter the Date in Header and insert something on Line.
But when I wish to change the date on Header it doesn't get changed on Line.
What should I do?

I want, when i change the Date on Header Card, for Nav to check if there are existing lines for that header, and if there are, to ask if I want to change the date. If I confirm, date gets changed on Line. If not, it doesn't.

I really appreciate your help

Thanks

edoderoo · 2016-09-20

You should add this code in the header:
in the section: Order Date - OnValidate()

as this code does not exist yet, you have to write it yourself.

Kishorm · 2016-09-20

Have a look at how this is done in standard NAV - e.g. "Shipment Date" on Sales Header & Sales Line works in a similar way.

edoderoo · 2016-09-21

The code in the header should ask the user if he/she wants to update all lines, if yes, with a salesline.SETFILTER you need to filter out the lines for this order only, and loop through these lines and update the orderdate with the VALIDATE command with the new order date.
As Kishorm said, you can find a clear example on the field Shipment Date.

edoderoo · 2016-09-20

You should add this code in the header:
in the section: Order Date - OnValidate()

as this code does not exist yet, you have to write it yourself.

Kishorm · 2016-09-20

Have a look at how this is done in standard NAV - e.g. "Shipment Date" on Sales Header & Sales Line works in a similar way.

Tiwaz · 2016-09-21

@edoderoo Are you saying that I should use the code from Order date in Sales Header in my Header?

I have done this and created function needed but it only displays message without actually changing the date on my Line

edoderoo · 2016-09-21

The code in the header should ask the user if he/she wants to update all lines, if yes, with a salesline.SETFILTER you need to filter out the lines for this order only, and loop through these lines and update the orderdate with the VALIDATE command with the new order date.
As Kishorm said, you can find a clear example on the field Shipment Date.

Tiwaz · 2016-09-29

This code on Header solved my problem
OnInsert()
...
...

Posting Date - OnValidate()
UpdateLines(FIELDCAPTION("Posting Date"),CurrFieldNo <> 0);
...
...

LOCAL LinesExist() : Boolean
Line.RESET;
Line.SETRANGE("Header No.","No.");
EXIT(Line.FINDFIRST);

LOCAL UpdateLines(ChangedName : Text[250];AskQuestion : Boolean)
IF NOT LinesExist THEN
EXIT;

IF AskQuestion THEN
Question := STRSUBSTNO(Txt1,ChangedName);
IF GUIALLOWED THEN
IF DIALOG.CONFIRM(Question,TRUE) THEN BEGIN
END
ELSE
EXIT;

Line.LOCKTABLE;
MODIFY;

Line.RESET;
Line.SETRANGE("Header No.","No.");
IF Line.FINDSET THEN BEGIN
REPEAT
CASE ChangedName OF
FIELDCAPTION("Posting Date"):
IF Line."Header No." <> '' THEN BEGIN
Line.VALIDATE("Price Date","Posting Date");
Line.MODIFY;
END;
END;

UNTIL Line.NEXT = 0;
END;

Howdy, Stranger!

Quick Links

Categories

Update Line from Header automatically?

Best Answers

Answers