Display Unit Cost- Service Item Worksheet form

liizz
liizz Member Posts: 125
edited 2012-08-27 in NAV/Navision Classic Client
Hello,

On the Service Item Worksheet form, is it possible to show the Unit Cost of an item in the Unit Price field based on a specific location code.

E.g:
1) Item A
Location:Green
Unit Price: 20.00 (denotes Unit Cost)

2) Item A
Location: Blue
Unit Price: 65.00(Actual Unit Price)

Thanks
Liizz

Comments

  • liizz
    liizz Member Posts: 125
    Hi all,

    I have defined a boolean field 'Show Unit Cost' in the Location table and the location code 'Green' has been marked as for Items of this location, I want to display Unit Cost.
    The code is working only if am selecting the Location Green on the Service Item Worksheet form and the Unit Cost is getting displayed.

    But when I tried other Locations, the Unit Cost is still getting displayed.
    Please help me where did I go wrong as for other Locations, I want to display the Unit Price.

    My code is below:
    Rec denotes the Service Line.

    Location Code-OnValidate()
    Location.RESET;
    IF (Type=Type::Item) THEN BEGIN
    IF Location.GET("Location Code") THEN BEGIN
    IF (Location."Show Unit Cost") THEN BEGIN
    Rec."Unit Price":=Rec."Unit Cost";
    MODIFY;
    END;
    END;
    END;

    But when I change the Quantity, the price is being changed.

    Thanks to guide me on this post.
    Liizz

Categories