Open Forum

Expand all | Collapse all

Choose Columns - Missing Field (column) From Available Columns

  • 1.  Choose Columns - Missing Field (column) From Available Columns

    SILVER CONTRIBUTOR
    Posted Oct 08, 2019 07:45 PM
    I am relatively new to NAV so bear with me. Using NAV 2016. Viewing Sales Orders. Want to see Ship-to-State. Going to Choose Columns - from available columns there are several Ship-to columns but no Ship-to-State. How does one add the missing column to the availability section?

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------


  • 2.  RE: Choose Columns - Missing Field (column) From Available Columns

    TOP CONTRIBUTOR
    Posted Oct 08, 2019 09:12 PM
    If the field isn't available from the list as you would expect, it would mean that you'll need to add that field as an option to the Sales Order list page. You'll do so via the NAV Dev environment. Your partner can assist you with this as well.

    ------------------------------
    Kristoffer Ruyeras
    Solutions Architect
    Tigunia
    Seattle, WA
    ------------------------------



  • 3.  RE: Choose Columns - Missing Field (column) From Available Columns

    TOP CONTRIBUTOR
    Posted Oct 09, 2019 11:35 AM

    You will have to ask your VAR to add it to the visible column view in the left hand pane .



    Ask for a complete field definition listing by Page number so you can find all the other hidden fields.


    It would be interesting if the NAVUG group published a list of the most commonly requested data fields that users had to request be added
    after going live.



    ------------------------------
    Michael Heatherly
    controller
    Lesman Instrument Company
    BENSENVILLE IL
    ------------------------------



  • 4.  RE: Choose Columns - Missing Field (column) From Available Columns

    SILVER CONTRIBUTOR
    Posted Oct 09, 2019 01:19 PM
    Got it. Thanks!​

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------



  • 5.  RE: Choose Columns - Missing Field (column) From Available Columns

    SILVER CONTRIBUTOR
    Posted Oct 09, 2019 01:18 PM
    Thanks - I appreciate it.​

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------



  • 6.  RE: Choose Columns - Missing Field (column) From Available Columns

    TOP CONTRIBUTOR
    Posted Oct 09, 2019 02:25 PM
    Just an FYI, I believe in Business Central, you can do this yourself, as long as the field is available to the corresponding table.

    ------------------------------
    Kristoffer Ruyeras
    Solutions Architect
    Tigunia
    Seattle, WA
    ------------------------------



  • 7.  RE: Choose Columns - Missing Field (column) From Available Columns

    Posted Oct 28, 2019 04:30 PM
    Hi Neil,
    I know you already got the answer but I wanted to add to it for you:
    If you have the right permissions, you can filter by all columns not just the visible ones (image below).  If you need to see it on screen, you can go to the top left and click the blue dropdown arrow and go to help - about this page and it will list all the available table fields that you can have your admin make visible for you.  I generally ask people to give me the page number, table number, and field name from that screen and I can go pop it in for them in a few seconds.




    ------------------------------
    Crystal Whelan
    IT Systems Manager
    Banneker Supply Chain Solutions, Inc.
    North Smithfield RI
    ------------------------------



  • 8.  RE: Choose Columns - Missing Field (column) From Available Columns

    SILVER CONTRIBUTOR
    Posted Oct 28, 2019 07:42 PM
    Thanks Crystal - yes that is useful information to have.

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role