Adding a New Product
This guide explains how to add a new product in the system, each field in the product form, and how to set a revenue account specific to the product so its sales are posted to it instead of the general sales account.
đ
Before you start: Make sure the Inventory app is enabled in your account, and that your role includes the permission Add New Product.
Contents
How to Access
- From the main menu, click Inventory.
- Click Products & Services.
- Click the Add button, then choose New Product from the drop-down list.
Or open the page directly: Add Product.
Steps to Add a New Product
- Fill in the section Item Details: the name, description, category, and others.
- Fill in the section Pricing Details: the purchase price, selling price, and taxes.
- If the product is a stock product, enable Track Stock in the section Inventory Management and complete its data.
- Add any additional data in the section More Details:.
- Click Save.
You find each field explained in Fields Explained.
Fields Explained
Item Details
| Field | Description |
|---|---|
| Name | The productâs name as it appears in the products list, invoices, and reports. A required field. |
| Item SKU | The productâs code. It is generated automatically in sequence according to the auto numbering settings, and you can edit it. |
| Description | A detailed description of the product. |
| Photos | Upload one or more photos from your device, or drag and drop the photos in the upload area. |
| Category | The productâs category, to make searching and reports easier. |
| Brand | The productâs brand. |
| Sales Account | The revenue account the productâs sales value is posted to. It appears only after enabling routing per product. See Setting the Revenue Account for the Product. |
| Sales Cost Account | The account in which the productâs cost is recorded when it is sold. It appears with the Sales Account field when the Accounting app is enabled. |
| Unit Template | The productâs units of measure, such as piece and carton. It appears when multiple units are enabled. |
| Supplier | The productâs main supplier. |
| Barcode | The productâs barcode. Click the circular arrows icon at the end of the field to generate a random number. |
| Available Online | Shows the product in your online store. Requires enabling the Shop Front app. |
| Featured Item | Shows the product in the featured products section of the shop front. Requires enabling the Shop Front app. |
Pricing Details
| Field | Description |
|---|---|
| Purchase Price | The productâs purchase price. |
| Selling Price | The productâs selling price, written without the currency symbol. |
| Tax 1 and Tax 2 | The taxes added to the productâs price in sales and purchase invoices. |
| Minimum Price | The lowest price the product is allowed to be sold at. It appears when advanced pricing options are enabled. |
| Discount | A fixed discount on the product, as a percentage or an amount. It appears when advanced pricing options are enabled. |
| Profit Margin | A percentage added to the purchase price to calculate the selling price automatically. It appears when advanced pricing options are enabled. |
| Price Lists | Add the product to one or more price lists with a different price for each list. |
Inventory Management
| Field | Description |
|---|---|
| Track Stock | Enable it so the system tracks the productâs quantities and inbound and outbound movements. |
| Initial Stock Level | The productâs opening stock. It doesnât appear when requisitions for purchases and sales are enabled or when a tracking type is chosen, and in this case the balance is recorded with a manual inbound requisition. |
| Low Stock Threshold | The system sends an alert when the productâs quantity reaches this limit. |
| Tracking Type | Serial Number, Lot Number, Expiry Date, Lot Number And Expiry Date, or Quantity Only. Requires enabling product tracking from the inventory settings. |
More Details:
| Field | Description |
|---|---|
| Internal Notes | Notes that donât appear to the client. |
| Tags | Words that help you group and search for products. |
| Status | Active to deal with the product, or Suspended or Inactive to stop dealing with it and hide it. |
Setting the Revenue Account (Sales Account) for the Product
The productâs own revenue account in the system is the Sales Account. When it is set, the productâs sales value in invoices is posted to this account instead of the general sales account. This field is hidden by default, and it appears after enabling routing per product.
Step One: Enabling Routing per Product
- Open the page Accounts Routing, the tab Sales: Product Sales Account.
- In Product Sales Account Routing Type choose Specify per Each.
- Click Save. The message Account routing has been saved.
đ
Note: You need the permission Edit General Settings to open the Accounts Routing page. It is enough to do this step once for the whole account.
Step Two: Choosing the Account in the Product
- Open the product for editing, or add a new product.
- In the section Item Details, choose the required revenue account in the field Sales Account.
- Optionally, choose an account in Sales Cost Account to record the productâs cost in a specific account.
- Click Save.
- Default: the productâs sales are posted to the general sales account.
- Without Routing: no account is assigned to the product.
- The chosen account must be a sub-account in the chart of accounts. If the revenue account doesnât exist, create it first under Revenue.
Rules and Restrictions
- Name A required field.
- The barcode isnât repeated for more than one product, and it isnât less than 5 digits.
- A unit template canât be chosen for a product that has a tracking type.
- The fields Sales Account and Sales Cost Account appear only after choosing Specify per Each in Accounts Routing.
- Changing the sales account affects new invoices. The entries of previous invoices donât change unless you edit the invoice and save it again.
Error Messages
| Message | Cause | Solution |
|---|---|---|
| This barcode already used | The barcode is registered for another product. | Enter a different barcode, or generate a random number. |
| The barcode must be at least 5 digits long | The barcode is shorter than 5 digits. | Enter a barcode of 5 digits or more. |
| You canât choose a unit template for a product that has a tracking type | You chose a unit template and a tracking type together. | Choose only one of them. |
| The unit factor is required for each item barcode | You added a barcode for a unit without setting its factor. | Enter the unit factor for each barcode. |
The Effect on the System
Adding the product doesnât create an entry by itself, unless you enter a quantity in Initial Stock Level, so its opening balance is recorded. The effect of the sales account appears when the product is sold. Example: selling a product for 1,000 without tax, with the account âConsulting Revenueâ set as the sales account:
| Account | Debit | Credit |
|---|---|---|
| Client account | 1,000 | â |
| Consulting Revenue (the sales account set for the product) | â | 1,000 |
| Total | 1,000 | 1,000 |
If the field is left on Default, the general sales account appears in place of âConsulting Revenueâ.
Statuses and Settings
- Minimum Price, Discount, and Profit Margin appear when Advanced Pricing Options are enabled in the inventory and products settings.
- Available Online and Featured Item require enabling the Shop Front app.
- Initial Stock Level disappears when requisitions for purchases and sales are enabled or when a tracking type is chosen.
- Tracking Type requires enabling product tracking.
- Sales Account and Sales Cost Account require choosing Specify per Each in Product Sales Account Routing Type.
Frequently Asked Questions
How do I set a revenue account specific to the product or service?
The revenue account is the Sales Account in the product or service form. Enable it first from the sales accounts routing by choosing Specify per Each in Product Sales Account Routing Type, then choose the account in the product. The details are in Setting the Revenue Account for the Product.
I canât find the Sales Account field in the product form. Why?
Because routing per product isnât enabled. The default value of Product Sales Account Routing Type is Without Routing. Change it to Specify per Each so the field appears.
Does the new sales account change the entries of previous invoices?
No. The account applies to invoices created after it is set. The entry of a previous invoice changes only if you edit it and save it again.
Can the sales account be set when importing products?
Yes. After choosing Specify per Each, the columns Sales Account and Sales Cost Account appear in the products import. If the account is incorrect, this message appears: âWrong Sales Account in line number [line number], make sure to select existing sub-accountâ.
Why doesnât the Initial Stock Level field appear?
Because requisitions for purchases and sales are enabled, or because you chose a tracking type for the product. In this case, record the balance with a manual inbound requisition.