Filter on Sales Price

fahd

Dear Experts,
We are using different table (7002) SALES PRICE. for storing sales price.

Since the sales price is stored in other table i am not able to filter the sales price field in my retail item list form which is based on item table.

I was just wondering if there is any way that i could filter the sales price field in that form???

Kindly let me know!

faludigabor

Hi,

You cannot filter without modifying your system .
You or your partner could amend the table for the retail item list then you could do filter within NAV.

Otherwise you are off to do you export to excel then vlookup.

fahd

hi Dear,
Thanks for the reply. yes i know i will need some coding for this but is it possible if you could tell me the possible coding behind it. i am a beginner in coding. i can test this on my testing database.

If it's possible so please tell me that how i am gonna do this!!

thanks.:)

einsTeIn.NET

If you go to Sales & Marketing -> Inventory & Pricing -> Reports there is a Price List. Maybe that helps.

fahd

hi,

Thanks, but actually i want to filter the sales price column which is available in retail item list Form.(99001452).

IF possible Kinldy let me know the coding behind it.

Regards,
Fahd

ajageavi

u can filter it by useing sales type code means by using stores code(sales code).