[Solved]User requested an additional column on table

RSA_Tech

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,

vaprog

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

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.

RSA_Tech

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

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

[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

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