web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
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

I have the same question (0)
  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    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

  • mmv Profile Picture
    mmv 11,471 on at

    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
    Suresh Kulla Profile Picture
    Suresh Kulla 50,255 Super User 2025 Season 2 on at

    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.

  • themrmystery Profile Picture
    themrmystery 529 on at

    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?

  • themrmystery Profile Picture
    themrmystery 529 on at

    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.

  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    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

    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.

  • Community Member Profile Picture
    Community Member on at

    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!

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans