ERP using Microsoft Lightswitch.

For the past two months I’ve been developing a full ERP featured system using Microsoft Lightswitch for a financing company, and this is of course aside from my daily ERP implementation and software development routine.  So far I find it intuitive and easy to develop considering that it is fully deployed using IIS 7.  Below is the screen shot of the system running on Firefox, more or less it looks like our MS Access application as time goes by.

I haven’t maximize yet the reportorial capability of Entity Framework via RIA Service and yet I can make a complicated SUM UP report like Income Statement on a breeze.  See screen shot below.

If Microsoft keeps creating tools to leverage us, system developers and process engineers sooner or later the cloud will be crowded.


Software developer living in the Philippines.

Posted in Lightswitch
20 comments on “ERP using Microsoft Lightswitch.
  1. Vishwas says:

    Harold, Good to know that you have developed application like ERP using LightSwitch. I am also planning re-develop mid size ERP application having modules like Finance Accounts, Sales & Distibution, Inventory, Payroll etc. (about 100 Screens or so).

    What reporting platform you are using? DevExpress?

    • hgminerva says:

      Yes vishwas, I am using devexpress, so far i don’t have major problems. Just finish the two financial reports, balance sheet and income statement which has so many groupbys and summation.

  2. vyomesh says:

    Hey!can you provide source code for this ERP?It will be great help for me as i am currently working on same project…….

    • hgminerva says:

      ERP system comprise of several procedures from operation to finance. The operation may change on the type of business of the client and in effect change the chart of accounts of the financial. So it is very broad. But I can give you source codes on specific problem in your ERP project. Just email me your problem.

  3. Vyomesh says:

    HI,Thanks for your reply.I am having difficulty in operation module……Can you send me the source codes to my e-mail id:


  4. Vyomesh says:

    Inventory and Warehousing both.(If possible)!!!!!!!!.Thnx 4 reply…….

    • hgminerva says:

      I only have inventory yet, our warehousing is still running on ms access. Give me a week to modify the application, I will make it simplier and at the same time convert the views to RIA service so that you can run without using any RDBMS.

  5. Vyomesh says:

    hey it would be great help if you provide me entire design in the form of source code of your this erp on my email address…Thnx………

  6. Vyomesh says:

    Hey,I havent’t got mail yet from u…….It would be great help if u send email as earliest as possible…………………

  7. Antony says:

    HI,can you send me the source codes to my e-mail id:; Inventory or sales

  8. Raz says:

    Hi dear can i get the financial module source or at-least financial statements or only balance sheet and profit and loss reports source code , i will appretiate your help my mail is

    • hgminerva says:

      Sure, I am finalizing all the components of the ERP in one system using Visual Studio 2012. For the Balance Sheet and Income Statement, you need at least 2 master tables, account and account category, e.g., Asset, Liability, etc. Then a transaction table, e.g., Journal, that holds the repository of the journal entries thrown by the operation transaction, e.g., Sales Invoice, Collection, Disbursement, etc.. In summary there is a multiple code modules just to get the two reports into place.

  9. Jimi says:


    can you please send me the financial module source code you in advance and thank you for your nice blog

    • hgminerva says:

      Financial includes several modules that totaled over 500 MB in my application. I can only help you on specific problem.

      • Jimi says:

        I’m interested in balance sheet and income statement..can you please send me the tables design for the journal and related information(accounts ,accounts group etc.. ) and how you make the final balance sheet and other financial reports (p&L,Cashflow..)

        Thank you again

  10. hildachuks says:

    Hi Please can you help me with balance sheet and income statement..can you please send me the tables design for the journal and related information(accounts ,accounts group) and how you make the final balance sheet and other financial reports (p&L,Cash flow, income statement and trial balance..)
    Thanks alot

    • hgminerva says:

      Sorry for the delayed response, been so busy lately. Normally I have three tables for the chart of account: account category (asset/liability/equity/income/expense), account type (cash, AR, AP, etc.) and account (which is your chart of account)

  11. dhiren says:

    I just wanted to make an erp project, just as a learning exercise, for a small enterprise, at my home.
    can you suggest me appropriate technology to start with(preferably microsoft)?
    Thank you!

    • hgminerva says:

      Lightswitch might be very good way to start. Learn first the Model and Controller side of a web application. Once you know how these works, you can then transfer to ASP.NET to convert your Lightswitch silverlight views to HTML5 so that you can go mobile.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Harold Glenn P. Minerva
Software Developer / Tech Enthusiast
Living in the Philippines

View Harold Glenn Minerva's profile on LinkedIn


Software Engineer - Seasonal and Range Trading Software. Magenta Trader is a powerful stock market visualization software that increases your probability of trading success.

Software Architect and Founder - is a multi-tenant cloud-based Software-as-a-Service (SaaS) business app that caters to micro, small and medium trading businesses.

CTO and Co-Founder - We give your company the leverage by providing innovative software solutions products such as Point-of-Sales (POS), Financial Information System (FMIS), Payroll and DTR (HRIS), and many more.

%d bloggers like this: