How to update a new field in table (ID : 336 & 337)

Durand

Hello,

I’ve added a new field in the table (ID : 336 « Tracking Specification » & ID : 337 « Reservation Entry »). I want to update these fields via the form ID : 6510 « Item Tracking Lines ». But Those 2 tables (336 & 337) seems to be updated via a temporary table. I’m not able to find how to update those two table. Who can help me.

Regard’s,

Benoit.

mahesh

I also faced d same thing some times ago & solved dat after HUGE efforts.
this is very tricky & complex, i ever found in Navision.

Very first thing, Navision never stores records in Tracking Specification table.

-->Records gets stored in Reservation Table only. When Form6510 (Item Tracking Spec) runs, it fetches records from Reservation Table & stores in tracking specification for temporary basis only.

-->After posting of relevant document(Order,journal,etc..), You may want to have those fields in Item Ledger Entry OR Warehouse Entry also.

--> Add field in Item Ledger Entry Table also.

-->Add ur new added fields in "EntriesAreIdentical" function (at form 6510) for changed records to save records each time u change ur field value.

--> In CodeUnit-99000830 "Create Reserv. Entry", add new field as parameter in CreateReservEntryFor & in CreateReservEntryFrom function.

--> Call them in RegisterChange function (at form 6510)

--> Add new field in SumUpItemTracking function of Codeunit6500, Item Tracking Management

--> Add code in ModifyItemTrackingOnTempRec function at Codeunit 99000831 "Reservation Engine Mgt."

--> Add code in ModifyFieldsWithinFilter function at form6510, Item Tracking Mgmt.

-->In "Write to Database" function (at form 6510), check for ur field also with other field of reservation.

--> Add Code in CollectPostedOutputEntries function(at form 6510)

--> Add Code in SetItemLedgEntry function (at CodeUnit 99000845 Reservation Management) for to get those fields in Item Ledger Entry also.

Best way to solve this, go on debug the code using Code Coverage & Breakpoints on triggers. Definietly u will get d solution very soon.
This will help u a LOT

Best of luck.

Alisha

I think the codeunit that modifies those tables is 99000845 Reservation Management.

Durand

Hello Mahesh & Alisha,

How long did it take you to solve this problem?

Regard’s,

Benoit.

Durand

Hello Mahesh & Alisha,

Thank for your information it help me to solve my problem.

Regard’s,

Benoit.

mahesh

Hi Durand,

Wat u want to say exactly in ur latest second post?

Regards

Durand

HI Mahesh,

I just want to know how long does it take to do that, because my boss wants to know if it's better for our business to do it ourselves or to make it done by someone else.
Anyway, thanks for your help and spend a nice Christmas time!!

Benoît,

ara3n

Hello.

Here is a how to example, I read on this blog.

http://www.revolution1210.com/article.asp?r0=3&r1=307

mahesh

Hi Durand,

I think it will not take more than 2-3 days.

Once the coding structure is clear. Its easy.

gReat wiShes for chRisTmas