Stock Main Form: Other Suppliers

Top  Previous  Next

Other suppliers that supply the same item

You can link multiple suppliers to a single stock item, allowing you to track and manage the same item sold by different suppliers..

 

How to Link Suppliers

To link a stock item to other suppliers:

 

1.Click on the Other Supplier button.

    Other Suppliers

2.Select the Link Existing Items tab.

3.Choose the relevant stock items to link.

 

Removing Duplicate Stock Codes

This feature also helps eliminate duplicate stock codes created for the same item. Although not designed specifically for this purpose, it can facilitate the process.

 

To bulk remove linked suppliers:

Go to Supplier Lookup > Bulk Change Select

 

Important Considerations

When linking stock items, the following actions will occur:

 

1.Stock Quantities Merge – If both items had stock on hand, their quantities will be combined.

2.Stock Item Visibility – The linked stock item will no longer appear in the Item Lookup or Purchase Planning Form.

3.New Average Cost Calculation – A new average cost will be calculated for the merged stock.

4.Historical Transactions

Past invoices and GRNs will still display the original linked item code.

If the linked item was sold before merging, its code will be updated to the main item’s code in the Stock Turnover Form.

5.Deleting a Linked Item –

Right-click on the item in the Supplier Item Link Form to remove it.

This action will completely remove the item from the database. (See image below)

6. Supplier Item Codes

The supplier’s item code can be the same or different.

If you import stock via the CSV import module and supplier item codes match, the system will automatically link them.

 

Choosing the Cheapest Supplier

If multiple suppliers are linked to a stock item, you can set the system to automatically select the cheapest option.

Go to the Purchase Planning Form, click More, and select this option.

 

Viewing Linked Items

To generate a list of items with multiple suppliers:

Open the Purchase Planning Form and check the box "Show only stock with multiple suppliers."

 

Supplier_Item_Link_Form

 

Recommended Retail Price (RRP). You can change the name in Stock Options.

Keywords: Link Existing Items,Merging Stock,Other Suppliers,Preferred Supplier,Recommend Retail Price (RRP),Supplier Has Stock,Supplier Stock On Hand