The Item Vendor table (99) is the primary table for storing vendor-specific purchasing data, such as Lead Time Calculation, Vendor No., Direct Unit Cost, and other parameters used by planning (requisition worksheet, planning worksheet, etc.). It is the table that Business Central consults when calculating supply planning suggestions and when determining the default vendor for an item.
The Item Reference table (5777) is used to store alternative identifiers for an item, such as vendor item number, barcodes, or customer-specific item references. When you add a Vendor Item Reference, Business Central will automatically create or update a record in the Item Vendor table (99) for that vendor-item combination if it doesn’t already exist.
Use cases:
> Use Item Vendor (99) when you need planning data such as lead time, safety stock, or vendor-specific price information.
> Use Item Reference (5777) when you want to record vendor-specific item numbers so they can appear on purchase documents and printed reports.
Yes, the requisition and planning worksheets use the lead time from Item Vendor (99). So even if you use Item Reference (5777) to store vendor item numbers, you should still make sure the Item Vendor record is correct for accurate planning.
Thanks
Rishabh
