Horizon ERP Tutorial

What is small and medium Trading Enterprise

group
An entity comprises of one or more people
store
Every trading enterprises requires capital, it may be loan or your own savings
stock
Utilised to purchase goods from vendors
sale
Identify potential customers and sells the products
profit
Obtain the profit

What is the most important resource of a small and medium trading enterprise

Working Capital - The capital of a business which is used in its day-to-day trading operations, calculated as the current assets minus the current liabilities.

How is working capital utilized?

  1. It is utilized as credit facility given to good customers.
  2. Invested in the form of inventory that has demand in the market.
flow_chart

What is an ERP Software

ERP is expanded to Enterprise Resource Planning , it is a fully integrated real time system. Where all the data is maintained in one database. Such as, transactions, stock management, finance etc.... To make computations and analysis easier.

Why is an ERP required

ERP software is a tool that aids in the smooth running of an enterprise by helping you manage :

Your Credit

  • Identify your payment defaulters with ease.
  • View outstanding balances in one single dashboard.
  • Streamline your credit control process.
  • Controlling number of pending bills.
  • Setting credit limits.
  • Setting credit days.

Your Inventory

  • Sales Analysis
  • Inventory analysis
  • Tracking of non billed items
  • Keeping track of current stock
  • Rolling out offers/Schemes for slow moving items

Your Profit

  • Effectively tracking profits per bill
  • Deciding to give customers discounts on the basis of their offtake and payment history

An ERP aids the entrepreneur in a number of ways for going about his day to day activities

  • Purchase order generation
  • Mobile/Tablet based order entry
  • Price list management
  • Scheme management
  • Loading sheet generation
  • Inventory tracking with barcode
  • Data security , by implementing user access control
  • Data loss prevention by automatic back ups

How is an ERP implemented in a small and medium trading enterprise?

  • Book Creation (Each financial year is new book).Each book contains the following information
  • Masters
    • Customer list
    • Supplier list
    • Item list
  • Day to day Transactions
    • Purchase orders and Purchase Invoices
    • Sales Orders and Sales Invoices
    • Receipts and Payments
    • Sales returns and purchase returns.
  • Reports Generated on the basis of inputted information
    • Inventory reports
    • Statutory report
    • Analysis reports
    • Financial Accounting Reports
  • Application configuration
    • User account control
    • Application settings

User Interface Design

MASTERS

GST billing software-software masters window

Item Creation

All data input screens share the same UI Template

GST billing software-item creation window
  1. Add a new entry
  2. Search already created entries for viewing as well as editing.
  3. Code and Name Fields are mandatory.
  4. Already created entries are listed here when the user clicks the name field.
  5. Mark for deleting and click on Update
  6. Save the item
  7. Clear the Screen
  8. &9. Additional menu options for the current window for extended functionality

Item Creation- Search

GST billing software-item wise searching window
  1. Filter criteria selection
  2. Type the string of characters or numbers on which the data is to be filtered
  3. List of all items as per filter

TRANSACTIONS

GST billing software-software transactions window GST billing software-transaction entry format

Alltransactions having same entry format

Transactions:

  1. Select series, it is mandatory for all transactions
  2. Enter voucher number (can be manual or automatic)
  3. Entry date is mandatory
  4. Select customer/Supplier
  5. Lists the customers/Supplier when the user clicks on the customer selection field
  6. List of items including prices , quantities and discounts if any
  7. Set the transaction mode to cash /credit
  8. Printing the voucher
  9. Saving the voucher
  10. Clear the screen
  11. Delete/cancel the entry
  12. shows is there any pending delivery note
  13. list the Pending orders
  14. Lists transaction summary
  15. Customer transaction summary
  16. Print settings
  17. On sight delivery details

UTILITIES

GST billing software-software utility window

Loading Utility

GST billing software-software utility loading window
  1. Select bill entry date
  2. Select delivery man from the list shown on the right side
  3. Displays all bills under selected delivery man
  4. Displays the totals of all items billed
  5. Generate Loading sheet
  6. Generate Van statement
  7. Generate Items to be unloaded
  8. Print all Bills in the created load.

Barcode Printing

GST billing software-barcode printing window

Barcode Printing:

  1. Select items based on invoice wise or item wise
  2. Set packing date and expiry date for item
  3. Select barcode label
  4. Filter item using category wise and group wise
  5. Select item
  6. Enter item qty and tick on print to take barcode print and save

REPORTS

GST billing software-software reports window

Inventory Reports

GST billing software-inventory reports window

Inventory Reports:

  1. Date Range for report
  2. Select the report
  3. Filter report based on multiple criteria
  4. Report for the selected date range and filters
  5. Print Report
  6. Refresh Report
  7. Export Report to Excel

Financial Accounting Reports

GST billing software-financial accounting reports window

Statutory Reports

GST billing software-Statutory reports window

EXTRAS

GST billing software-software extras window

User Configuration

GST billing software-user configuration

User Configurtion

  1. Select user
  2. Tick on the box to set rights for the selected user
  3. Save user rights
  4. Refresh Screen

Application Configuration

GST billing software-app configuration

Home Screen

GST billing software-home screen
  1. Click here to expand the window
  2. Scroll the button for show all other reports,
    • Sales category wise
    • Purchase category wise
    • Route wise non billed counters
    • Sales route wise
    • Category wise non billed items
    • Customer performance
    • Overdue bills
GST billing software-purchase category wise summary
  1. Export report to excel
  2. print report