Multiple 2 fields

Hello.
I need to multiply two fields in Navision
Production order Quantity and Item Gross Weight

I make:
- new field in Production order table -> Total Weight
- Production order table -> OnValidate -> "Total Weight" := Item."Gross Weight" * Quantity;

But it's not working.Where is the problem?

Answers

  • KTA8KTA8 Member Posts: 397
    The weight should be taken by line so in table 5406 instead of 5405
  • VeselinVeselin Member Posts: 19
    KTA8 wrote: »
    The weight should be taken by line so in table 5406 instead of 5405

    Production Order table have total Quantity field as decimal.
    I tried 5406 still don't work.
  • Debug and check your Item. Gross weight is 0 or getting value from table or not. Because your code is right. And I think you wrote the code on the wrong trigger which (Trigger )is not activated when required. Like, write code on Production order Quantity's trigger so when the system gets quantity it brings item weight and multiply it with qty and assign your total weight.
Sign In or Register to comment.