Modify "Posting Date" with INPUT dialog Date

lavanyaballurgi

Hello guys,

I know the subject is not enough to make you understand. Well here it is -

THE SITUATION - in Reversal Entry table (while reversing an entry) the REPLACE ALL function for POSTING DATE is disabled.

THE SOLUTION - I thought of making a Menu Item which will pop up a INPUT dialog box where I can ask the user to provide the new POSTING DATE so that I can replace all entries in REVERSAL ENTRY table with that new POSTING DATE.

THE C/AL CODE -
Window.OPEN('Enter Text ##############1##',gdt_Date);
Window.INPUT(1,gdt_Date);
Window.CLOSE;
grc_ReversalEntry.SETRANGE("Document No.","Document No.");
IF grc_ReversalEntry.FINDFIRST THEN REPEAT
grc_ReversalEntry."Posting Date" := gdt_Date;
grc_ReversalEntry.MODIFY
UNTIL grc_ReversalEntry.NEXT = 0;

THE ERROR - "The Reversal Entry Table is Empty"

ANy help?

mohana_cse06

Check whether any filter is applied on grc_ReversalEntry variable..
reset it before filtering.

I guess you are getting error message from some where else.

please activate the debugger and check..

lavanyaballurgi

Reset also didnt worked. The problem is that there is no data in REVERSAL ENTRY table even when I can see data in FORM 179 (reverse entries).
Is this default?

mohana_cse06

Did you try below code?

Window.OPEN('Enter Text ##############1##',gdt_Date);
Window.INPUT(1,gdt_Date);
Window.CLOSE;
MODIFYALL("Posting Date",gdt_Date);

lavanyaballurgi

wow... that work.. thanks alot

lavanyaballurgi

MODIFYALL did the trick ... hmmm need to keep it in mind