Dynamics Community Forum Thread Details

Displaying Net Weight in Sales Line on Form

I am trying to display the net weight from the Invent Table to the Salesline on the SalesTable Form but having difficulty. Does anyone know how this is done?

The next thing you'll have to implement is to display a total sales order net weight in the SalesTable form's grid ;-) And it's all gonna be damn slow...
Note: there's an inquiries/totals menu item on the SalesTable form and a lot has been done to run those calculations on the server side. And now you want to run all this code with unit conversions on the client side - over and over again... Note also that in InventTable item's net weight is given for an invent unit that can differ from the sales unit so you'll have to convert the calculated value (item's net weight * sales qty) from one unit to another...
But if you're not concerned about performance issues then there seems to be no problem: implement a display method on the SalesLine table that would calculate the total line net weight (including the unit conversion step), place a new field in a SalesLine grid for this display method and don't forget to setup it's caching on the form.

Quick Links