1 Creating a Product - Revision history

Simon Clive at 03:06, 25 October 2011

2011-10-25T03:06:10Z

Simon Clive at 02:53, 24 October 2011

2011-10-24T02:53:27Z

Simon Clive at 00:48, 24 October 2011

2011-10-24T00:48:35Z

Simon Clive at 06:33, 21 October 2011

2011-10-21T06:33:33Z

Show changes

Simon Clive: Created page with " Creating a Product Can you enter a New Product? A product can also be created directly from a transaction - enter in the name in the product name field and if it is not yet in..."

2011-06-27T07:05:00Z

Created page with " Creating a Product Can you enter a New Product? A product can also be created directly from a transaction - enter in the name in the product name field and if it is not yet in..."

New page

Creating a Product

Can you enter a New Product?

A product can also be created directly from a transaction - enter in the name in the product name
field and if it is not yet in the system a dialogue box will appear
Warning - Do you wish to create a new product. Say yes and you will be taken to the product screen to enter
all relevant details as below.

Select Inventory from the Main Menu
Select Product + Button which opens up Product details screen
Choose Product Type from choice below

Inventory Part A physical product that has its amount tracked as inventory (it HAS a Cost of Goods Sold,
ATTRACTS Income directly or indirectly, and IS considered an Asset)
Non-Inventory Part A product that has a buying cost but doesn't have its amount tracked. (it HAS a Cost of
Goods Sold, ATTRACTS Income directly or indirectly, but it IS NOT considered an Asset)
Other Type A product that doesn't have a specific buying cost associated with it, but it is sold. (it DOESN'T
have Cost of Goods Sold, it IS NOT considered an Asset, but MAY attract Income)

To create a Tree or group the product select from the drop down menus under Manufacture; Type; Dept
Refer Tree Mode<LinkId=419>.

Enter
New Product Name under Product
Description will auto fill from the product name into the Purchase description then click >>Copy>> to copy over to
Sale Transactions: Note: you can have a different Purchase description than a Sales description if you wish.
Enter the Quantity Buy buy 1 and Cost (inc) is X amount in the first tab then depending on how you can buy the product
(the second and third Qty eg may be Buy 10 cost is X amount and Buy 20 and cost is X amount
COGS Account - Choose from drop down menu - defaults to Cost of Goods Sold
Preferred Supplier - Select from drop down menu

Supplier Code if you choose to use this enter here
Purchase Tax Code (defaults to NCG) to change select from the drop down menu, but check before changing as these codes
feed the Bas/Vat report
Purchase Default Units of Measure (UOM) (Defaults to Units)
Landed Cost if this is known

The average cost will populate once you have made buy and sell transactions - This is set up in your preferences-
Utilities
Preferences
Inventory
Under the General Area Stock Cost System - select Average - To get an average cost ensure you have entered
a buy price and sell price when you first set up the product, then as the product is bought and sold the average cost will
calcuate as you go.

Qty Sell and Price (Inc) Enter as the same as Quantity Buy - if you wish to put on a % to the Cost price enter that value
into the %(Ex): Cost/Sell field and select either Markup or Gross Margin and this will auto calculate the Sell prices

Income Account - defaults to Sales, choose from the drop down menu to change
Wholesale (Ex) %(Ex) if you wish to enter these as a separate pricing structure
Sales Tax Code (defaults to GST) - choose from the drop down menu to change - but check before changing as these codes
feed the Bas/Vat report
Sales Default UOM (defaults to Units)

You will also find a variety of radio buttons to select if applicable.

Special Discount - If selected this product will be available at a special discount to customers who are flagged
as eligable to receive a Special Discount. Each customer can be given a "Special Product Discount" at an
individual rate that is entered in the customer file. This discount rate is then applied to any products with "Special
Discount" flag ticked.
Serial Number Tracking - If selected, serial numbers will be requested and tracked for this product. See
Utilities>Preferences>Inventory<LinkId=232> for a preferences related to Serial Number tracking
Auto Reorder - If selected this products In Stock quantities will be assessed against its reorder points whenever
Auto_Reorder<LinkId=119>is run
Discontinued - If selected the product can not be included on new purchase orders but existing stock can
still be sold. If no stock is held you would make the product inactive.
Included in Analysis - If flagged this product will be included in the "Combined Analysis Report" and "Employee
Analysis" both of which can be found in Employee_Reports<LinkId=304>
Hide on Print - Select if this product is to be hidden on printed invoices but included in the value of the invoice
(it will still be seen on screen) eg. You may wish to add travel expenses when providing a service. Using
Hide on Print will allow you to account for the expenses seperately without displaying them as a seperate
item on the customer's invoice.
Create Job -
Auto Create Smart Order - If Selected the user will be asked if they wish to create a purchase order for
this product when a sales order is raised. This is useful for products that may be sold rarely and therefore
not kept in stock.
Has Formula Attached - Select this item if you want to attach a formula to calculate quantities of another
product that is to be supplied with this one. EG. If selling a product with variuable dimensions such as a
door, a formula might be added to calculate the area based on the height width and depth and calculate the
quantity of paint required for the order. A popup window will appear when the product is ordered asking for
the variables required by the specified formula. See Product_Formulas<LinkId=375> for more information.

You will be able to view the tree in the Product Tree field
Product Comments can also be created if required.

Then click Save

The Active button is selected by default.

Are you using all 4 fields (Columns) to correctly identify your products?

ie.
Manufacture
Type
Dept
Product

The above is called grouping the product eg. Manufacture may be Steel - This enables you to filter on different groups
of the product and see values on just that group.

The above 4 fields create the Product Tree as explained above, these names can be changed by
going into Preferences=>Inventory and rename as required

@@ Line 17: / Line 17: @@
 *Enter the '''New Product''' name under the '''Product''' field
 *The Description will '''Auto Fill''' from the product name into the '''Purchase''' description
 *Click&nbsp; '''&gt;&gt;Copy&gt;&gt;'''&nbsp; to copy over to '''Sale Transactions'''.
-*NB you can have a different '''Purchase''' description than a '''Sales''' description if you wish.
 *Enter the '''Quantity Buy''' '''1''' and '''Cost (Ex)''' is X amount in the first tab then depending on how you can buy the product the second and third Qty '''Eg.''' '''Qty Buy 10''' cost is X amount and '''Qty Buy 20''' and cost is X amount
 *'''COGS Account''' - Choose from drop down menu - defaults to '''Cost of Goods Sold '''
@@ Line 26: / Line 28: @@
 *'''Landed Cost''' if this is known
 To get an '''Average Cost''' ensure you have entered a Buy price and Sell price when you first set up the product, then as the product is bought and sold the '''Average Cost''' will calcuate as you go. This is activated in '''Preferences'''
 *Select the '''Utilities''' Module and then the '''Preferences''' Button - '''Inventory '''
 *In the '''General''' area '''Stock Cost System''' - select the '''Average''' Radio Button
 *'''Qty Sell and Price (Ex)''' Enter as the same as '''Quantity Buy'''
-*If you wish to put on a&nbsp;'''%''' to the Cost price enter that value into the&nbsp;'''%(Ex): Cost/Sell''' field and select either '''Markup''' or '''Gross ''''''Margin''' and this will auto calculate the '''Sell Prices'''
+*If you wish to put on a %'''to the Cost price enter that value into the&nbsp;'''%(Ex): Cost/Sell'''field and select either '''Markup'''or '''Gross<span style="font-style: italic;"> </span>'''Margin''' and this will auto calculate the '''Sell Prices'''
 *'''Income Account''' - defaults to '''Sales''', choose from the drop down menu to change
 *'''Sales Tax Code''' - defaults to GST or choose from the drop down menu to change, however check before changing as these codes feed the '''Bas/Vat''' report
 *'''Sales Default UOM''' - defaults to Units
 You will also find a variety of '''Radio Buttons''' to select if applicable as detailed below.
 You will also find a variety of '''Radio Buttons''' to select if applicable as detailed below.
 *'''Special Discount''' - If selected this product will be available at a special discount to customers who are flagged as eligable to receive a Special Discount. Each customer can be given a "Special Product Discount" at an individual rate that is entered in the customer file. This discount rate is then applied to any products with "Special Discount" flag ticked.
@@ Line 46: / Line 49: @@
 *'''Auto Reorder''' - If selected this products In Stock quantities will be assessed against its reorder points whenever Auto Reorder is run
 *'''Discontinued''' - If selected the product can not be included on new purchase orders but existing stock can still be sold. If no stock is held you would make the product inactive.
 *'''Included in Analysis''' - If flagged this product will be included in the "Combined Analysis Report" and "Employee Analysis" both of which can be found in Employee Reports
 *'''Hide on Print''' - Select if this product is to be hidden on printed invoices but included in the value of the invoice (it will still be seen on screen) eg. You may wish to add travel expenses when providing a service. Using Hide on Print will allow you to account for the expenses seperately without displaying them as a seperate item on the customer's invoice.
 *'''Auto Create Smart Order''' - If Selected the user will be asked if they wish to create a purchase order for this product when a sales order is raised. This is useful for products that may be sold rarely and therefore not kept in stock.
-*'''Has Formula Attached''' - Select this item if you want to attach a formula to calculate quantities of another product that is to be supplied with this one. EG. If selling a product with variuable dimensions such as a door, a formula might be added to calculate the area based on the height width and depth and calculate the quantity of paint required for the order. A popup window will appear when the product is ordered asking for the variables required by the specified formula. See Product Formulas for more information.
+*'''Has Formula Attached''' - Select this item if you want to attach a formula to calculate quantities of another product that is to be supplied with this one. '''EG'''. If selling a product with variuable dimensions such as a door, a formula might be added to calculate the area based on the height width and depth and calculate the quantity of paint required for the order. A popup window will appear when the product is ordered asking for the variables required by the specified formula. See Product Formulas for more information.
 *You will be able to view the tree in the '''Product Tree''' field Product
 *'''Comments''' can also be created if required.
 *Then click '''Save'''
 *The '''Active''' button is selected by default.
 <br>

@@ Line 14: / Line 14: @@
 '''Other Type''' - A product that doesn't have a specific buying cost associated with it, but it is sold. it '''DOESN'T''' have Cost of Goods Sold, it '''IS NOT''' considered an Asset, but '''MAY''' attract Income
 *To create a '''Tree''' or '''Group''' the product select from the drop down menus under '''Manufacture''', '''Type '''and '''Dept '''<br>
-Enter the '''New Product''' name under the '''Product''' field
+To get an '''Average Cost''' ensure you have entered a Buy price and Sell price when you first set up the product, then as the product is bought and sold the '''Average Cost''' will calcuate as you go. This is activated in '''Preferences'''
-The Description will '''Auto Fill''' from the product name into the '''Purchase''' description
+*Select the '''Utilities''' Module and then the '''Preferences''' Button - '''Inventory '''
-NB you can have a different '''Purchase''' description than a '''Sales''' description if you wish.
+*'''Qty Sell and Price (Ex)''' Enter as the same as '''Quantity Buy'''
-'''Preferred Supplier''' - Select from drop down menu
+You will also find a variety of '''Radio Buttons''' to select if applicable as detailed below.
-'''Supplier Code''' if you choose to use this enter here '''Purchase Tax Code''' (defaults to '''NCG''') to change select from the drop down menu, but check before changing as these codes feed the '''Bas/Vat''' report
+*'''Special Discount''' - If selected this product will be available at a special discount to customers who are flagged as eligable to receive a Special Discount. Each customer can be given a "Special Product Discount" at an individual rate that is entered in the customer file. This discount rate is then applied to any products with "Special Discount" flag ticked.
+*'''Serial Number Tracking''' - If selected, serial numbers will be requested and tracked for this product. See Utilities -Preferences -Inventory for a preferences related to Serial Number tracking
-'''Purchase Default UOM''' - Defaults to '''Units'''
+*'''Auto Reorder''' - If selected this products In Stock quantities will be assessed against its reorder points whenever Auto Reorder is run
+*'''Discontinued''' - If selected the product can not be included on new purchase orders but existing stock can still be sold. If no stock is held you would make the product inactive.
-'''Landed Cost''' if this is known
+*'''Included in Analysis''' - If flagged this product will be included in the "Combined Analysis Report" and "Employee Analysis" both of which can be found in Employee Reports
+*'''Hide on Print''' - Select if this product is to be hidden on printed invoices but included in the value of the invoice (it will still be seen on screen) eg. You may wish to add travel expenses when providing a service. Using Hide on Print will allow you to account for the expenses seperately without displaying them as a seperate item on the customer's invoice.
-The '''Average Cost''' will populate once you have made buy and sell transactions - This is set up in your preferences- Utilities Preferences Inventory Under the General Area Stock Cost System - select Average - To get an average cost ensure you have entered a buy price and sell price when you first set up the product, then as the product is bought and sold the average cost will calcuate as you go.
+*'''Auto Create Smart Order''' - If Selected the user will be asked if they wish to create a purchase order for this product when a sales order is raised. This is useful for products that may be sold rarely and therefore not kept in stock.
+*'''Has Formula Attached''' - Select this item if you want to attach a formula to calculate quantities of another product that is to be supplied with this one. EG. If selling a product with variuable dimensions such as a door, a formula might be added to calculate the area based on the height width and depth and calculate the quantity of paint required for the order. A popup window will appear when the product is ordered asking for the variables required by the specified formula. See Product Formulas for more information.
-Qty Sell and Price (Inc) Enter as the same as Quantity Buy - if you wish to put on a&nbsp;% to the Cost price enter that value into the&nbsp;%(Ex): Cost/Sell field and select either Markup or Gross Margin and this will auto calculate the Sell prices
+*You will be able to view the tree in the '''Product Tree''' field Product
+*'''Comments''' can also be created if required.
-Income Account - defaults to Sales, choose from the drop down menu to change Wholesale (Ex) &nbsp;%(Ex) if you wish to enter these as a separate pricing structure Sales Tax Code (defaults to GST) - choose from the drop down menu to change - but check before changing as these codes feed the Bas/Vat report Sales Default UOM (defaults to Units)
+*Then click '''Save'''
+*The '''Active''' button is selected by default.
-You will also find a variety of radio buttons to select if applicable.
+<br>
-−
-Special Discount - If selected this product will be available at a special discount to customers who are flagged as eligable to receive a Special Discount. Each customer can be given a "Special Product Discount" at an individual rate that is entered in the customer file. This discount rate is then applied to any products with "Special Discount" flag ticked. Serial Number Tracking - If selected, serial numbers will be requested and tracked for this product. See Utilities&gt;Preferences&gt;Inventory&lt;LinkId=232&gt; for a preferences related to Serial Number tracking Auto Reorder - If selected this products In Stock quantities will be assessed against its reorder points whenever Auto_Reorder&lt;LinkId=119&gt;is run Discontinued - If selected the product can not be included on new purchase orders but existing stock can still be sold. If no stock is held you would make the product inactive. Included in Analysis - If flagged this product will be included in the "Combined Analysis Report" and "Employee Analysis" both of which can be found in Employee_Reports&lt;LinkId=304&gt; Hide on Print - Select if this product is to be hidden on printed invoices but included in the value of the invoice (it will still be seen on screen) eg. You may wish to add travel expenses when providing a service. Using Hide on Print will allow you to account for the expenses seperately without displaying them as a seperate item on the customer's invoice. Create Job - Auto Create Smart Order - If Selected the user will be asked if they wish to create a purchase order for this product when a sales order is raised. This is useful for products that may be sold rarely and therefore not kept in stock. Has Formula Attached - Select this item if you want to attach a formula to calculate quantities of another product that is to be supplied with this one. EG. If selling a product with variuable dimensions such as a door, a formula might be added to calculate the area based on the height width and depth and calculate the quantity of paint required for the order. A popup window will appear when the product is ordered asking for the variables required by the specified formula. See Product_Formulas&lt;LinkId=375&gt; for more information.
-−
 You will be able to view the tree in the Product Tree field Product Comments can also be created if required.
-−
 Then click Save
-−
 The Active button is selected by default.
-−
-Are you using all 4 fields (Columns) to correctly identify your products?
-−
-ie. Manufacture Type Dept Product
-−
-The above is called grouping the product eg. Manufacture may be Steel - This enables you to filter on different groups of the product and see values on just that group.
-−
-The above 4 fields create the Product Tree as explained above, these names can be changed by going into Preferences=&gt;Inventory and rename as required

@@ Line 1: / Line 1: @@
 '''Creating a Product'''
 Can you enter a New Product?
 A '''Product''' can also be created directly from a transaction - enter in the name in the product name field and if it is not yet in the system a dialogue box will appear Warning - Do you wish to create a new product. Say '''Yes''' and you will be taken to the product screen to enter all relevant details as below.
 *Select the '''Inventory''' Module from the Main Menu and then the '''Product +''' Button which opens up Product details screen
@@ Line 12: / Line 12: @@
 '''Non-Inventory Part''' - A product that has a buying cost but doesn't have its amount tracked, it '''HAS''' a Cost of Goods Sold, '''ATTRACTS''' Income directly or indirectly, but it '''IS NOT''' considered an Asset
 '''Other Type''' - A product that doesn't have a specific buying cost associated with it, but it is sold. it '''DOESN'T''' have Cost of Goods Sold, it '''IS NOT''' considered an Asset, but '''MAY''' attract Income
 *To create a '''Tree''' or '''Group''' the product select from the drop down menus under '''Manufacture''', '''Type '''and '''Dept '''<br>
-Enter New Product Name under Product Description will auto fill from the product name into the Purchase description then click &gt;&gt;Copy&gt;&gt; to copy over to Sale Transactions: Note: you can have a different Purchase description than a Sales description if you wish. Enter the Quantity Buy buy 1 and Cost (inc) is X amount in the first tab then depending on how you can buy the product (the second and third Qty eg may be Buy 10 cost is X amount and Buy 20 and cost is X amount COGS Account - Choose from drop down menu - defaults to Cost of Goods Sold Preferred Supplier - Select from drop down menu
+Enter the '''New Product''' name under the '''Product''' field
-Supplier Code if you choose to use this enter here Purchase Tax Code (defaults to NCG) to change select from the drop down menu, but check before changing as these codes feed the Bas/Vat report Purchase Default Units of Measure (UOM) (Defaults to Units) Landed Cost if this is known
+The Description will '''Auto Fill''' from the product name into the '''Purchase''' description
-The average cost will populate once you have made buy and sell transactions - This is set up in your preferences- Utilities Preferences Inventory Under the General Area Stock Cost System - select Average - To get an average cost ensure you have entered a buy price and sell price when you first set up the product, then as the product is bought and sold the average cost will calcuate as you go.
+Click&nbsp; '''&gt;&gt;Copy&gt;&gt;'''&nbsp; to copy over to '''Sale Transactions'''.
 Qty Sell and Price (Inc) Enter as the same as Quantity Buy - if you wish to put on a&nbsp;% to the Cost price enter that value into the&nbsp;%(Ex): Cost/Sell field and select either Markup or Gross Margin and this will auto calculate the Sell prices