Sage Line 100 utilities - Free to our users
As an accredited Sage developer with over 10 years experience of the Sage Line 100 product we have
developed and market independently our own utilities package for Sage Line 100.
It is a package that has been developed over a number of years by ourselves to accompany and
complement the Sage Line100 and Sage Sovereign accounting packages.
Each utility included within the package has been designed specifically to save processing time
within the accounts department. The package has been designed around a menu system similar to that of
Sage Line100 enabling users to quickly get familiar with the system.
The package is available free of charge for all clients with a Line 100 support contract. It is also
sold separately at the same price as a standard Sage Line 100 module to users support by other Sage
Solution centres.
Each utility is described below by the ledger it runs against.
Nominal Ledger
- Alter Transaction Description - This utility allows the user to change the
description field for a nominal ledger transaction.
- Move a department- This utility allows the user to move all the codes within
a particular department to another cost centre.
- Copy a department’s codes - This utility will copy all of the codes within a
specific department into another department.
- Zero Budgets - This utility will automatically zero the total and monthly budget
figures on every account within the nominal ledger.
- Import Budgets - This utility allows the user to import budget information from an
ASCII file, which may have been extracted from a spreadsheet etc.
- Budget Input - This utility gives the user a very quick data entry screen for entering
budgets.
- P & L accounts unattended - This utility has been designed so that it can be run
overnight or during some other quite time so that all the reports are spooled automatically.
- Balance sheets unattended - This utility will automatically generate all balance
sheet reports required from the system.
- Trial balances unattended - This utility will automatically generate all trial
balances required from the system.
- Compare budgets- This utility will automatically generate all budget variance reports
required from the system.
- Alternative budget report - This report is a simple variation on the standard
Line100 budget report but it does allow various options and shows the
information in a slightly different format.
- Listing of journals This program will reproduce journals by examining the
nominal ledger based on unique reference number.
- Transaction listing - This program provides a listing of transactions between
certain account numbers for a particular accounting month.
- Consolidated listing - This report will provide a summarised list of balances for
each department that are subtotalled by cost centre.
- Consolidated trial balance - This report will print a trial balance with only one
figure for each account number. The figure shown for each account is the
total for that account number across all cost centres and departments.
- Unique ref. check report - This utility will check each transaction in the
nominal ledger and list all transactions where the entries for a unique
reference number do not total zero.
- View control totals - This utility will carry out these reconciliations on screen
and highlight any differences. Furthermore if there are differences it
will ask the user if they wish to print out transactions on the nominal
control account that have not been posted from the normal ledgers. I.e.
normal journals.
- Check NL categories - This utility will run through all the nominal ledger
accounts and set the account type and report category depending on
information given by the user.
- Delete NL accounts - This utility will automatically delete all nominal accounts
where the balance of the account is zero and there are no transactions.
- Delete deferred/current postings - This utility will allow a user to delete
all deferred and current nominal ledger postings with a particular unique
reference number from the postings files.
Cash Book
- Cash flow report - This report will analyse the transactions in a bank account or a
period that can be defined by the user. In addition to showing the cash
flow over the specified period it can also be useful in finding
differences on bank reconciliation's and control accounts.
- Outdated transactions - The purpose of this report is to produce a listing of
all outdated transactions not yet cleared through the cashbook.
Sales Ledger
- Transfer transactions - This utility simplifies this process significantly as
the user simply identifies the transaction and accounts concerned.
- Alter transaction description< - This utility allows the user to amend both
the reference and second reference of a transaction.
- Fully allocate accounts -This utility will automatically allocate all transactions on
an account where the transactions balance to zero.
- Import sales transactions - This utility will import an ASCII file of transactions
into the ledger. The user can specify when running the utility whether the
transactions are of the following types; Invoice, Credit note, Receipts or Payments.
- Import giro bank receipts - This Utility will automatically import transactions from a
diskette and post them through to the correct sales ledger and cashbook accounts.
- Create credit card file - This utility allows the user to create a file of
transactions for a credit card company based on balances on Sales ledger
accounts and post them to the relevant ledgers.
- Create direct debit file - Works in the same manner as the previous utility
- Global account changes - This utility will allow the user to globally change the
following fields held in the ledger accounts: Analysis 1, 2, 3, Default
VAT code, No of months to keep transactions, default nominal account, terms of business and stop
flag.
- Part allocated transactions - This report will list all transactions that are part
allocated by ledger account. It will also produce a sub total for each of these accounts.
- Balance at specified date - This report will produce a list of balances on
accounts as at a specific date.
Purchase Ledger
- Transfer transactions - When a transaction has been posted to the wrong
account in the purchase ledger it can be quite time consuming and error
prone to cancel the transaction and re-enter it onto another account. This
utility simplifies this process significantly as the user simply
identifies the transaction and accounts concerned.
- Alter transaction description - This utility allows the user to amend both
the reference and second reference of a transaction.
- Fully allocate accounts - This utility will automatically allocate all transactions
on an account where the transactions balance to zero.
- Global account changes - This utility will allow the user to change the following
fields held in the ledger accounts; Analysis 1, 2, 3, Default VAT code, No
of months to keep transactions, default nominal account, terms of business and stop flag.
- Part allocated transactions - This report will list all transactions that are part
allocated by ledger account. It will also produce a sub total for each of these accounts.
- Balance at specified date - This report will produce a list of balances on
accounts as at a specific date.
Stock control
- Import/Update Stock records - This utility will read an ASCII file and update the
relevant fields held for a stock record. All of the fields held for a stock record can be
updated.
- Stock explosion - This utility can be used to maintain a file of stock item make-ups. The
utility will also allow the user to make a number of the finished items.
Once a finished item is made the relevant stock levels (both raw and
finished materials) are updated. Transactions will also be posted into the
stock history file so that a full audit trail is maintained.
Accounting manager
- Expand all files - This utility will increase the size of every Line100 file. It will also
create a file if the file does not already exist on the system.
- Index all files - If Line100 data becomes corrupted it is sometimes necessary to index the
data files. Although Line100 has index facilities under its utilities
menus only the main files are indexed. This utility will index every data
file held by Line100.
- Validate all files - Usually if a data file becomes corrupted the only remedy is to
restore from the last backup. This can obviously result in a large amount
of lost work and effort. In some instances the file can be repaired by
this utility.
- Keep transactions for - This utility allows the user to change the number
of months that transactions are kept for on accounts within the nominal,
sales and purchase ledgers.
- Macro recorder - This utility will allow the user to set up macros that can hold up to
twenty keystrokes. This can be very useful if certain repetitive tasks are
run frequently on the system.
|
|
|
|