Create a New Product File
Previous Top Next
1.    Select Gx Stock on the toolbar.
2.   Select Product Details from the menu.  You can also arrive here via the context menu in placing sales orders. 
3.   You may wish to search the product database before creating the new code to ensure that the product does not already exist under another code. If it does, it is more advisable to create the new code as an alias code of the existing one rather than set up identical products with different codes as separate stock files. 
4.   Click the graphic icon after Product Code.  Select whether you want to set up a Normal product file or a Special.  Normal will allow you to type in the product code that you want to use.  Special will automatically allocate the next available 'own' code.  This helps maintain consistency in your own codes. 
5.   Enter a Description of the product.  (maximum of 100 characters is recommended)
6.   Use the option tabs to set up the information required about this product. These are:

·    Movements to set up bin locations and reorder levels
·    General to set up general product details
·    Suppliers to set up suppliers of this product and their cost prices.
·    Catalogues to set up catalogue information and alias codes for this product code. 
·    Selling Options & Discounts to set up switch selling, upselling and quantity discounts.
·    Product Picture to add a product image or additional information to this item

It is advisable to work through each option tab in turn to ensure you do not miss out any of the details required for this product code. 

Bin Locations and Reorder Levels
Bin locations assign a warehouse location to a product making it easier to find.  The bin location will print on picking notes and delivery notes.  Reorder levels are used in conjunction with the Shopping program to remind you which products are required to replenish the warehouse. 
1.   Click the Movements tab.
2.   Select Bin Location in the top right.  Make sure you are on the correct warehouse line if you have multiple warehouses.  Each warehouse can have its own bin location and reorder level for this product. 
3.   Minimum - enter the minimum stock to be kept in this bin location.  This field is for information only. 
4.   Maximum - enter the maximum stock to be kept in this bin location.  This field is for information only. 
5.   Re-Order - enter the physical stock level you allow stock to drop to before the system prompts you to re-order the product.  When stock falls below this level it will appear on the shopping list when you shop for stocked products . 
6.   Quantity - enter the quantity that you want shopping to reorder when the stock drops below the re-order level. 

back to top

General Product Details
1.   Click the General tab.
2.   Pack Size - select the pack size from the drop-down menu.  Click here for instructions on creating pack sizes. 
3.   Weight - enter the unit weight in kilograms.
4.   Sort Access String - enter a 6 digit 'fast access code' for this product that will help you locate the item without keying in the product code or using the product search. 
5.   Status - this should be Active.
6.   Superceeded Product Code - leave this blank, this should only be used for discontinued products.
7.   Sales Nominal Code - choose the correct nominal code that sales of this product will be posted to when you produce sales invoices.
8.   Purchase Nominal Code - choose the correct nominal code that purchases of this product will be posted to.  This is applied when electronic purchase invoices are received and when invoices posted manually are matched to purchase orders. 
9.   V.A.T. Code - select the correct code for this item, usually 1 for standard rate (17.5%) and 0 for zero rated products. 
10.   Cost Price Valuation Method - this field determines what sort of cost price update and subsequent stock valuation is to be applied to the product.  Select Average, Actual or No Update.   Average will calculate the stock code valuation price as the average of all the booking in cost prices for this product.   Actual will apply the latest cost price booked in. No Update will always hold the last cost price entered in this program and will not be updated by the cost price at the time of booking in. 
11.      Valuation Price - this is the cost price calculated by the system using the cost price valuation method set for the product file. 
12.      Selling Price -  this is the standard selling price for this item.
13.      Recommended Retail Price -  this field is used with the EPOS module, this is the selling price including VAT.
14.      Web Enabled -  if your system is integrated with a Web Store then tick this box if you wish the product to be visible on it.
15.      EU Compliant -  tick this box if the product complies with EU legislation.
16.      EPOS Only Split Packs? - For the EPOS module only, if this is ticked the EPOS module will allow you to purchase this product in singles. It is ticked by default.
17.      BOSSF Group - select the product group from the drop-down menu. Click here for instructions on amending product groups and subgroups, and attaching nominal codes to them.   It is important that you attached product groups to new products so that you can use Gap Analysis and sales analysis by product group. 
18.      BOSSF Sub Group - select the product sub group from the drop-down menu.  It is important that you attached product groups to new products so that you can use Gap Analysis and sales analysis by product group.
19.      Discount Colour Code - select the discount colour category for this product.  Click here for instructions on setting up product colour codes. Discounts can then be given to customers on certain colour categories. This is often referred to as matrix pricing.
20.      Commodity Code - select the correct commodity code from the drop-down menu.  Click here for instructions on setting up commodity codes. 
21.      Selection Group - choose a group from the drop-down menu.  This is your own way of categorising products.  The groups can be set up in Create Stock Selection Groups.
22.      Brand Code - this is the supplier brand name, e.g. Esselte, Emgee, 5 Star, Oki etc.  It allows you to conduct product analysis into the brands you are selling and where you purchase them from. 
23.      EAN Packs Bar Code - enter the pack bar code for the product.
24.      EAN Singles Bar Code - enter the single bar code for the product.

back to top

Suppliers of the Product
1.   Click the Suppliers tab.
2.   Account Code - enter the Supplier's Account Code or use the Supplier Search facility that is available via the menu when you right click the mouse.
3.   Supplier's Product Code - enter this Supplier's Product Code for the item.
4.   Packed - select the supplier pack size from the drop-down menu.
5.   In Stock - if the supplier has EDI capabilities, you can click the ellipsis and connect to their system to check their current stock levels of this product. 
6.   Cost Price - enter this supplier's cost price.
7.   Trade Price - this field is not currently used.
8.   Lead Time - Read Only - Lead time in days. This figure is added by a Supplier's product file update or Terms file upload.
9.   Preferred  - tick the check-box if this is the preferred supplier of this item.
10.   Non Ret.  - tick the check-box if this item is non returnable to this supplier.
11.   Special  - Read Only - if ticked it indicates a special cost price from the supplier. This is not amendable as it is set during the periodical Price Updates.
12.   Add other suppliers of this product in the same way.
13.   Check Last Cost Price - this facility enables you to view when the supplier's cost price was updated and who changed it. To access it right click the mouse over the supplier and select the option from the menu.

back to top

Catalogue and Alias Information
1.   Click the Catalogues tab. 
2.   Catalogue - select the first catalogue that the product appears in from the drop-down menu.  "None" is also an option if this is a manufacturer or own code. 
3.   Alias Code - enter the code used for the product in that catalogue.
4.   Description - enter the description for the product as it appears in that catalogue.
5.   Price - enter the selling price for the product in that catalogue.
6.   Quantity - click the ellipsis icon graphic if quantity breaks apply to this product. In the popup window enter the quantity required to be purchased by the customer, and the price for buying that quantity.  Enter each quantity break, in ascending order, and the price for ordering this quantity.  Save the quantity breaks window.
7.   Nett? - tick the check-box if this is a nett product in this catalogue.
8.   Page - enter the page number the product is on in this catalogue.
9.   Item - enter the item number or letter for this item on that page.
10.      R.R.P. - enter the recommended retail price for the item as shown in this catalogue.
11.      Enter details for any other catalogue this product appears in.

back to top

Selling Options & Discounts
1.   Click the Selling Options & Discounts tab.
2.   Switch Selling Products:
Product Code - enter the codes of any products you can optionally supply instead of this product code. 
Description - this fills in automatically.
Now when you enter a sales order for the stock file you are in, you will be prompted whether you wish to 'switch' it for the codes set up in this option.    
3.    Upselling Products:
Product Code - enter the codes of any associated products. 
Description - this fills in automatically.
Now when you enter a sales order for the stock file you are in, you will be displayed the products set up in this option, prompting you to offer them to the customer.    
4.    Product Discount:
Quantity - enter the quantity to be bought by the customer to received a discount
Discount % - enter the discount to be applied to this quantity.

back to top

Product Image and Additional Information
1.   Click the Product Picture and Other tab if you have a product image or any additional information to add to this item. 
2.   Click on the Ecommerce Information button to view additional information that is used for Ecommerce purposes.  This data is usually supplied by paying a subscription to your supplier.  Once the subscription is active Power-Gx can automatically download the data and any changes regularly. From this screen you can link to the Product Images window to add or delete images associated with a product.
3.   Additional product information supplied by your supplier will already appear in the Extended Description box to which you may edit. You may add any of your own notes about this product in the Product Memo Information box, the system can be configured to display these memos when a user orders the product. 

back to top

If you linked to this program via the context menu in a sales order, you will be returned to the sales order when you Save the product details program, and the new stock code will be inserted in the sales order.