Add or Edit Stock Items

Top  Previous  Next

Items are the things you sell, whether they're products or a service that appear on your invoices.

Go to: Stock  Items > Item Lookup and click on the Add New Stock Button.

You can also import your stock items from a CSV file or you can add an item, by using an existing item. See Item Lookup.

Hover the mouse over the different fields on the form. If the cursor changes to a hand (Hand_Cursor) , click to get more information.

PictureAdditional Order QuantityReservedOn HandAvailableDate AddedWarehouse Stock LevelsHoverAttributeComponentAdditional InfoCost And Selling TabAverage Sales QtyGrowthSupplier Has StockOn OrderMaximumSuggestedReliabilitySupplier Item CodeOther SuppliersPreferred SupplierStock GroupGreen PlusBin LocationShort DescriptionItem NameGreen PlusGreen PlusStatusItem CodeItem NumberDiscontinuedActiveAdditional BarcodesReorder LevelMinimum Order QtyCloneLabelDetail TransactionsSerial NumberDeleteAdd StockStock_Main_General

Other Suppliers / merging of stock items.

Add other suppliers that supply the same stock item.

You can link various suppliers to one stock item (e.g. same stock item sold by different suppliers).

To link the stock items, click on the Other Supplier button on the Main Stock Form, General Tab, then select Link Existing Items Tab. Other Suppliers

 

This also allows you to remove stock codes which have been created  for the same item.  Although this action was not designed for the removal of stock items, you can facilitate this function.

 

To bulk remove the Other Suppliers go to Supplier Lookup > Bulk Change Select

 

NB:  The following actions will occur.

1. If both the items had stock on hand the quantities will be merged.

2.The linked stock item will no longer be visible on your item lookup or purchase planning form.

3.A new average cost will be calculated of the merged items.

4.If you had made out invoices and or GRN's before you linked the items,  the linked item's code will still display on the invoice and GRN.

5.If the linked item was sold before you linked the items, then the newly linked items code will be changed on the Stock Turnover Form to the main items code.

6.If you delete a linked item (by right clicking on the item) from the Supplier Item Link Form (see image below), The item will be completely removed from the database.

7. The supplier item code can be the same or different. If you import your stock items via the CSV import module and the supplier item codes are the same then the items will be linked automatically.

 

If you want the program to select the cheapest supplier for an item (should you have linked more than one supplier),  go to the Purchase Planning Form and click on the More Button and select this option.

 

If you want to get a list of items which have been linked, go to your Purchase Planning Form check the checkbox "Show only stock with multiple suppliers".

 

Supplier_Item_Link_Form

 

Security Settings (You can set the following for this form)

View Restricted subset.  (You can't see the fields)

Cost price, Supplier List Price and Supplier won't show

 

Edit tick. (If the tick is off you won't be able to edit the form)

 

Edit Restricted.

You can't edit the Supplier List Price

 

http://bit.ly/SiAddStock