Is there any way in standard Navision to record various vendor item no combinations. At present, you can only specify the vendor item no for the preferred/default vendor. In the purchase price screen you can record different prices for different vendors, but you cannot specify the vendor item no for these other suppliers. My customer requirement is to record the vendor item no against the item & UOM combination. I can’t see a way around this and think that there is a customisation required. All feedback / help appreciated.
quote:
Is there any way in standard Navision to record various vendor item no combinations. At present, you can only specify the vendor item no for the preferred/default vendor. In the purchase price screen you can record different prices for different vendors, but you cannot specify the vendor item no for these other suppliers. My customer requirement is to record the vendor item no against the item & UOM combination. I can’t see a way around this and think that there is a customisation required. All feedback / help appreciated.
Originally posted by boydshane - 2005 Jul 22 : 11:14:41
Which version of Navision are you using? In NA 3.60 and later versions you can set “Vendor Item No.” in “Vendor Item Catalogue”. Anna
using version 3.7 I can find a Vendor Item Catalogue Report reference in the help, but cannot find any Vendor Item Catalogue in help or Navision. Could you point me towards same please as it sounds like exactly what is required. Thanks
Vendors on the Purchases button of the Item Card.
Thanks. This seems to only be at the item level and does not support different units of measure. I still think there would be a change required to support this. I see variants are supported, but we are not using variants.
Have a look at Cross References on the Item button of the item card. You can set-up a vendor type cross-reference and specify the UOM. You can’t set purchase prices against these however. I don’t know what you are trying to achieve so don’t know if this will help or not.
Items can be bought from various different vendors, all of whom have their own vendor items nos. The customer needs to be able to store a vendor item no for each vendor supplying an item. items can come in different sizes which we are storing as units of measure off the parent item. In some cases, the vendors will have different vendor item nos for these uom pairs. We need the ability to store these vendor item nos against the uoms for the item. The vendor item catalogue would be fine if it supported uoms. Hope this gives an idea of what we need to do. Thanks for the help.
Size is typically entered as a Variant. Well, in instances like the size of a shirt. If you want to include the Unit of Measure in the Item Vendor catalog, you will need to do some development. Not only to the table to be able to store the information, but also to the logic that gets the purchase prices and such.
On the Item Cross Reference form (Item Card / Item button / Cross Reference option) you can add as many Item Vendor IDs as you like - by UOM. (Select VENDOR in the “Cross-Reference Type” column, select the Vendor Id in the “Cross-Reference Type No.” column, select the “Unit of Measure” and enter the Vendor Item ID in the “Cross-Reference No.” column). To add Purchase Prices by Vendor and by UOM, use the Price option on the Vendors button on the Item Card An added Bonus: On the Purchase Order Line form, do a Show Column and select the Cross-Reference No. field - now you enter the Vendor Item No. in this field to select the Item you want to purchase.