Where to store client specific data and information

Johannes_Nielsen · 2010-11-18

Hi all 8)

A quick question

I have a few global values, which are used in multiple parts our NAV solution.

Where should I store these? :-s I've used the Company table but thinking I should rather create custom table and form.

Or might there be a native table designed for something like this perhaps?

Savatage · 2010-11-18

There is no unused table to store custom info.

If it's company specific - I don't see an issue.

We add fields like this to specific areas they pertain to.
If it's Inventory based data then we use the "Inventory Setup" Table. Else we use the others
"Sales & Receivables Setup" table, "Purchases & Payables Setup" table, "General Ledger Setup" table, etc.
if it relates to those. If's it's just about the company the "comapny table" then it's fairly logical it should go there.

What's your definition of "Few"

Johannes_Nielsen · 2010-11-18

Savatage wrote:

There is no unused table to store custom info.

If it's company specific - I don't see an issue.

What's your definition of "Few"

Thanks for the reply

The number is below ten.

I just figured that when upgrading, it should be nice to know that more native tables are untouched and things like these values are contained in a separate table?

Dakkon · 2010-11-18

Adding extra fields to some system tables is generally not a big issue for upgrades; Code changes and form restructuring causes more headaches by far. That said, if you have some custom code that utilizes these new fields, it would be good to keep that in a separate codeunit where possible.

David_Singleton · 2010-11-18

I its an add-on or vertical solution that you will implement at multiple sites, then create a new setup table. If it is a one off for your Navision system, then follow Harry's suggestions.

Johannes_Nielsen · 2010-11-19

That cleared it up nicely for me
Thanks alot guys! =D>

Where to store client specific data and information

Answers

Categories