Multiple 2 fields

Veselin
Veselin Member Posts: 19
in NAV/Navision Classic Client
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

  • KTA8
    KTA8 Member Posts: 399
    The weight should be taken by line so in table 5406 instead of 5405
  • Veselin
    Veselin 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.
  • ishyampandey@live.com
    ishyampandey@live.com Member Posts: 4
    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.

Categories