Block variant not whole item?!

yuppicide

Using Navision 3.10. Is there a way to block a variant?! I know you can block a whole Item Number, but we'd like to block just certain colors of an item.

For instance last year we were doing some styles of clothing in Brown, Green, Coral, Lime, White, Turq, etc, etc. This year we are not going forward with any Coral or Lime.

Marije_Brummel

As far as I remember there is not much functionality in Variants, but you can add a boolean, blocked. You can add this to the tablerelation to avoid selecting and add code to posting routines to avoid posting.

Example CU 22:

IF Item.GET("Item No.") THEN
    IF NOT CalledFromAdjustment THEN
      Item.TESTFIELD(Blocked,FALSE);

ara3n

You have to make a modification.
The other option is to delete the item variant. That way the user cannot select them. This will also delete Stockkeeping units records. So if you have costing setup based on SKU then you need to do modification.

yuppicide

Alright, I've recently been given super user access to Navision. I don't want to do anything with risk of screwing things up, but I'd atleast like to take a look at something.

We can go into an item card for an item that only has ONE SIZE. We goto Item, Combination Allowed, and it'll allow us to uncheck which one we don't want to allow. When we enter an order it'll still show that color under that item, but won't allow us to enter any quantity.

But, with items that are prepacks (a prepack is 1 small, 2 med, 2 large, 2 x large) it will not allow us to do that. We can go in an uncheck the color we don't want to allow, but it still lets us enter it on the order.

We can't block the item because there's more than one color. We just want to block one of the colors.

How would I go in an compare code for the two so I can see why one size works and prepack doesn't? Our service provider wanted to charge us a lot of money to fix something we feel should have been in there in the first place. If one size works, so should prepacks.

yuppicide

Problem solved. We mentioned to our service provider the ability to block one size is there why not prepacks and that we shouldn't have to pay for someone to fix something that should have been there in the first place.

Few hours later I had a fob file to import and it works great.

ara3n

That's great. I'm glad that you went with modification. This mod should be added to the standard Navision.