Dynamics Community Forum Thread Details

Show Sales Order Charge Codes on my Custom Form

Hi all,

I have a custom form named MassMaintenanceSalesOrder. This form is bound to a datasource called MassMaintenanceTable. MassMaintenanceSalesOrder form has a grid with a lot of fields in it from Sales Table and Sales Line like SalesId, ItemId, ConfigId and so on.

We already know that in MarkupTrans table, we have a field called MarkupCode which includes all the code charges. I have added some new fields in my custom form datasource table which will hold the value of new markupcodes recently added through Charges Codes form screen.

For example, I have added a new charge code say ChargeValue. I have selected this new charge code for my customer in Auto Charges screen. Now, I make a new sales order. This newly selected charge code should be shown on ChargeCodes screen on sales order header under Sell tab. Sell -> ChargeCodes.

My task is, I want to assign and show the value of this sales order charge code on my custom table grid. I have added a new field with the same name ChargeValue on my custom form datasource table. I want to get the value of sales order charge codes for this particular charge code only and show it on my custom form in right field. Please help, how can I do that?

I want to know the place on my custom form where I can write code for that.

and a possible code snippet which will do this job. Any help please.

Quick Links

Leaderboard