Microsoft Dynamics NAV (Archived)

Block Items from Specific Vendors

(0) Share

Report

Posted on by Casper Leibowitz

470

Hi,

Does somebody have a suggestion to make regarding the following situation?

Suppose you have an item that can be purchased from different vendors. One day, we decide that we shouldn't purchase this item anymore from one of these vendors, because of compliance or quality issues.

As a result, it would be necessary not to block the item completely (like checking the "Blocked" checkbox in the Item card), but only prevent someone from either adding this item on that vendor's Purchase Orders, or just releasing an order for this vendor with this item in it.

Would it be possible to accomplish this without any customization, just by using current NAV capabilities?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Amol Salvi 18,698 on at

Like (1)

Report
Copy link

Link copied!

Need to customize for this

If you are using item vendor table then you can add block option in that table and validate while adding in purchase order.

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can code on similar lines.

In Purchase Order page, On Buy from Vendor No. use a validate condition

if Rec.Buy from Vendor No='<your No>' then

Validate(Blocked,True);

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report
Copy link

Link copied!

Why do you want to block an item? If there are issues with compliance, why don't you block the whole vendor?

Was this reply helpful? Yes No
Casper Leibowitz 470 on at

Like (0)

Report
Copy link

Link copied!

Hi Alexander,

You can have vendors that are distributors of multiple items, coming from vendors of their own. There are plenty of reasons why it would be acceptable to buy one item from this vendor, but not another.

As a matter of fact, the issue may come from the manufacturer of an item, not the distributor.

Therefore, I believe Amol and Chris' answers are worth trying, because both address this issue. A distributor would have different part numbers of an item, because their vendors are different. So one could be blocked but not the other.

Was this reply helpful? Yes No
KTA 1,200 on at

Like (0)

Report
Copy link

Link copied!

We've faced a similiar situation but against customers. We've made a new table to related item and customer, we've put also a check because one relationship can be on discuss a few days by quality. Then on sales line with check that.

Was this reply helpful? Yes No