Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Fill fields by default...

Fill fields by default on OpenPage in G/L Balance By Dimension

(0) Share

Report

Posted on by Community Member Microsoft Employee

I'm trying to add a hiperlink in a menu to the page 408 "G/L Balance By Dimension". When the page popups I'm having trouble to initialize the page with some fields filled by default. I want the GLAccFilter field with the value "112", which is the number for a GL Account I've entered in the NAV system.

I tried in the "OpenPage" trigger do GLAccFilter:='112' but is not working and if I try to do "OnInit" Field.GET(DATABASE::"G/L Account",112); this raises the error "Field does not exist. Table 15, NO 112"

The field "DateFilter" I want to fill with a date range of the last week. How to do that using code?

here I have a image with what i want to be presented by default

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Fill fields by default on OpenPage in G/L Balance By Dimension

Hi,

There must be a function under the GLAccFilter fields OnValidate trigger. After you assign the value on onopenpage trigger, call that function. It should do the trick i believe. You are assigning right now but not validating it and validation should create the view for you.

Create start and end dates with calcdate function, using TODAY and going 1 week before. Assign the created value on datefilter field and validate that field again just like glacc.