Stock Products

The Stock products in this section will be available for use throughout the Stock functions.

Note

To view the legacy version, please select Legacy User Guide.

How to view Stock Products

Viewing Stock products

As per Generic Navigation options, either from left-hand navigation panel, select Stock products from the Stock folder or enter Stock products in the Search option.

This will then show the Stock products on the system where normal customisation of Sets can be used.

Code: This is the code that was chosen when the stock product was first created.
The tick boxes: Whether it’s an expense, sale, purchase, job, loan, stock or payroll product.
Allow negative stock: Negative stock is only allowed for Standard valuation method.

Tip

To modify the columns displayed, select option on the right of the column display, then tick/untick the information you want to hide or display.

How to create/edit Stock Products

Creating/Editing Stock products

Select Stock products from one of the options as shown above in Viewing Stock products.
Select New -

or select and open the Stock product to edit, then select Edit -

Enter or edit the fields as appropriate.
- Product code:
- Group: Select a Product group.
- Description: Enter a product description to identify the product.
- Unit group: Select a Unit group.
- Unit: Select Unit.
- Type: Select a product type.
- Legacy ref: Enter a legacy reference if needed.
- Force change: Tick this option to force the description to be changed upon use of this product on a document line. This setting does not affect timesheet entry.
Tick the features you would like the products to be available for.
The tab options -
Select the method of valuation for the stock product.
- Standard: This method implies manual assigning of cost to items.
- Average: This valuation method divides the total cost of purchased items by the number of items in stock.
- Allow negative stock: Negative stock is only allowed for Standard valuation method.
  
  Note
  
  If the Stock product already has posted documents, then this option will be blocked.
  
  The tooltip will show Valuation method cannot be changed as documents have been entered against this product.
- You can add the standard pricing for this product by selecting Add then filling out the selection criteria.
  
  Note
  
  Multiple lines can be added for the same stock but located in different locations (and can be differing prices and quantity).
  
  When one of these Stocks is used in a document, the appropriate stock, price and quantity will be used as appropriate to the location selected.
- The Pricing tab shows the stock products pricing information. You can make changes to the effective date, SKU, unit of measurement, quantity, purchase and sale price, supplier, customers and price band.
- To add product pricing, select Add then fill out the selection criteria.
  
  Tip
  
  You can also delete product pricings in this tab by selecting a product line, selecting Delete.
- Add Sale/Recharge and Purchase/Cost details.
Accounting rules are setup in the Accounting (rules) tab.
- Stock keeping units are managed in this tab e.g. small, medium and large versions of a product.
- You can add and lock SKU's by selecting a line then selecting either Add or Lock.
You can view the Stock levels in each Location in this tab.

All Documents created using the product will be in this section.

The products history log will be kept in this section.

Once you have made the changes, select Create or Save.

How to lock Stock Products

Lock a Stock product

Locking a stock product will disable it from being used throughout the stock features.

To do so, open the product that you wish to disable.
Select Lock from the option.

How to copy Stock Products

Copy a Stock product

If you would like to create a similar stock product to another pre-existing product, you can copy then make changes to it.

To do so, choose the product that you would like to copy.
Select Copy from the option.

How to Import/Export Stock Products

Import/Export Stock products

Select Stock products from one of the options as shown above in Viewing Stock products.
Select Stock Product Import from the option.
Enter the name of the Excel file, which is saved on an external source, and other options.

Tip

To create an Import file with the correct field names and formatting, Export a file first and save to your external source. Then use this file to add details ready to import.
Select Submit.

Selecting Queue from the dropdown option will queue the import process until other actions in iplicit are completed.

Warning

iplicit allows a maximum of 5,000 rows in a single Import.

If your Import is too large, an error message will tell you that the Import cannot be processed and will advise you to create smaller Import files.

If the latter is not possible, please contact Customer support.