Location wise filter

ebrahmaebrahma Member Posts: 36
edited 2004-03-30 in Navision Attain
Hi,

I would like to know how to filter the records based on the locations(remote as well as local) ie one should view records belonging only to his locations (ex: Masters : customer, vendor, items ; Transactions: sales order -> invoice)...

Need to write any piece of code or existing system will do or any other method will do.

regards

Comments

  • eromeineromein Member Posts: 589
    I think you will need a user (or salesperson) specific "default location" setting.

    This setting you can use to filter records. Don't forget to define a location key in every table you gonna filter.

    But I think this is MAYBE not the right solution... It's to much work.

    Think about the following solution(s):

    Give Cust, Vend, Item, ect... a location specific number. Sample: All customers in location green, CGR001. Vendors in location blue : VBL001.
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
Sign In or Register to comment.