Fixing Minimum Price for Item

[Former Member]

Experts ,

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

Faisal Baloch

[Former Member · Accepted solution]

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

[Former Member]

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]

Dear Manvendra,

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

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

Faisal

[Former Member]

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