Adding new field to salesTable and updating this new field value in inventTrans new field in d365FO

(0) Share

Report

Posted on by sharu

I have created a new field in salesTable and inventTrans table. I want to update the salesTable new field value in inventTrans new field . I have created an extension of invent movement class and added my new field as method and using coc i have added the value in initInventTransFromBuffer Before next call.

_inventTrans.NewField=this.NewField();

next initInventTransFromBuffer(_inventTrans,_movement_orig);

Please help me in proceeding further or

any other way to do this?

I have the same question (0)

All responses (6)

Answers (0)

nmaenpaa 101,160 Moderator on at

Like (0)

Report

What kind of help do you need? Is your code not working?

Even without adding any fields you can always fetch the field from SalesTable by using table relations (InventTrans -> InventTransOrigin -> SalesLine -> SalesTable). Are you sure you want to add this field directly in InventTrans? What is it used for?
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Hi Sharu ,

Is value not updating with your modification ? Whats is the purpose of adding new field in inventtrans ?
sharu 10 on at

Like (0)

Report

Hi Sukrut,

No,its not updating.

and the purpose is I want to attach a new field to sales order and also maintain that in transaction also.after doing packing slip i want my sales table field value to be in that invent trans field.
sharu 10 on at

Like (0)

Report

Hi Nikolaos,

yes i want to add it.I want to maintain that new field in transactions.
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

You're still describing your implementation details and not what business problem you're trying to solve.

Do you realize that a single order can have many lines, and each line can have multiple inventory transactions? Why do you want to duplicate the same value to all of them?
nmaenpaa 101,160 Moderator on at

Like (0)

Report

If you want to initialize value from SalesTable to packing slip (or, at least when packing slip is posted), add your field to CustPackingSlipJour (packing slip header) or CustPackingSlipTrans (packing slip line).