Display Unit Cost- Service Item Worksheet form

liizz

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

liizz

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