Add a new dimension to all entry's

beckindenmark

Hi All

I need to add a new dimension to all entry's, if a dimension already exist.
If dimension = x then insert a new dimensioncode/value. Only add, not replace, so Dimension Correction Tool is not useful.

Please advice best practice for this task, thanks in advance

matttrax

A lot depends on the version of NAV that you are running.

SIPA

Hi beckindenmark,

to be honest I don't know how much assistance you need but in general a process like the following will fit:

LedgEntryDim.INIT;
LedgEntryDim."Table ID" := DATABASE::"YOUR LEDGER TABLE"
LedgEntryDim."Entry No." := YourLedgerTabel."Entry No.";
LedgEntryDim."Dimension Code" := YourDimensionCode;
LedgEntryDim."Dimension Value Code" := YourDimensionValueCode;
IF LedgEntryDim.INSERT(TRUE) THEN;

The "IF INSERT(TRUE) THEN"-Part will tell NAV to try to insert it. If caused by trigger or key error it is not possible, it will simply ignore this record.
In this way you wouldn't overwrite other dimensions.

I neither know if it is the correct table nor if it is what you meant, but for your purpose of not updating this example should work.

Best regards
SIPA

matttrax

A lot depends on the version of NAV that you are running.