Skip to main content

Software for Light

Various kinds of businesses exist over the years. Many survived with the use of simple technologies. Like in the Philippines, many have not automated their business processes and some are still reluctant in doing so. We are however, in the age of Technology, where almost everything is and will be depending on IT. The need for automation will arrive sooner or later, otherwise, your business gets left behind.

How do we choose the appropriate software for our business? Well it depends on the nature of our business. Let's take Farreys.com for our example.

Farreys offers both product and services. They sell chandeliers, home lighting, etc. They offer lighting fixtures like bathroom light fixtures, kitchen light fixtures, and ceiling light fixtures. When selling tangible products, we either need a Point Of Sale software (if it is a direct sale basis) or a Sales Order System software (if we allow order-basis). With regards to rendering services, a Service-Order System can be acquired. Many are quite familiar with the Point Of Sale (POS) systems. Let's discuss about Sales Order System, and Service Order System (or Job Order System):

A Sales Order System is a software application that we can use to manage orders and payments thereof for certain products. Briefly, the business process runs like this:
  1. Customer makes a Purchase Order to the store (e.g. Farreys)
  2. Store checks items on hand (if available or not) and prepares an Invoice (Charge Invoice) or Delivery Receipt.
  3. Store delivers ordered items to Customer and gives the Invoice and/or Delivery Receipt.
  4. The Customer now has Accounts Payable to the Store.
  5. Store awaits for payment from Customer (may depend on the Customer's agreed payment terms).
  6. Customer pays for the ordered items, and Store records the payments and subtracts the amount to the Customer's Accounts Payable.
Imagine automating the entire process and letting technology handle the recording, monitoring, and processing of these transactions. With the use of a Sales Order System, we don't have to worry about duplicate orders, unrecorded payments, and double invoicing.

As for the Job Order System, the process is similar. Instead of the customer ordering for an item, he/she requests for a service (repair, installation, etc.) Instead of the store delivering an item, it renders the ordered service and bills the customer accordingly.

Comments

Popular posts from this blog

Using Crystal Reports 10 with C#.net and Firebird

C# express doesn't include a report designer or viewer. Reports however, is very much needed when creating a business software. Since C# express doesn't include a report designer, we need to find other means. One is to use a free report such as MyNeoReport. This however may not work under many circumstances. The other alternative would be to use a proven report engine and designer-Crystal Report. Crystal Report has been used by many developers (in our city). However, using a free programming language and IDE, and a free database is very limiting. Not much information can be gathered on the net either (with regards to reporting as of this writing). Here's a way to use Crystal Reports using Firebird database and C# Express as software development IDE: Pre-requisites: C# Express 2005 EMS SQL Manager 2005 for InterBase & Firebird Lite Crystal Reports 10 Create the following database: Name: TestDB1 Tables: TESTTABLE1 Columns:  ID - PK, INTEGER,AUTOINCREMENT DES...

Number to Text in Excel

I was asked today by one of my classmates about converting numeric values to literal values in excel. I thought there was a function for this but I found none. Well I was curious so I looked it up on the web . I've done a little modification here to make it more or less generic (specially when writing in checks). Here's how it's done: Click Tools->Macro->Visual Basic Editor Insert a module Paste the following code: Option Explicit '**************** ' Main Function * '**************** Function SpellNumber(ByVal MyNumber) Dim Temp, WholeNumberText, DecimalText Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position of decimal pl...

Using Firebird with ASP.net

In my previous post , I was able to connect a firebird 2.0 database to asp.net using controls. The next goal was to connect to a firebird database using the firebird.net engine and using the repeater control. I however, was able to use the firebird.net engine to connect to the firebird database but not to the repeater control. I used the html table tag. I've created a simple asp.net demo displaying the contents of a firebird database on page load. Here are the steps: 1. Things Needed: Firebird 2.0 Server Firebird 2.0 Client Visual Web Developer 2. In Visual Web Developer, create a new ASP.net Website (using C# as the programming language). The project will have a default page named Default.aspx. Make sure that the code is separate from the page (ex. Default.aspx.cs is separate from Default.aspx) 3. On the Website menu, click on Add Reference. 4. Select the Firebird - ADO.net 2.0 Data Provider and click Ok. 5. Add using FirebirdSql.Data.FirebirdClient; to the "using" sec...