Viewing price list at the time of sale

[Former Member]

Hello Experts

How can we view different Price list for a particular item and select a particular price list in AR invoice.

Regards

Manoj

[kvbalakumar · Accepted solution]

Hi Manoj,

Try this FMS query

SELECT T0.[Price], T1.[ListName] 
FROM ITM1 T0  INNER JOIN OPLN T1 ON T0.PriceList = T1.ListNum
 WHERE T0.[ItemCode] = $[$38.1.0]

Assign the above query in Price field and don't assign as 'Refresh Regularly'.

While creating A/R document, user can activate the FMS by Shift+F2 button or by clicking watch glass icon and able to select the desired price.

Hope it helps.

Regards,

Bala

[Former Member]

Hi Manoj........

You can have yourb own query report if you want to see the price list for a particular item.......

Try this.....

SELECT *  FROM OITM T0  INNER JOIN ITM1 T1 ON T0.ItemCode = T1.ItemCode INNER JOIN OPLN T2 ON T1.PriceList = T2.ListNum WHERE T0.[ItemName] ='[%0]'

Put field in place of star which ever you want............

Regards,

Rahul