Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Boolean Show as Check ...
Microsoft Dynamics NAV (Archived)

Boolean Show as Check Box on Page/Line

(0) ShareShare
ReportReport
Posted on by themrmystery 529

Hey,

We're an end-user of NAV and we make some very minor changes in Object Designer.

A recent change, is we have added a Boolean Field on Sales Header for Pending Credit Card transactions. Our sales team can check this box, and then run credit card transaction, or wait for credit card authorizations.. etc...

We have then made this Boolean Field appear on corresponding Source Document searches for Warehouse Shipments.

The question is, when you "Get Source Documents" for a Warehouse Shipment, Page 5793, we have added the Boolean, but it appears as "Yes" or "No" text in the source documents line items. Is there anyway to have a page display these as checkmarks, similar to Boolean's on the Item List?

Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Boolean Show as Check Box on Page/Line

    We would like to make a similar change on the Sales Order list page.  There is a Boolean flowfield on the Sales Header titled "Package Exists"  We would like to see it as a checkbox on the Sales Orders List page.  I added it to the Sales Orders List page using the three dots on the left side of the new row pulling from the Sales Header record, but it shows up as Yes/No.  Where do I change it from a flow field to a table relation - on the Sales Order List? If so, I tried removing it as a source expression and changing it a table relation, but it failed showing "Package Exists" on all rows of the Sales Order list. 

    We upgraded to 2015 two weeks ago so still figuring my way around the limited developer environment.

    Thank you!

  • themrmystery Profile Picture
    themrmystery 529 on at
    RE: Boolean Show as Check Box on Page/Line

    Jonathan,

    Thanks for the additional info, unfortunately as the end user, we don't have permission to enter the C/AL Code of Pages, only Reports. It did work using Table Relation however, and removing the flow field and FORMAT.

    Thanks again.

  • Verified answer
    keoma Profile Picture
    keoma 32,717 on at
    RE: Boolean Show as Check Box on Page/Line

    i repeated your settings. i think, because the value is a linked/readonly value it's shown as yes/no and not as checkbox. so remove the flowfield setting and add following code to onaftergetrecord trigger in page 5793:

    if "source document" = "source document"::"sales order" then begin

     SalesHeader.get(SalesHeader."document type"::order,"source no.");

     WR_BoolField := SalesHeader.BoolField;

    end;

    with SalesHeader as local var. of type rec|sales header.

    p.s.: also a good idea from you to use a table relation.

  • themrmystery Profile Picture
    themrmystery 529 on at
    RE: Boolean Show as Check Box on Page/Line

    Using both your words of wisdom, I removed the FlowField, just made it a table relation link, and removed the FORMAT(boolfield) and it's a regular checkbox. Thanks everyone.

  • themrmystery Profile Picture
    themrmystery 529 on at
    RE: Boolean Show as Check Box on Page/Line

    Hrmm,

    Jonathan, I ran across this in my setting this up, and have the SourceExpr setup as only the BoolField, it still displayed as Yes / No, so I changed it to FORMAT(BoolField), which yielded the same result.

    In looking at Suresh's answer, I may have setup my table links wrong, or in the incorrect way, it works, but might not be the best practices.

    What I did was make a new BoolField on Sales Header, then using a FlowField Lookup expr, I pull that information into the Source Documents table, so I can easily display that information on Get Source Documents Page for shipping.

    Was I incorrect in using a flowfield lookup expr?

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 45,542 on at
    RE: Boolean Show as Check Box on Page/Line

    Check if the field on the corresponding tables is normal field or flowfield. If it is flowfield then it will display as Yes or No, i am not sure if there is a way to change that.

  • mmv Profile Picture
    mmv 11,467 on at
    RE: Boolean Show as Check Box on Page/Line

    Hi,

    As mentioned by Jonathan, the FORMAT(booleanfield) is what causing the value to be displayed as Yes or No.  You may very well change the FORMAT expression and simply display the value as it's.

  • Verified answer
    keoma Profile Picture
    keoma 32,717 on at
    RE: Boolean Show as Check Box on Page/Line

    this only occurs, if the sourceexpr of the field is written as FORMAT(BoolField). if you use BoolField as SourceExpr value instead, then checkboxes are shown in the page (it's the default behavior). also check properties autoformattype and autoformatexpr. follow https://msdn.microsoft.com/en-us/library/dd338607(v=nav.70).aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,233 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans