mibuso.com
Home› NAV/Navision Classic Client
Options

Multiple 2 fields

VeselinVeselin 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

  • Options
    KTA8KTA8 Member Posts: 389
    The weight should be taken by line so in table 5406 instead of 5405
  • Options
    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.
  • Options
    ishyampandey@live.comishyampandey@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.
Sign In or Register to comment.