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”

How OSAS Calculates Average Cost

By Larry Teren

Open Systems Accounting Software (OSAS) calculates average cost in the following formula:
(previous on-hand x previous average cost) + (new quantity x unit cost)
divided by total new quantity Continue reading “How OSAS Calculates Average Cost”