[Solved]User requested an additional column on table

RSA_Tech
RSA_Tech Member Posts: 65
edited 2016-11-30 in NAV Three Tier
NAV 2013 R2

User would like the Item Charge Assignment (Purch) table ID 5805 to have an additional column.

The request is to add a column for 'Tariff No.' from the 'Foreign Trade' FastTab on the Item Card.

My question is does a column actually need to be added to the table via Table Designer or can I append the tariff No. field to this list in some other way?

cheers friends,
e.png 91.1K

Answers

  • vaprog
    vaprog Member Posts: 1,162
    edited 2016-11-29
    Hi,

    the desired field needs to be added to the page, not necessarily the table. You may calculate the field on the page (OnAfterGetRecord).
    In this case, however, I'd probably prefer to add a FlowField (Lookup) to the Item Charge Assignment table.
  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    Screenshot attached are basically those fields which developer has deliberately added in the Page. The Flow is whatever you want to see here it must be first added from development side in the page, once it's added then you can go and add remove whatever you wants.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • RSA_Tech
    RSA_Tech Member Posts: 65
    edited 2016-11-29
    RockWithNAV wrote: »
    Screenshot attached are basically those fields which developer has deliberately added in the Page. The Flow is whatever you want to see here it must be first added from development side in the page, once it's added then you can go and add remove whatever you wants.

    Okay, so the columns available are the fields from the Item Charge Assignment (purch) page.

    If I were to add this on the Dev side then it would be through creating a flowfield on the Item Charge Assignment table or altering the OnAfterGetRecord trigger for Item Charge Assignment page ?

    I'm rapidly reading NAV dev resources to get up to speed forgive any obvious lingo mistakes.
  • Kishorm
    Kishorm Member Posts: 921
    RSA_Tech wrote: »
    Okay, so the columns available are the fields from the Item Charge Assignment (purch) page.

    If I were to add this on the Dev side then it would be through creating a flowfield on the Item Charge Assignment table or altering the OnAfterGetRecord trigger for Item Charge Assignment page ?

    I'm rapidly reading NAV dev resources to get up to speed forgive any obvious lingo mistakes.

    That's pretty much it, but just to be clear for both options you would still need to add the new field/column to the Item Charge Assignment (Purchase) Page.
  • RSA_Tech
    RSA_Tech Member Posts: 65
    [Solved] although I'd appreciate a second set of eyes on the process.

    thank you @Kishorm

    My company does not yet have the appropriate granules to allow me to make these changes but I did spec it out for our partner like so:

    1) create New Field on Table ID 5808 name = 'Tariff No.' Data Type = Code and Length = 20

    2) add a table relation for the new field within the field's TableRelation property. The table to relate is Table ID 260 'Tariff Number' and the specific field we are after is the 'No.' field.

    3) open the Table Assignment (Purch) page (Page ID 5805) and add the field 'Tariff No.' to the Repeater group via Page Designer. As long as the first two steps went well then one should be able to select 'Tariff No.' as the SourceExpr for the newly created field.

    compiling the page should complete the modification and make the field available to choose for end users on that page.
  • Kishorm
    Kishorm Member Posts: 921
    2.5) you need to make the field a FlowField and the CalcFormula needs to lookup the Tarriff No. field for the Item table. As it's a FlowField you should also set the Editable property to No

Categories