Oneir Solutions

About jon.w

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

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 […]

Contact Memo and Mgt Note Manual

Relationship Management Features
The Accounts Receivable and Account Payable have a relation management component that will allow you to attach general memos and contact notes to a customer or vendor. The general memos are accessed using the F11 key. The detailed contact notes are accessed using the F12 key. The customer information can be accessed through either the Accounts Receivable or Sales Order Modules. Vendor information can be accessed through the Accounts Payable module. Recent releases have added the general memo capability to both Inventory items and Payroll employees.
Using the Memo Pad (F11 notes)
Use the key to document and look up permanent notes related to your customers, vendors, employees and inventory items. These permanent notes would normally be things that would be fairly static and you wish to refer back to on a regular basis. Some examples would be e-mail addresses or additional contact names with their position within a company. […]

Balancing Accounts Receivable to General Ledger

To balance the Accounts Receivable sub-ledger to the General Ledger Control Accounts is fairly simple, but may require some manual calculation. Normally there will be no difference between the two totals. To arrive at the balanced totals there are two methods.

Both methods require that you determine whether you are using a separate General Ledger account for deposits taken from customers or not. If you are unsure of your company’s set up, you can find out by following the steps below.

1. Go to the General Ledger Menu.
2. Select ‘Set up special accounts’
3. On the first screen note the account number entered on the line for Accounts Receivable.
4. Proceed to page 2 and then note the account number entered on the line for Deposits from customer.

If the account number from 3 and 4 are the same, then deposits and receivables are posting to the same account. If the account numbers […]

“Meat” The Best in Smokehouse Technology

Five “must-have” features food producers should demand from their business software

The reality of the day is that food producers must not only maintain a strong defense against recalls, but also against increasing regulations, food sensitivities in the population, environmental consciousness and PETA agendas. All this squeezed against tighter operating margins brought on by extreme weather changes and ever-mounting business fees and taxes. Many famous food industry names populate the FDA and USDA’s “rap sheet” of food producers who have been required to issue a recall of possibly contaminated foods.

Surviving and prospering now requires excruciatingly tight control of all aspects of food production from the acquisition of ingredients all the way to delivery of the food product to the consumer. Legacy stand-alone systems for processing, inventory control, sales and accounting simply cannot keep up.

“What’s been done in the past is no longer good enough,” says Jon Mainwaring, executive vice president of […]