error on prod. order no. in purchase line

j.marseloj.marselo Member Posts: 102
Pals,
I got an error message when trying to fill the Prod. Order No. filed in Purchase Line.
The error message is : "Division by zero <next line> 1 / 0"
Sometime the second line is 6 / 0 , 4 / 0.
Can somebody give me a clue what I have done wrong causing this error?

Thank you.
Kind regards, Joe Marselo | see my NAV blog joemarselo.wordpress.com | twitter @joemarselo

Comments

  • FordewindFordewind Member Posts: 27
    j.marselo wrote:
    Pals,
    I got an error message when trying to fill the Prod. Order No. filed in Purchase Line.
    The error message is : "Division by zero <next line> 1 / 0"
    Sometime the second line is 6 / 0 , 4 / 0.
    Can somebody give me a clue what I have done wrong causing this error?

    Thank you.

    Use the Debugger to catch the error. I think that you have a non-standard code.
    Nav 4.0 sp3
  • j.marseloj.marselo Member Posts: 102
    after i ran the debugger, i notice the error stop in this line:
    Qty. per Unit of Measure - OnValidate()
    Quantity := ROUND("Quantity (Base)"/"Qty. per Unit of Measure",0.00001);

    in Variable box:
    the Rec value of "Qty. per Unit of Measure" = 0
    and the xRec value of "Qty. per Unit of Measure" = 1

    of course it's resulting an error Division by zero.

    in Call Stack box, it pointing at:
    Table 337 Reservation Entry\Qty. per Unit of Measure - OnValidate()

    so, the problem that I still can't find out,
    why the Rec value can contain "0"?
    where that value is assigned to Rec var?

    ](*,) :?: 8-[

    Thanx all.
    Kind regards, Joe Marselo | see my NAV blog joemarselo.wordpress.com | twitter @joemarselo
  • FordewindFordewind Member Posts: 27
    j.marselo wrote:

    in Variable box:
    the Rec value of "Qty. per Unit of Measure" = 0
    and the xRec value of "Qty. per Unit of Measure" = 1

    of course it's resulting an error Division by zero.

    in Call Stack box, it pointing at:
    Table 337 Reservation Entry\Qty. per Unit of Measure - OnValidate()

    Nav 4.0 sp3
  • ssinglassingla Member Posts: 2,973
    You cannot enter production order number manually on the Purchase line. It will come thru MRP lines.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • j.marseloj.marselo Member Posts: 102
    thank you for the responses,
    fordewind: what are you trying to tell me?
    ssingla: are you sure?

    in fact, there are some of PO lines having a Prod. Order No. and Prod. Order Line No. i can enter it manually.
    however, the MRP --- either by Order Planning or Planning Worksheet --- will not update this Purchase Line-Prod. Order No. & Prod. Order Line No..
    instead, it will add up lines in Reservation Entries table to register the reservation of component, can be Reservation, Tracking, Surplus or Prospect.
    Kind regards, Joe Marselo | see my NAV blog joemarselo.wordpress.com | twitter @joemarselo
Sign In or Register to comment.