How to set last sales price according to particular party????

[Former Member]

Dear All Experts,

Please give the suggestion for FMS query how i get the last sales price in  according to customer ??

and currently i am using these query

SELECT (T0.[Price]) FROM INV1 T0

WHERE T0.[ItemCode] = $[RDR1.itemcode]

Order by T0.DocEntry desc

Regards,

Varun Pandya

[Former Member · Accepted solution]

Hi Varun,

What is the issue with your given FMS query ? Is it not working ?

Thanks,

Harshal

[Former Member · Accepted solution]

yes its working but i want sales price according to particular customer

[Former Member · Accepted solution]

Try this,

SELECT (T0.[Price]) FROM INV1 T0 inner join OINV T1 on T1.DocEntry =T0.DocEntry

WHERE T0.[ItemCode] = $[RDR1.itemcode] and T1.[CardCode] = $[ORDR.CardCode]

Order by T0.DocEntry desc

Thanks,

Harshal

[Former Member · Accepted solution]

your query is working but i want last sales price of particular customer

[Former Member · Accepted solution]

So which price is it taking ?