Showing posts with label employee portal. Show all posts
Showing posts with label employee portal. Show all posts

Thursday, November 17, 2011

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.

Friday, September 30, 2011

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.



Tuesday, March 15, 2011

How to Create Salary Structure in ERPNext?

Salary structure will be created for each employee in the company. Salary structure is where employee's earnings and deductions are defined.

To create new salary structure, go to:
HR --> Salary structure --> New Salary structure.
Click on "New salary structure"




























Step 1: Select an employee from employee master for whom you want to create the salary structure.



























Step 2: Mark status of an salary structure as "Yes" or "No".
If marked Yes - System will consider that salary structure for processing salary slip of an employee
If marked No - System wont consider that salary structure for processing salary slip.

Also mention yearly package offered to employee in CTC (cost to company).

Step 3:
Earning and Deduction:
All the earning and deduction heads created in your account will be pulled in salary structure.
1. Keep only required earning and deduction head required for that employee.
2. Mention amount in front of each earning and deduction type.
    Note: No need to mention income tax and leave deduction if creating IT checklist for the employee.
3. LWP = Leave without pay
    Only earning head for whom "Depend on LWP" is marked will be affected when employee takes "leave
    without pay".


Net Pay = total earning - total deduction

Save the Salary Structure.



Now you can create a Salary Slip and IT Checklist against this Salary Structure.


For more details, please visit www.erpnext.com

How to Create an Employee Master in ERPNext ?

To create an employee master, follow steps as shown below




















The Basic Information will capture the name of the employee, status (Active /  Left), date of joining etc. Select the relevant Holiday List applicable to the Employee. If this Employee is taking leaves and a date mentioned in the holiday list falls in that period, that date would not be deducted from his leave balance.


The Employee codes can be generated by either Naming Series followed by a system generated number or Employee Number.This setting can be done from Setup --> System --> Global Defaults --> HR.























The tab for Job Profile will capture the branch, designation and department of the Employee. These details will be fetched from their respective masters.

Salary related information will also be covered like the mode of salary payment which can be Bank, Cash or Cheque. If Bank, then mention the Bank Name and the Bank Account number of the employee.























The Contact Details will have the phone number, email and address details of the employee.






















The Personal Details will capture family background, health and passport details.
























The Educational Qualification tab will capture the details qualifications acquired by the employee, the university and percentage of marks obtained.












The Career History will capture details of work experience in previous companies as well as the current company.
























The Exit tab will be filled when the employee is leaving.


















You can attach the Employee's resume (CV) or Photo in the Attachments tab.








Now save the Employee.









For more details, please visit www.erpnext.com

Monday, March 14, 2011

How to Check Stock Levels in ERPNext?

You can check real time stock available across multiple locations in terms of

  • Reserved Quantity - quantity for which orders are received but not delivered.
  • Actual Quantity-  actual physical stock lying in the warehouse
  • Ordered Quantity- quantity for which purchase orders are raised but not items are not received yet
  • Planned Qty- quantity planned in the production orders
  • Indented Quantity- quantiy for which indents are raised but purchase orders are not.
  • Valuation Rate- fifo or moving average rate for the item 
  • Projected Qty = actual+ordered+planned+indented-reserved

To check your stock level, go to Stock --> Reports --> Stock level




























To check for a specific item available in particular warehouse use the available filters.


























For more information and sign up for a free trial please visit http://www.erpnext.com

Thursday, February 24, 2011

How to Import Masters into ERPNext?

You can import all your masters like items, customers, suppliers, pricelist, warehouse using csv files in ERPNext.


Few standard to be followed when importing data:

  •   Template downloaded from ERPNext account should be followed
  •   Spreadsheet should be saved in .cvs format
  •   Header and column name in template cannot be edited (first 4 rows)
  •   Link field (like item group and warehouse) should be already present in system.

Below you can see how to import a item master.

Go to: Setup --> Import Data


Download the template of the master you want to import. For item master select "Item"




Checking download with data will pull existing data of selected record in excel template. This can be helpful for user to understand as what value to enter in which column.
You will get a list of templates of item master and all child masters inside the item. You need to select the "Item" link to download the template for the item master.
Download and open the template in a spreadsheet as shown below. Add the details in the template. Do not change the row or column positions of the headers. You can enter each item in a new row. You need to fill in all the mandatory fields.


For item master you need to first create the required
1. UOM: Unit of Measurement (Eg: Nos. Kgs. Litres etc.)

2. Item Groups: You can create multiple item groups to categorise your items. There is a "Default" group already created in the system To start with you can upload using a default group and change it later as and when required.

To manage item groups refer to http://erpnext.blogspot.com/2011/02/how-to-create-item-group.html






Save this file as ".csv". In the import data page click on "Browse", select the saved ".csv" file and click on Import.




On importing you can see a log of the imported items on the right hand side as shown below. If there is any error it will be mentioned with the specific row and column number where the error exist.  


In similar manner you can upload customer, supplier and other masters
For more information visit http://www.erpnext.com