How to Manage Serial Nos. in ERPNext?

Serial nos. are the unique code assigned to each items. With serial nos. item detail and its location is tracked. Serial nos. is generally tagged for item which requires after sales services on it. Hence, businesses mention serial nos. in invoice based on which items delivery and warranty status is updated. In case of after sales service, company refers to serial no. to check invoice and purchase detail of that particular unit of an item.

Note: ERPNext doesn't have functionality to generated barcode for serial nos. Hence you will need to use third party application to manage generate barcode for serial nos.

Let's consider an example of company in sales of desktop and laptop computer. As there is warranty and after sales services provided on items they assign serial nos. on each unit they purchase or assemble.

Status of serial nos.

1. In store - Available for delivery / material issue. Updated when submit GRN or enter serial no. manually.
2. Delivered - Delivered to customer.  Updated when submit serial no.
3. Purchase return -  These are the serial nos. which are returned back to customer.
4. Not in use - Are the units which were define purchase receipt but then canceled due to some reasons. These are the serial nos. which becomes active if tagged in purchase receipt or material receipt again.

How to make item a serialized item?

Its defined in item master. In Item >> Inventory detail >> Has Serial no., selecting "yes" will make it serialized item.

How serial nos. get assigned to each unit of a item?


Serial nos. are assigned as soon as company acquires that item. The transaction made while receiving items are purchase receipt a.k.a GRN (in trading) and backflush (in production).


Let's consider a scenario when company places an order for 10 units of serial nos. and making a receipt for the same. When making purchase receipt, user will need to define serial nos. for serialized item based on receipt qty. If 10 qty of PC received, then user will enter / scan 10 serial nos. in serial no. column of that item.

Based on the serial nos. of items mentioned in purchase receipt, on submission system will created a unique serial no. record for each unit of an item. Also status for serial no. is set as as "in store" which will also reflect in stock level report.

Inventory of serialized item is tightly integrated with qty of serial nos. in warehouse. In stock level report for item in particular warehouse will be qty of serial nos. with status as "in store". So, if item A has 5 qty in warehouse X. It means that there are 5 serial no. for that item with status "In Store".

There are multiple possible actions which can be taken over serial no. in store. It can be delivered or issues for production (as raw-material).

Delivery Note:
When making delivery note of serialized item you will need to mention serial nos. equivalent to items quantity. On submitting delivery note serial nos. status will change to "Delivered". Also, based on days of warranty mentioned in item master, system will calculate exact warranty expiry dates starting from delivery date.

There could also occur a scenario where sales bom is created for an item. And one of the child item is serialized. In that case, in delivery note, sales bom item will be in main item table but that itself is not serialized item. And child item will be listed in packing details table. You will need to provide child items serial no. in packing details serial no. column.

Material issue:
In case of material issue you will need to provide serial nos. which will be consumed while manufacturing of finished good.

How to Manage Production Order?

Production order is confirmation for production to start moving resources and process raw materials to get finished good.

To create new production order, go to:

Production >> Production Order

Let's check submitted production order which will help us understand the feeding data in and next steps after raising production order.

1. Its an item which will be produced.

2. For this production order, selected bill of material will be considered. Items listed in selected bom will reduce once production completes.

3. FG warehouse: Its a finished good warehouse where finished good when produced completely will be transferred.

4. WIP warehouse: Its a warehouse where production will take place. You will need to create your shop floor as WIP warehouse. All your raw-material will be brought into WIP warehouse only.

5. Consider SA (sub-assembly) item: This field has two options, yes / no.

If select yes, you will need to transfer sub-assembly as one unit of item. You should be selecting yes only if you separately maintain stock of sub-assembly.

Select No if you don't maintain the stock of sub-assembly. If no select, in material transfer, it will pull child item mentioned in bom of sub-assembly.

Once production order is submitted, you will find next steps button which starts with material transfer.

Transfer material: 

This transaction actually takes place in stock entry, where all the raw-material will be pulled from selected BOM. 

Target warehouse will be WIP warehouse selected in production order. User will select source warehouse based on the actual stock level for that raw material item.

After selecting all the information, system will reduce stock level from source warehouse and increase the same in WIP warehouse selected.

Status of production order will change to "in process" once raw material is transferred into WIP warehouse.

Backflush:

Backflush is done when in actual, you have ready finished good to be transferred from shop floor to finished good warehouse. At this stage, your raw material will be considered as consumed.

How to Create Item Groups?

Masters like item group, customer group, territory, sales person are in tree structure.

To create new item group, go to:

Module >> Stock >> Item group

To create new item group click on "New item group".

When click on new item group, it will ask for item group name and parent under which you want to create this item group.

Parent: Parent is the group under item group tree, under which "test item group" will be located.

What is the meaning of has child node?

Has child node field has two options, Yes or No. 

If "yes" selected for item group, it will be added as folder under item group. Item group with child no - yes will be able in parent field while creating item code.

If "no" selected for item group, it will be created as ledger and will be available for selection in item master.

You will be able to select item groups while entering item master which are marked, has child node - No.

Same way, you can define your customer groups, territories and sales person masters.

In-case of query, drop us a line on support@erpnext.com

Configuring ERPNext Account

An application is said to be configured completely when you can start making business transactions like orders, invoices, stock transactions etc.

Let us understand the different types of forms which exist in ERPNext:

1. Masters:
    Masters are sets of records which are created once and used in transactions.
    Example: Customer, Supplier, Item, Customer Group, Supplier Type, Territory etc.
    Once the required masters are set, you can proceed with transactions.

2. Transactions:
    Business transactions are the records created based on an event.
    Example:
    Sales order is made when a customer confirms an order.
    Delivery note is made when goods are delivered to a customer.

3. Reports:
    Reports give you an interface to see multiple records of Transactions / Masters on the same screen

    and allow you to export these records in CSV format.

Getting Started:

When you login into your account for the first time, you will be asked to enter the name, abbreviation, fiscal start date and default currency of one of your companies. This creates the first company for your account.

Note: The abbreviation you enter will be appended to various master records, so that it becomes visibly obvious, which master record belongs to which company.

With company creation, your account creation will also be complete. To be able to start with transactions, you can setup your customer, suppliers, items, tax / bank ledgers.

Customer:

To add a new customer, go to:

Selling >> Customer >> Add new customer

OR

Setup >> System >> Import data. Select customer from the list to download template for importing customer master. Learn more about data import functionality here.

Customer categorization: If you want to create customer groups, go to:
Setup >> Selling >> Customer group

If you don't maintain customer group, continue with "default customer group" which be preset in your account.

Accounting ledger of customer:
Customer ledger will be created in chart of accounts (account receivable) as soon as you add or import them.

Supplier:

To add a new supplier, go to:

Buying >> Supplier >> Add new supplier

Or

Setup >> System >> Import data, Select Supplier from the list to download template for importing supplier master.

Supplier Types: If you want to create supplier types, go to:
Setup >> Buying >> Supplier Types

If you don't have supplier type, continue with "default supplier type" which will be preset in your account.

Accounting ledger of supplier:
Supplier ledger will be created in chart of accounts (account payable) as soon as you add or import them.

Item:

To add new item, go to:

Stock >> Item

Or

Setup >> System >> Import data, select item from the list to download template for importing item master. Learn more about import data functionality here.

Customer categorization: If you want to create item groups, go to:

Setup >> Stock >> Item group

If you don't maintain item group, continue with "Default" which will be auto-created.

To import opening stock for items, go to: Stock >> Stock reconciliation. To learn more, click here.

Accounting ledger:

To create new accounting ledger, go to:

Setup >>  Accounts >> Chart of account

1. Click on group under which you want to create ledger.
2. After clicking on folder (group), under which you want to create ledger, a button called
    "Add a child account" will appear below action items (on right side).
3. Enter account name
4. Select group or a ledger. If "group" selected, then it will become folder and you will be able to
    add child ledgers under it. If "Ledger" selected, then only you will be able to select it in
    transactions.

For getting started, you will need to create few accounting ledgers manually for bank, cash and tax accounts. To learn more on creating ledger in chart of account, click here.

To learn updating an opening balance for accounting ledger, click here.

Note: Ledger for customer and supplier will be added in the receivables and payables respectively. You need not add ledger for customer and supplier manually.

Warehouse:

To create new warehouse, go to:

Setup >> Stock >> Warehouse

Once above discussed masters is set, you will be good to go live with transactions like making quotations, orders and invoices.

For any product related help, please drop us a line at support@erpnext.com

Customize Form View

Let us understand the ERPNext architecture before we venture to learn form customization tool.

ERPNext is built over WNframework. In this framework, each form is created as a table in the backend. Each table has field and properties are assigned to each field.

Like Sales order is a table, in which sales order fields are defined in rows as "Sales order series" and "customer name". Each of these field has properties like "label", "mandatory", "print hide" etc.

Sales order table:

	Field label	Mandatory	Print Hide	In Filter
Sales order Series	Series	(Check box)	(Check box)	(Check box)
Customer Name	Customer	(Check box)	(Check box)	(Check box)

To store more details of sales order like item detail, we have separate table called "sales order item" table. Likewise, taxes are the separate table in sales order. So, for sales order form, sales order table becomes parent and sales order item, taxes and sales person becomes child table.

Please find below the table structure of each form type.

Transaction	Table	Table Name
Quotation	Quotation	Quotation
	Quotation item table	Quotation Item
Sales Order	Sales order	Sales Order
	Sales order item table	Sales Order Item
Delivery Note	Delivery note	Delivery Note
	Delivery note item table	Delivery Note Item
Sales Invoice	sales invoice	Sales Invoice
	Sales invoice item table	Sales Invoice Item
	Sales invoice tax table	Sales Taxes and Charges
Purchase Order	Purchase order	Purchase Order
	Purchase order item table	Purchase Order Item
Purchase Receipt	Purchase receipt	Purchase Receipt
	Purchase receipt item table	Purchase Receipt Item
Purchase Invoice	Purchase invoice	Purchase Invoice
	Purchase invoice item table	Purchase Invoice Item
	Purchase invoice tax table	Purchase Taxes and Charges
Journal Voucher	Journal voucher	Journal Voucher
	Journal voucher item table	Journal Voucher Detail

With this, lets dive into the form customization tool. "Customize form view" is the tool which allows us to select a table and modify fields property as per your requirement.
You can find customize form view by going to:
Modules --> Setup --> Customize form view

Lets' say I want to make item code field mandatory in sales invoice - item table. What will I select in form type?

1. Form type - RV detail (refer to above table for clarification)
2. Selecting form will pull columns of invoice item table (as row here)
3. To make item code mandatory, select check req. for item code and update.
You will need to do clear cache (from tools --> clear cache) and browser refresh to see the effect in the form.

Please refer to table below to learn about field property.

Field property	Purpose	Field Type
Allow on submit	Lets user update value in field even after submission.	Check box
Default	Value defined in default will be pulled on new record creation	Text box
Description	Gives field description for user understanding	Text box
Hidden	Will hide field in form	Check box
In Filter	Will add this field in report	Check box
Label	Label is the name defined for field which appears in form	Text box
Options	Make field drop down selecting	Text box
Print hide	Will hide this field in print	Check box
Reqd (Required)	Will make that field mandatory	Check box

How to Interact With Cutomers Using Support Ticket?

Support ticket helps you automated tracking customer issues which are received in email. If support ticket configured, it will pull mail received on particular email id and create a support ticket in erpnext account.

Each support ticket is assigned a unique no. which is also sent to customer in auto-reply to his query. This helps customer too in following up with you by indicating support ticket no.

Support ticket can be:

1. Allocated to support personnel
2. Replied via system itself and track complete email communication over a ticket.
3. Tracked by status. Tickets which are pending for response is set as "Open". Tickets which are replied is set as "Waiting for Customer". Tickets which are closed is set as "Closed".

Who can access support ticket?
User will need role of "Support team" for accessing support ticket.

Please follow the steps mentioned below to configure support ticket.

In email setting, you will find two options:

1. Out-going mail setting
2. Support ticket mail setting

Once this setting is done correctly, email received on id mentioned here will be pulled into system and there will be support ticket created with unique id and status as open till support executive replies to it.

Status is also assigned as a tag to ticket. You can filer ticket based on status, allocate to support people. Then support staff can filter support ticket allocated to them.

How ERPNext Help in Decision Making?

ERPNext is a application which not only facilities creation and retrieval of transactions, but it also provide a tool (a report) which lets management pull data from transactions and try different permutation and combination in report for analysis purpose.

Selling >> Trend Analyzer

Using trend analyzer, one can run report on different transactions like sales order, delivery note, invoices, purchase order and GRN.

These transactions contain masters like customers, suppliers, items, territories. Trend analyzer allows you do run report on transactions based on masters and time period.

As mentioned above, trend analyzer report pull data from transactions like:

• Quotation
• Sales order
• Delivery note
• Sales invoice
• Purchase order
• Purchase Receipt (GRN)
• Purchase invoice

Report can be ran based on masters:

• Customer 
• Customer group
• Supplier
• Supplier type
• Item
• Item group
• Project
• Territory

Below is the sample report ran for delivery note, based on item:

With the above data, you can do an analysis, which item was delivered the most in specific time period (which can be  month, quarter, half year or year).

Likewise, considering all the permutation and combination, one can run upto 500+ reports from the trend analyzer alone.

How to Create a Salary Voucher in ERPNext ?

There are two ways for creating salary slip.

1. Create salary slip for all the employees at once. To learn more about it, click here
2. Create salary slip individually for all the employees.

To create salary slip for employees one by one, follow the steps mentioned below:

1. Open salary slip:

2. Select employee in salary slip. There are three tabs in salary slip:

• Basic info
• Earning and deduction
• Totals

As soon as you select salary slip, info (like earning and deduction details, name, designation, department) will be pulled from employees salary structure.

Also days attended in selected month will be calculated based on leave transactions made (and not on based of attendance record made) for that employee in that particular month.

Salary Slip

Earning and deduction detail:

As mentioned above, earning detail pulls data from salary detail where employees earning and deduction heads are mentioned. But while making salary slip, earning and deduction heads need to be defined based on:

1. LWP (leaves without payment taken by employee in a month)

2. Over time

3. Allowance (which are on actual) etc..

That's why, their is an add of column called modified amount where amount which employee is entitled to is entered.

Checking LWP will affect amount (and give you modified amount) based on leave application made for LWP for that employee is a month. User can add amount for heads like overtime or allowance manually in earning and deduction head.

3. Total:

Add arrear amount and leave encashment if any. Save and submit.

How to Generate Salary Slips in ERPNext ?

There are two possible ways to making salary slip for empoyees:

1. Indiviual salary slip from employees salary structure
2. Salary manager

Since salary structure of all the employees are pulled from salary structure which remains standard over a period, ERPNext offer feature to generate salary slip in bulk, based on

1. Company
2. Employees 
3. Department
4. Branch
5. Designation
6. Employment type
7. Grade

Following are the steps to be followed for creating salary slip from salary manager:

1. Go to HR --> Tools --> Salary Manager

Select Company and other parameters based on which you want to generate salary slip:

Create salary slip:
Create salary slip will effect into drafting of salary slip (in editable form). Draft form will allow you to edit salary slip (to add overtime or reduce deduction etc..)

Submit salary slip:
It will submit all the salary slips created.

Make JV (accounting entry):

Will take you to general voucher for accounts entry posting.

Multi Currency in ERPNext

Multi currency functionality allows user to maintain price list and making transaction in multiple currency.

A user can define default currency for each company in ERPNext application. For example, you could have 3 companies in your single ERPNext account with different default currency.

Multi-currency transactions possible in transactions:
1. Selling : Quotation, sales order
2. Purchase: Purchase order
3. Stock: delivery note, purchase receipt
4, Accounts: Sales invoice, purchase invoice, journal voucher

When you are making transaction for Test company then INR will be fetched as default with conversion factor as 1.

If i want to make an invoice in currency other than my default currency, then i will select that currency and define conversion rate between select and my default currency.

After selecting currency and mentioning conversion rate, one can select items and put ref rate for respective items.

In items table below you will find columns with duplicate labels like:
Ref rate (for rate in def. currency)
Ref rate* (for rate other then def. currency)

Basic rate (basic rate in def. currency)
Basic rate* (basic rate in other currency selected)

Amount (amount in def. currency)
Amount* (amount in other currency selected)
















Note: No columns of other currency will be editable except basic rate* where user can put discounted amount and discount rate will be calculated automatically.

After saving invoice that's how your transaction will look like:























All ledger posting will be done in default currencies. For example, if you have a bank account of currency USD, even if you do invoicing in INR or any other currency but payment entry would be done  in default currency only. Bank ledger will show balance in USD which is default currency for that company.

Renaming Tool

Using renaming tool you change name of a master records. Master include records like:

1. Customer

2. Supplier

3. Account (ledger)

4. Company

5. Employee

6. Warehouse

7. Item

To rename your records name, go to:

Steps to rename record:

1. Select doctype

2. Select document you want to rename

3. Put you name you want to save record with

How Can I Give Limited Access To My Users?

ERPNext lets you give restrictive access to users. You can define access for users in each department wherein they will be able to see document concerned to him / her.

To go to permission manager, follow this route:

Module >> Setup >> Permission manager

Go to permission manager:

1. Set permission for:
   Select document for which you need to define access to permission based on their role.
   
2. Selecting document will pull table describing access to each role on that particular document.

For more specific role definition like:

1. User should be able to see leads made by him

2. User should see leads allocated to him

3. Particular user should be work on specific customers only etc etc..

From restrict by option, you can change restrict user based on:

1. Company: In-case you have created multiple company. You can define access for each user and that user will get permission to see form and transactions belonging to that company only.
2. Customer: If you want particular person should be able to see details of few specific customers
3. Territory: Its the most widely used parameter in permission setting. You can define access of user to the territory he belongs.
4. Project: User will be able to see projects allocated to him or created by him.

How Can I Change Field Property?

Property setter is a tool which lets you amend the property of field. You can customize field name, size, print related option, default etc. yourself using property setting.

1. Name of field (label)
2. Width of field
3. Type of field (data, select field, time, currency, small text etc..)

How do it get there?

Lets consider a case where i want to make territory field visible in print. So i select:

1. Doctype or field = Dockfield

2. Select Doctype = Customer

3. Select field = Territory

4. Select Property = Print hide

5. Set value = 0

Print hide field is the check box field. Value 0 uncheck it and no. 1 check mark it.

Field property	Purpose	Field Type	Value
Allow on submit	Lets user update value in field even after submission.	Check box	1 = Check 0 - Uncheck
Default	Value defined in default will be pulled on new record creation	Text box	(Text box)
Description	Gives field description for user understanding	Text box	(Text box)
Hidden	Will hide field in form	Check box	1 = Check 0 = Uncheck
In Filter	Will add this field in report	Check box	1 = Check 0 = Uncheck
Label	Label is the name defined for field which appears in form	Text box	(Text box)
Options	Make field drop down selecting	Text box	Enter each select field option in new row
Print hide	Will hide this field in print	Check box	1 = Check 0 = Uncheck
Reqd (Required)	Will make that field mandatory	Check box	1 = Check 0 = Uncheck

How to Start Entries in the New Fiscal Year in ERPNext?

To start entering transactions in  the new fiscal year

1. Create new Fiscal Year and carry forward the balances

2. Create new Naming Series

Note: Creation of fiscal year might take little time since it gets updated in each accounting ledger with balance for new fiscal year.

1. Creating new Fiscal Year

Go to Modules -->Setup --> Fiscal year --> Create the New Fiscal Year as 2012-13

Enter the "New Year", "Start Date " and click on the "Save" button. It might take few seconds to create the new year.

Now Go to Setup -->Global Defaults and change the "Current Fiscal Year".

Enter the "New Fiscal Year" and click the "Save" button.

Now "logout" and "login" again and you are ready to start performing entries in the new fiscal year.

2. Creating New Naming Series

To create new Naming Series for the new fiscal year click How to create/add/edit naming series for transactions?

For more information visit: http://www.erpnext.com

ERPNext Help (Blogs)

 

1. Getting Started

1. How to upload letterhead?
2. How to add users and assign roles?
   
3. How to manage customers and contacts?
4. How to manage suppliers and contacts?
   
5. How to create warehouse?
6. How to create items?
   
7. How to import masters using csv file?
8. How to upload price list?
   
9. How to upload opening inventory?
10. How to manage chart of accounts?
    
11. How to create opening accounting entries?
12. How to create templates for terms and conditions?
    
13. How to create templates for taxes and other charges for sales transactions?
    
14. How to create templates for taxes and other charges for purchase transactions?
15. How to create/add/edit naming series for transactions?
16. How can user change his password?
17. How to restrict user to particular pc or timelimit?

---

2. Selling Module

1. How to manage customers and contacts?
2. How to upload price list?
3. How to create templates for taxes and other charges for sales transactions? 
   
4. How to create leads?
5. How to create enquiries?
6. How to create quotations?
7. How to create sales orders?
8. How to create sales invoice
   
9. How to carry out point of sales transactions?
10. How to manage sales return?
    

---

3. Buying Module

1. How to create suppliers and contacts?
2. How to create templates for taxes and other charges for purchase transactions?
3. How to create indents?
   
4. How to create purchase orders?
5. How to create purchase invoice?
   
6. How to manage purchase return? 
7. How to manage sub-contracting?
   

---

4. Stock Module

1. How to create warehouse? 
2. How to create item groups?
3. How to create items?
   
4. How to import masters using csv file?
5. How to perform stock reconciliation or opening stock entry?
   
6. How to create purchase receipts?
   
7. How to classify an item a sales and/or service item?
8. How to create delivery notes?
   
9. How to configure purchase settings in item master
10. How to configure inventory details of item master?
11. How to account for landing costs for purchase items after the purchase invoice is generated? 
    
12. How to check your stock levels?

---

5. Accounting Module

1. How to manage chart of accounts?
2. How to create opening accounting entries?
   
3. How to create a purchase invoice?
4. How to make expense entries in accounts?
   
5. How to create sales invoice from sales order?
6. How to accept payment against a sales invoice?
   
7. How to accept advance payment from a customer?
8. How to create credit note?
9. How to create debit note?

---

6. HR Module

1. How to create employee master?
2. How to create attendance records?
   
3. How to upload attendance records using csv files?
4. How to create salary slip?
5. How to create earning types for slary structure?
   
6. How to create deduction type for slary structure?
7. How to create salary structure for an employee?
8. How to generate salary slip for all the employee?

For any further help please email to support@erpnext.com or
visit ERPNext user forum

For free trial registration visit ERPNext.com

Cheers
Team ERPNext