cancel
Showing results for 
Search instead for 
Did you mean: 

Fixing Minimum Price for Item

Former Member
0 Kudos
74

Experts ,

We are looking to fix the minimum price for each Item. How is that possible. Please advice.

Faisal Baloch

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Faisal Baloch,

You may create a price list to hold this Minimum Price for each Item. Then you can use SP Transaction Notification to enforce it.

Thanks,

Gordon

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

Try this

Make a new UDF name as U_ MINPRICE

for purchase just make FMS

-


Select MIN(price) from PCH1 where itemCode = $[PCH1.ItemCode]

-


For Sale :-

-


Select MIN(price) from INV1 where itemCode = $[INV1.ItemCode]

-


And set this FMS in U_ MINPRICE column or system price column.

Thanks

Manvendra

Edited by: Manvendra Singh Niranjan on May 12, 2011 9:46 PM

Former Member
0 Kudos

Dear Manvendra,

Whats the meaning of the below term as written in your solution.

$http://PCH1.ItemCode, $http://INV1.ItemCode

Faisal

Former Member
0 Kudos

Hello,

-


$[PCH1.ItemCode] pick the screen value for searching criteria

-


in that query we are searching minimum price from purchase invoice on the basis of itemcode from database.

-


And using this $[PCH1.ItemCode] we seaching minimum value for this item Code.

Thanks

Manvendra