All Vendor-Item Relations

All Vendor-Item Relations

List of All Vendors-Item Relations is used in generating PO. Each items should have a Vendors relation and suggested PO Price.

Register a new Vendor-Item Relation

To create a new record: go to Zoho Creator -> Master Data -> All Vendor-Item Relations and click "+" button on the right side of the report
You'll be redirected to the create screen.
  1. Enter Item No in the Item No dropdown. The dropdown has a list of all registered items. When Item No is selected, the Item Name will be shown.
  2. Enter Vendor Name in the Vendor dropdown. The dropdown has a list of all registered Vendors.
  3. Enter Unit Cost.
  4. If the record already registered for entered Item No/Vendor, you will be redirected to edit screen for the record with current Unit Cost.
Click Submit. The new record will be registered.

Edit Unit Cost for registered Item-Vendor Relation 

To edit Unit Cost for already existing Item-Vendor Relation. Go to Zoho Creator -> Master Data -> All Vendor-Item Relations. Search the Item-Vendor Relation by clicking search icon on the top right side. 
Enter the search values and click "Search"
Click 3 dots on the left side of the record and "Edit"

Or click the record and click "Edit" on the top panel
The edit screen will be displayed. Update the Unit Cost and click "Update". In edit screen only Unit Cost can be updated

Delete Item-Vendor Relation

Go to Zoho Creator -> Master Data -> All Vendor-Item Relations. 
Click 3 dots on the left side of the record and "Delete"

Or click the record and click "Delete" on the top panel

Update/Create Records in bulk

File Preparation

1. Go to Zoho Creator -> Master Data -> All Vendor-Item Relations
2. Click 3 dots on the top right side -> Export
3. Check mark Unit Cost / Item No / Vendor and click Export. 
4. In the exported file add new vendor-item relations or update existing. Save file

Delete current records

1. Go to Zoho Creator -> Master Data -> All Vendor-Item Relations
2. Select all Items and click delete on the top panel. Be sure all records are deleted

Import the file

To update the list with a new file:
1. Go to Zoho Creator -> Master Data -> All Vendor-Item Relations
2. Click 3 dots on the top right side -> Import

3. The file mapping will be displayed in next screen. Confirm fields in the file correspond to field names in the Report. 

4. Next close the Columns Mapping and click Import
5. If there is an error in the file an error list will be shown. In this case check the error and fix the file. You can have the wrong Item No, or Vendor. 
8. When there is no errors, the file will be imported and records will be refreshed
Alert
It is important to delete all previous records before import and avoid duplicates in the file, as it may cause issue with correct Unit Cost aquisition in PO Generate function


inalRemove

    • Related Articles

    • Create or edit an Item

      Items Items are either goods that you purchase from your vendors and sell to your customers, or, services that you provide for which you get paid. In Zoho Inventory, you can add these items with ease and manage their inventory such that, every time ...

    • Create or edit a Vendor

      Create a Vendor To add a new Vendor in Zoho Inventory: 1. Go to the Vendors module on the left side bar under the Purchases 2. Click "+" icon near the Vendors title or "New" button not he top right side 3. Enter required information Primary Contact ...

    • Generate PO

      Generate SO Items POs can be generated after Sales Orders with today's Expected Shipment Day are created and Confirmed. Go to Zoho Creator -> Generate SO Items Last Synced Status: shows the status of last synchronization of Zoho Analytics Last Synced ...

    • Zoho Inventory default features

      Dashboard Inventory Items Composite Items Item Groups Price Lists Transfer Orders Sales Customers Retainer Invoices Sales Orders Invoices Payments Received Sales Returns Credit Notes Cancel Items Purchases Vendors Expenses Purchase Orders Purchase ...

    • Zoho Books default features

      Dashboard Items Items Price Lists Inventory Adjustments Banking Sales Customers Estimates Retainer Invoices Sales Orders Invoices Payments Received Recurring Invoices Credit Notes Purchases Vendors Expenses Recurring Expenses Purchase Orders Bills ...