Skip to main content

Vendor Item

Vendor Item is used to connect a property's internal items with the way a specific vendor identifies and prices those items.

For example, the Item Master may contain Housekeeping Tissue, while a vendor's invoice may call it HT-500 or Premium Tissue. Vendor Item stores that vendor-specific code and name so the system can match the invoice line to the correct internal item.

Where to Open It

Open the Vendor Item page from Vendor Management. The page displays items from Item Master and allows the user to filter them by vendor, category, subcategory, assignment status, and search text.

The page does not create a new item. Items must first exist in Item Master. Vendor Item only adds vendor-specific information to those existing items.

Screenshot 2026-09-16 at 2.57.04 PM.pngimage.png

Vendor Item List Fields

The list is generated from active Item Master records and the vendor assignments for the selected property.

Field Use What it shows
Vendor Name Identifies the supplier linked to the assignment. The vendor assigned to the item. An item can show multiple assigned vendors.
Item Code Identifies the internal item. The code maintained in Item Master.
Item Identifies the internal inventory item. The item that will be used for stock and receiving.
Category Groups items for filtering and reporting. The item's category from Item Master.
Sub Category Provides a more detailed item grouping. The item's subcategory from Item Master.
Vendor Item ID Stores the vendor's product code or SKU. The code printed on the vendor invoice.
Vendor Item Name Stores the vendor's description for the item. The name or description used by the vendor.
Price Stores the vendor-specific item price. The assigned vendor price; when no assignment exists, the item purchase rate may be shown as the fallback.
Assignment Status Shows whether the item is mapped to the selected vendor. Assigned or unassigned.

How to Assign an Item to a Vendor

  1. Create the vendor in the Vendor page first.
  2. Confirm that the item already exists and is active in Item Master.
  3. Open the Vendor Item page.
  4. Select or filter by the vendor.
  5. Find the required item using search, category, or subcategory filters.
  6. Enter the vendor's item code in Vendor Item ID.
  7. Enter the vendor's invoice name or description in Vendor Item Name.
  8. Enter the vendor's price in Price, if available.
  9. Select the item for assignment.
  10. Save the assignment.
  11. Confirm that the item appears as assigned and that the vendor-specific values are displayed.

Important Save Behaviour

  • The assignment is specific to both the vendor and the property.
  • There can be one Vendor Item record for a vendor and property. The record contains all assigned items for that combination.
  • Saving assignments updates the existing record when one already exists.
  • If an item is not assigned, the system can still display it in the list, but it will not be available through that vendor's assignment mapping.
  • An item can be assigned to more than one vendor. The Vendor Item list builds an assigned-vendor list for each item.

How the assignment is used in other pages

1. Inventory Receive

When it is used: When receiving stock from a vendor or reading a vendor invoice.

How it works:

  1. The user selects a vendor in Inventory Receive or sends a vendor ID with the invoice.
  2. The system loads Vendor Item assignments for that vendor and property.
  3. The system first tries to match invoice data with Item Master values.
  4. If no direct Item Master match is found, it compares the invoice item code or item number with the Vendor Item ID.
  5. It can also compare the invoice item description with the Vendor Item Name.
  6. When a match is found, the system links the invoice line to the correct internal item and adds it to the inventory receipt.
  7. The received quantity and price can then be used for stock updates and inventory reports.

The assignment is especially important for invoices where the vendor's product code or description is different from the internal item code or name.

2. Inventory Stock

When it is used: When reviewing current stock by vendor.

Selecting a vendor filters the stock item list to items assigned to that vendor. The page also uses Vendor Item data to show vendor context and vendor-related item information.

3. Stock History

When it is used: When reviewing past stock movements.

If a stock history record does not already contain the vendor name or vendor ID, the system can use the Vendor Item mapping for the item to fill that vendor context.

4. Inventory Analytics and Vendor Reports

Pages/reports: Inventory analytics, Vendor Spend Summary, Vendor Spend Detail, and Vendor Unmapped Item Report.

Vendor Item supports vendor-based analysis by connecting received invoice lines to a vendor and internal item. The mapped vendor item ID is also available in detailed inventory and unmapped-item results.

The Vendor Unmapped Item Report is useful for finding invoice items that could not be matched. Those rows are candidates for a new Vendor Item assignment.

What Happens When Related Data Changes

Vendor name changes

When a vendor name is updated, the system updates the stored vendor name in Vendor Item records and inventory receipts linked to that vendor.

Item name changes

When an Item Master item name is updated, the system updates the matching item name in Vendor Item records. Related inventory, stockroom, and stock records are updated as well.

Item deletion

An Item Master item cannot be deleted when it is used by a Vendor Item assignment or other dependent inventory records. The system reports that the item is in use until those dependencies are handled.

Vendor deletion

A vendor cannot be deleted while it has Vendor Item assignments or inventory receipts linked to it.

Troubleshooting

Problem Likely cause Action
Vendor does not appear The vendor is missing, inactive, or outside the current company context. Confirm the vendor exists and use the correct company session.
Item does not appear The item is inactive or not available to the current property. Check Item Master and the item's property/global settings.
Invoice line is unmapped Vendor Item ID or Vendor Item Name does not match the invoice. Update the mapping with the exact vendor code or invoice description.
Vendor filter shows no items No Vendor Item assignment exists for that vendor and property. Assign the item for the correct property.
Assignment disappeared The assignment list was empty or the previous mapping was replaced. Reopen Vendor Item and save the complete intended assignment list.
Back to top