Filter on Sales Price

fahd
fahd Member Posts: 226
edited 2011-08-06 in NAV/Navision Classic Client
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!

Comments

  • faludigabor
    faludigabor Member Posts: 4
    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.
    regards,
    Gabor [MVP]
    Navblog
  • fahd
    fahd Member Posts: 226
    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
    einsTeIn.NET Member Posts: 1,050
    If you go to Sales & Marketing -> Inventory & Pricing -> Reports there is a Price List. Maybe that helps.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • fahd
    fahd Member Posts: 226
    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
    ajageavi Member Posts: 15
    u can filter it by useing sales type code means by using stores code(sales code).
    Nav & LS Retail Technical Consultant
    Ajageavi Nath Keshari

Categories