Can Accounting Software Be Put on a Cloud and What is a Cloud Anyway?

The ‘cloud’ is the current darling of the high tech world. It is creating jobs for some and taking away for others. Think of the cloud as a rented web server. Instead of maintaining your own equipment, you rent an ip addressable server at a remote location.


Businesses put their computer systems on clouds for two main reasons:

1. Less maintenance cost.
2. Equal access to all.

Less Maintenance Cost

Software applications are installed and run on a computer located in a remote location rather than on your property. No need to own and maintain expensive equipment.

You will need, though, a high speed and large bandwith internet connection to satisfy the reliability of access. No need to hire a staff of expensive hardware support employees for on-site assistance. Hardware and network services are taken care of by the cloud hosting company.

Equal Access to All

Less need to be concerned what type of computer the user has. Everyone uses similar scripts to access the same software.

When the new version of Excel or Word or Access is made available, the remote cloud support personnel install it hassle free.

What are the negatives?

If your internet connection goes down, you cannot access the cloud. If your software is installed on a local computer, then whether the internet is working or not is a moot point.

You need to make sure that your application can be loaded readily onto the cloud. You should never accept a cloud service that tells you that you need to send the installation cd to their location. The cloud service must give you a way to insert the cd in a local workstation and mount it (or connect) to their server.

Do not expect the cloud support staff to have knowledge of your business applications. Their job is to support and maintain the server and network services on which it is hosted.

Accounting Software

Accounting software can be put on the cloud. Don’t expect the cloud support personnel to help you unless they also happen to be authorized support for the accounting system. The advantage of putting your accounting system on the cloud is when you have many users who are at different locations and need a simple way to access it as readily as anyone else.

For more information, call (773) 502-5771 .
click here to return to home page

Accessing OSAS Data in Excel

By Larry Teren

1. Go to Microsoft Excel. (The screen shots used here are from Microsoft Excel 2010)

2. Click the DATA tab and the FROM OTHER SOURCES. Slide down to FROM MICROSOFT QUERY and click (See screenshot below). Continue reading “Accessing OSAS Data in Excel”

ODBC Setup in Control Panel for Open Systems Accounting Software (OSAS)

By Larry Teren

1. Click on access to Control Panel link.

On Windows XP, click Administrative Tools Link Continue reading “ODBC Setup in Control Panel for Open Systems Accounting Software (OSAS)”

How to use SQL Query Feature in Enterprise Manager

By Larry Teren
Do the following in order to generate an sql query that you can paste into Microsoft Excel:

Log into Enterprise Manager and establish a properly configured database. Click on the TABLES tab, highlight a table name and double-click on it. In our example below, we have chosen ARCU, the customer master file. Note that it indicates there are 13 rows or customer master records in the table (or file). Continue reading “How to use SQL Query Feature in Enterprise Manager”

Enterprise Manager is versatile OSAS to Microsoft Excel link

By Larry Teren

If you feel at home using Microsoft Excel and want your business accounting software to integrate with it, consider the Enterprise Manager your friend. Basis’ Enterprise Manager has been a welcome utility for Open Systems Accounting Software (OSAS) users since its inception a few years ago. The Enterprise Manager is included for free ever since the bbj version (java enhanced business basic) was adopted for OSAS. Continue reading “Enterprise Manager is versatile OSAS to Microsoft Excel link”

Is OSAS, Open Systems Accounting Software, Good Business Software?

By Larry Teren

Is Open Systems Accounting Software a smart purchase? It is a legitimate and fair question. The answer is that it is a good fit for many but may not be appropriate for others. We shall explain: Continue reading “Is OSAS, Open Systems Accounting Software, Good Business Software?”

How to Apply credit memo and deposits to invoices in Open Systems Accounting Software

By Larry Teren

Whether you review an AR Aged Trial Balance or your customer reviews the printed statement you sent them, it makes sense to make sure that payments and credit memos are applied appropriately to invoices. Why? You want the invoices to be aged properly.

Notice in the example below that there are three payment records that do not match an invoice number. We can use the SPLIT/REAPPLY feature in the HOLD/RELEASES routine to reassign part of any of these three payments to any of the invoices. Continue reading “How to Apply credit memo and deposits to invoices in Open Systems Accounting Software”

How to Close out older Purchase Order in OSAS

By Larry Teren

Open System Accounting System (OSAS) Purchase Order module handles the purging of open orders differently than the Sales Order module.

In the Sales Order module, a line item in an open order that is verified and invoiced gets erased once it is posted. In other words, if a five line item order has three lines invoiced and the other two back-ordered, once posted only the remaining two are left in the order. If the entire order is invoiced and then posted, the order disappears out of the open order file. Continue reading “How to Close out older Purchase Order in OSAS”