Finance | Project Operations, Human Resources, ...

Event Handler when update inventdim in salesLine dont work d365fo

(0) Share

Report

Posted on by Dodi

Hallo, can somenody help me?

I have to fix when change inventdim in salesLine Table do the calculations
like: sales.SalesPrice = salesLine.xxx_BasePrice + salesLine.xxx_AdjustmentPrice + salesLine.xxx_ShipmentRate

but my code dont work, need advice to fix it
Thanks you

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

Event Handler when update inventdim in salesLine dont work d365fo

Hi Dodi,

I think it's better to add the code at modified event handler at form control level or form DataSource level.

Adding at table level won't work here, I guess.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Dodi 73 on at

Like (0)

Report

Event Handler when update inventdim in salesLine dont work d365fo

Hi Girish,

Thanks for answer.. but when i check eventhandler in form datasource i cant find onmodified..

can you help me, how i can find it? btw i new in develop d365fo. need advice. Thanks

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

Event Handler when update inventdim in salesLine dont work d365fo

Hi, You can check SalesTable form and use onModified event in DataSource fields.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

Event Handler when update inventdim in salesLine dont work d365fo

You are checking under DataSource level. You need to check the events by expanding the Datasource >> Fields. Refer to the screenshot which Mohit posted.

Thanks,

Girish S.

Was this reply helpful? Yes No
Martin Dráb 236,974 Most Valuable Professional on at

Like (0)

Report

Event Handler when update inventdim in salesLine dont work d365fo

OnModified would trigger if a user modified InventDimId field through a form control, which will never happen. Users can't do that; they modify fields of InventDim table and the system will then determine InventDimId value and set the value of SalesLine.InventDimId.

If there is no suitable method (handling this logic) to hook to (I would be surprised by that), you can run your code when SalesLine record is being updated.

Was this reply helpful? Yes No
Dodi 73 on at

Like (0)

Report

Event Handler when update inventdim in salesLine dont work d365fo

Hallo Martin Dráb , GirishS , Mohit Rampal

i'm use code like this

its work, but i worry there is data that is out of sync between tables because I changed salesline.salesprice. any input?

Thanks

Was this reply helpful? Yes No
Martin Dráb 236,974 Most Valuable Professional on at

Like (0)

Report

Event Handler when update inventdim in salesLine dont work d365fo

Your approach indeed looks wrong to me.

You have a correct feeling that your code is wrong. You're updating a unit price without recalculating the line amount. Look at logic for SalesPrice in SalesLine.modifyField().

There is also a deeper problem with your design. You seem to completely ignore F&O pricing logic (base price, trade agreements, sales agreements etc.). Still, you let the system to do all the work to determine the correct price, but then you ignore the result and overwrite the price with one calculated with your simple logic. But that's what you wanted to do, so I focused on the topic of this thread, instead of challenging the whole idea.

Also, I don't think you should be using the Updated event. That's the last resort when there was no suitable method, but SalesLine.modifyInventDim() looks suitable to me. That would be a good place for general logic reacting to changes in InventDim, but in this case, I think you should change the logic determining the unit price.

Was this reply helpful? Yes No
GnaneswaranKrishnaram 4 on at

Like (0)

Report

Event Handler when update inventdim in salesLine dont work d365fo

Hi Dodi,

As mentioned by Mohit, you may need to write event handler at Field level "OnModified" in the datasource by copying the event handler method which gives you method signature to write your code.

/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
[FormDataFieldEventHandler(formDataFieldStr(SalesTable, InventDim, InventColorId), FormDataFieldEventType::Modified)]
public static void InventColorId_OnModified(FormDataObject sender, FormDataFieldEventArgs e)
{

// your code goes here
}

Thanks

Gnaneswaran

Was this reply helpful? Yes No