Item Vendor Table

Soumyadip

Hi All,

I was going through Navision Purchase Module. I have seen a Table (Item Vendor)in both Item & Vendor Card -> Menu
What is the use of this table?

Thank You

Regards,
Soumya

Savatage

I believe it was ment to handle the case where you CAN get the same item from different vendors.

even though it's the same item - each vendor might have there own codes/units of measure/etc.

Marije_Brummel

You can use the online help to find out what this table is for.

Just press f1 when you are in the table/form.

themave

the item vendor table also keeps track of pricing for the vendor. So, if you have a item vendor entry for an item, it will use that cost on a purchase order to the vendor. rather then the cost on the item card. This is the case for standard cost items, not sure about average cost items.

Item vendor table entries get created automatically if you use the non-stock item table to create an item.

Otherwise you have to manually enter Item Vendor table enters or use a Dataport to bring in a vendor catalog.

Savatage

Item Vendor Table

You often have several vendors who can ship the same items. You can set up the vendors for each item in the Item Vendor table by clicking the Purchases button on the Item Card and selecting Vendors. You can also find the table by clicking the Purchases button on the Vendor Card and then clicking Items. In one case the menu item you select is called Vendors, in the other case Items, but the table is the same. You are looking at the contents in different ways. The different names emphasize the two different points of view:

The Item Vendor Catalog shows the vendors for the item on the card where you select Purchases, Vendors.

The Vendor Item Catalog shows the items that can be shipped by the vendor from whose card you select Purchases, Items.

When you enter something on an item line, such as on a purchase order, the program always uses as a default the vendor from the Item Card. If this vendor has been set up in the Item Vendor table, the program uses information such as price from the table. You can change the default vendor to one from the Item Vendor table. If the Item Card does not contain a vendor, the program will not suggest one.

Soumyadip

Got it. It is working properly now