Adding new field in 'Value entry' table, to sync the data from customer table, territory code.

ManiNav · 2021-01-12

Hi Everyone,[NAV 2009 R2]

I am trying to sync data of the field "Territory code" from customer card to the new field(Custom field) in "Value entry" table. I have written below code in new field on validate trigger, but after posting sales order; my new field is not getting update in Value entry table.

New field- onValidate trigger()

IF "Source Type" = "Source Type":: Customer THEN BEGIN
Cust.GET("Source No.");
"Territory Code" := Cust."Territory Code";
MODIFY;
END;

Please assist me, what i am doing mistake or what is the correct way to do for my requirement.

Thanks,
Mani.

kriki · 2021-01-12

The fields in the value entry table are filled up without using validate. You need to put your code in the posting codeunit that writes to this table. In this case : codeunit 22.

ManiNav · 2021-01-12

Hi Kriki,

Thank you so much for your reply,
I created flow-field in value entry table for the territory code of customer table, and data get synced.
Based on your suggestion:-
I checked codeunit:22 to write in value entry table, but i am not sure that where should i assign for territory code in new field of value entry table.

Thanks alot...

Regards,
Mani.

kriki · 2021-01-13

In general, that kind of code is written just before the INSERT statement of that table. Same rule for all Ledger tables.

kriki · 2021-01-13

But also a flowfield can serve the purpose. What is better? It depends. If you need to read or filter on that field, it is better a real field for performance.

kvb · 2021-01-14

Whatever your business goal with this territory field, I believe you can use dimensions for that.

RockWithNAV · 2021-01-22

Flow Fields are not recommended normally keeping performance in mind.
Dimension could be one of the Option provided you have significant amount of knowledge how Global and Shortcut Dimension works.

Howdy, Stranger!

Quick Links

Categories

Adding new field in 'Value entry' table, to sync the data from customer table, territory code.

Answers