Oneir Solutions

About jon.w

This author has not yet filled in any details.
So far has created 51 blog entries.

Refund AR by Cheque

When a customer has a credit balance on their account it is sometimes necessary to refund them by check. To refund a customer by check there are three steps to have a good accounting trail. If they do not have a credit yet but have returned the items the first step is to create the credit note on the customer’s account. Usually this will be done through the same module that the original sale was made. Once the credit note is on the account follow the next two steps below.
Step #2. Clearing the customer’s credit from the account.
1. Go to the Accounts Receivable menu.
2. Go to ‘Post manually prepared invoices and credit notes’.
3. Enter the customer code you are refunding.
4. Select ‘Debit and increase Receivables.’
5. Enter ‘CREDIT’ for invoice number.
6. Enter the credit note number you are refunding. (If you do not know the credit note number you may […]


Oneir has always provided the option of calculating and displaying finance charges on past due interest charges on your printed statements. These charges, however, were not posted to the customer account receivable ledger or general ledger. This provided a method of informing the customer that there were consequences to late payment of invoices but did not overstate your account receivable for the cases where the finance charges generally were not being paid. Now Oneir provides the ability to accumulate the past due charges on the customer’s accounts receivable ledger. Here is how it works.

Oneir will post finance charges to customer accounts receivable and the general ledger. While Oneir allows you to be selective in it’s posting, i.e. choose one or a range of customers, a particular customer type or a specific customer term, only those customers set up in the accounts receivable with the Statement option, “with finance charge” will […]

Oneir Year End Closing

Date is outside three fiscal years. You may wish to close year end through GL. Press SPACE to continue.
If you receive the preceding message when entering Oneir Software you must perform a year end close to continue working in the current fiscal period.

Please perform the following steps bellow if you wish to continue.

2. Take a back up of your data. If you do not have a normal automatic back up procedure, you may use the back up data option in the Other Options menu. This must be done before proceeding. You will lose the general ledger data only for the first of the three years you currently have open. You MUST print any reports for the year being removed BEFORE running this routine.
3. Go to the General Ledger Menu.
4. Go to Carry out year end closing?
5. Read the on […]

Finance Charge Calculation

To calculate finance charges the customer’s statement option must be set up as type ‘2’- PRINT STATEMENT WITH FINANCE CHARGE. This is set up in the Accounts Receivable Menu; Add, Update Delete Customers option. Otherwise, there will be either no statement printed, or the statement will not include any finance charge calculations.
Step 1 is to find out how long the invoice has been overdue:
The days overdue for each invoice is computed by counting the numbers of days between the invoice date and the statement date.

e.g. Invoice date is September 24; statement end date is December 31

September 25, 26, 27, 28, 29, 30 6 days

October 1-31 31 days

November 1-30 30 days

December 1-31 31 days

Total 98 days

Next, the net invoice date is subtracted from the 98 days

E.g. The customer terms are 2% 10 Net 30

Therefore 98 days – 30 days is 68 days.

The DAYS OVERDUE is 68 days for that invoice
Step […]

Exporting Data

There are two ways to export data from your company. You can export a report, or the raw data file.
To export any report:
1. Print the report you wish to export to screen. (When prompted to ready printer and press press F9 and then the letter O)
2. Once the report is on screen, press for options.
3. Choose ‘Save reporting ASCII format’
4. You will have three options: 1) Save to a folder on the Linux server, 2) Save to a mounted Windows folder and 3) Save to a folder on this computer. The option that requires no additional set up or additional Windows programs is option 3. The default location to save on the local drive is C:\export, this can be changed to any valid path, but for ease of use, add a folder named export on the Local Disk C of the computer you are working on. As for the […]

Electronic Funds Transfers (EFT) to Vendors

The feature for sending an Electronic Funds Transfer (EFT) to Accounts Payable Vendors allows you to send payments to your vendors directly through your bank account to theirs. This feature is similar in scope to the long available feature for the Canadian Payroll Direct Deposit add-on. We are bringing almost twenty years experience with that add-on in to the Accounts Payable to meet growing demand for the elimination of printing checks and sending them by mail.

There are many benefits to using EFT over sending cheques through the mail. Here are just a few:

– EFT cannot get lost like physical cheque. Whether through the mail or human error a cheque can be lost in many ways. An EFT will either be rejected by the bank, which you will know immediately, or it will go through, no middle ground.

– While there are normally bank charges for sending EFT, these will be a […]