Item Master

vijayanderson

hi all,

Item Master in Navision is common for both Sales and Purchase, it there any option to define the item as Sale item , or purchase item or Both. so that the same can be filter in Saler order ( any sales process) & purchase order ( any purchase process)

Cheers
Vijay

DenSter

The nice thing about the Item table is that it's the same thing no matter where you are. You could assign Inventory Posting Groups, or categories, or product groups to Items to categorize them, is that what will work for you?

rajatkalia

Hi
u can use Security Filter for the sales items while assigning permissions for a user because sales people only will make sales orders. with this whenever sales people make sales orders only sales items will be visible to them. hope this answers ur question

Rajat.

vijayanderson

you answered the question but where do you define the item as sale item or purchase item or both

DenSter

You don't. An Item is an Item, you can use them anywhere that Items are used. I don't see how security filters are useful in this discussion.

garak

](*,)

per default it's not possible. You must design this. No code needed (simple solution)

New field in Table Item "Use for" Option All,Sales,Purchase
These new field on Item Card / List
On table 37, 39, some other tables if nedded, modify the TableRelation of field "No." to
Condition Table Field Table Filter
Type=CONST(Item) Item Use for=FILTER(All|Sales)

Now you can sale only items of type all / sales in Sales order / Invoice.

But you must knwo, what you do ;-)

Regards

vijayanderson

Thanks Garak