Ishrar G

Desktop Based ERP Software

Fraxinus Books ERP

An easy-to-use Desktop Application software that is helpful for Indian MSME Businesses to Manage their Inventory, Accounts, Production, GST, and business analysis without jumping into deep.

Major Functionalities

  • Sales - Orders, Delivery Challan, Invoice, Quotation, Proforma Invoice, Goods Return
  • Purchase - Orders, Delivery Challan, Invoice, Quotation, Proforma Invoice, Goods Return
  • Accounts - Receipt, Payments, Banks, Credit Note, Debit Note, Final Reports
  • Taxation - GST(GSTR1, GSTR2, GSTR3B, GSTR2A Reconciliation), Income Tax, TDS, TCS, EWay Bill, EInvoice

Development Started on: 01 August 2013 Last worked: Still Running We are cooking this product since 2013 and still adding new tastes every day

Technologies used Primary Technologies: C#.Net WinForms in DotNet Framework 4.5, Database: SQL Server LocalDB or SQL Server Express or Azure SQL Server (Elastic) Reporting: RDLC, Crystal Reports, HTML Reports

Supportive Technical Features and Technologies used

Licensing System:

Online Licensing is required to start working on the full software after a trial of 15 days. This system checks licensing details from WebAPIs, WCF, and Web Services (ASMX) to check license details from databases.

There are many internal services provided to users like

  • GST Search - To fetch customer details by providing GST Number
  • EWay bills - To Upload EWay Bill from software without opening portal
  • E-Invoice - To Submit EInvoice to GST Department from software without opening portal
  • SMS notification - Send notification to Customer after invoicing
  • WhatsApp Notification - Send whatsapp notification to customer after invoicing or outstanding reminders

All these services are built using a combination of WCF, Azure Functions and .Net Core WebAPI

Other supportive tools to help product give more advantages like

Backup Tool

Helps to upload backup on Google Drive using Google OAuth or upload the backup on Company Server (Azure blob storage).

Web Portal

To allow users to submit customer orders, customer payments, quotations etc. Users can see the customer's reports from the portal - Developed using these technologies: ASP.Net MVC, Bootstrap, Azure SQL Server, Azure Storage, Azure Web Apps, Azure Web Jobs

Order Booking Portal for Customer

Portal for customers to Book Orders, check statements, check payments and do new payments. Technologies used: ASP.Net Core 3.1, Razor Pages, Bootstrap, Ajax, JQuery, Azure SQL Server

Other technologies

Technologies I used that are not listed above to Build, Run, Deploy, Manage, Improve, observe and support the above product.

  • Visual Studio 2019
  • Git
  • Tortoise Git
  • SourceTree
  • Bitbucket,
  • CodeCommit
  • Azure DevOps
  • Jira,
  • Trello
  • Asana
  • Azure SQL Elastic Pool :
  • Database Firewall
  • Entity Framework :
  • CosmosDB

  • Azure Blob Storage

  • Azure Web Apps

  • Razor Pages
  • Azure Web Jobs
  • Azure Functions
  • Ajax, JQuery, Bootstrap

  • CDN

  • SMTP

  • FTP
  • TCP Port
  • Google OAuth
  • Google Firebase URL Shortner

  • NodeJS

  • Microsoft.Interop.Excel

  • ClosedXML
  • iTextShartp
  • Document Signing - Electronic Signature
  • CryptoLib
  • Obfusecator
  • SignTool
  • CodeSign