Français

         Lumber Management System Inc.

 
Financial issues... For reliable, complete and  integrated financial management in an IBM iSeries environment!

Financial  Statements Generator (GEF)

A simple relational  spreadsheet integrated into your environment

Until now, when you  produced financial reports and conducted analysis you had to devote a great deal  of time to manually transferring your ledger data to the desktop computer, and  once you were done, your data were no longer up to date.

LMS™  integrated solution is all you need. The GEF relational spreadsheet enables you  to save precious time because it is linked to your iSeries applications. With  GEF, you’ll be able to produce reports and perform customized analysis with data  taken directly from your iSeries environment. You will be astonished by the  simplicity of GEF and the optimal results produced with its commands and  functions. This solution also handles multiple companies and comes with complete  documentation.

The GEF relational spreadsheet goes hand in hand with the  AS/PECT report generator. This software is made for designing personalized  reports for your entire AS/400 database.
 

An Integrated  Solution
 

• GEF is  easy to use and similar to better known commercial spreadsheets on the market.  It is an open window on your iSeries environment. Its linking functions provide  instant access in real time to your ledger and other databases such as sales,  production and budget modules. Finally, a powerful tool that works with your  applications.

The Right  Time at Any Time
 

• With a  dynamic design, GEF is linked to your accounting schedule so that it is  constantly updating the contents of your calculation sheets. It can also present  information calculated for different accounting periods.

Customized  Reports
 

• You can  customize your calculation sheets according to the presentation requirements.  GEF has editing and layout functions and links up to an iSeries word  processor.

Purchasing  and Inventory Module

The Purchasing and  Inventory module electronically manages the routing of requisitions and has them  approved electronically. The purchaser can order easily and have absolute  control over each phase of the order. Inventory management controls the supply  process, maintenance and perpetual stocking of inventory, distribution of costs  to the purchaser and product consumption analyses.

Advantages  Gained Through the Design of the Purchasing and Inventory Module

Secured Access

• Management of  authorizations segments tasks to ensure information remains confidential. Each  user working in the system can be assigned specific tasks (specific menus and  access to specific files).

On-line  Help

• Users can  access on-line help.

Prompt Windows

• There are  several prompt windows to facilitate searches for information or selection of  available parameters.

RPG/400  Native

• This module was  developed in RPG/400 language for optimal use with iSeries resources.

Use of Bar  Codes

• Printing  of bar codes for physical stock taking.

Selective  Catalogue Printing

• Printing  of the product and services catalogue can be defined for the following  criteria:
• product  category;
   
• sub-category;
   
• product  number.
   

Electronic Routing  of Requisitions

• The entire  requisition process is electronic. Every step of the requisition process can be  completed at the work stations with no need for printed approvals of  requisitions, orders, etc., at any time. In addition, the iSeries communication  features can incorporate a fax for transmission of orders to clients.

Electronic  Approval

• With  secured access, this function ensures the requisition is complete by validating  the availability of funds and exclusions to the process along with order taking  and inventory transactions.

Management of  Pre-Committed Funds

• During the  approval process, funds are pre-committed interactively so the next requisition  will take into account those amounts already committed.

Possibility of  Searching Requisitioned Products via Several Fields

• Products  and services can be searched via several data fields :
• by  category, sub-category;
   
• by French  or English abbreviation;
   
• by  supplier’s product code;
   
• by grouped  product codes.
   

Two Types of  Manual Requisitions

• The system  can control the numbering of requisitions or track the user of a pre-printed  sequence.

Automatic  Requisitioning of Material

• A  requisition is automatically generated when the order level is reached. This  ensures the quantities to order and the amounts available remain  balanced.

Easy Supplier  Searches

• Access to  the list of suppliers and their respective files.

Various Modes of  Filing Products

• The  products in stock can be filed by:
• category;
   
• location;
   
• quantity  on consignment;
   
• quantity  on order.
   

Several  Locations

• The system  can use several locations:
• warehouse;
   
• room;
   
• alley;
   
• row;
   
• shelf;
   
• section.
   

Management of  Financial Availability

• Auditing  of financial availability and assignment of costs to budget codes at output are  managed by the Purchasing and Inventory module.

Batch Ordering  Characteristics

• The system  can create a purchase order in two ways:
• from a  requisition;
   
• from a  list of approved unordered requisitioned products for a potential selected  supplier.
  
   
• The system  executes:
• management  of taxes (federal and provincial) and other fees (ex. customs and  transportation);
   
• release of  funds committed during requisitioning;
   
• commitment  of amounts specified in the order.
   

Control of Product  Receiving

• Upon  reception of products and services, the delivery notice for an order is entered  in the system.
  
   
• Surplus  products/services received will result in the issuing of an additional  requisition for approval of the assignment.
  
   
• If the  product is in stock :
• the  location will be assigned and the quantities will be adjusted;
   
• the  average weighted price excluding GST will be  calculated.
   

Theoretical or  Physical Inventory

• Two  components to managing inventory:
• theoretical;
   
• physical.
  
   
• The system  manages gaps in the quantities theoretically in inventory and physically in  inventory, by location and/or product.
  
   
• The  history log of stock movements is available by period, product and category for  both inventory management components (theoretical and  physical).
   

Calculation of the  Value of Inventory

• The value  of each product in inventory is automatically calculated at the average weighted  price, without GST. The GST will be calculated for redistribution to other  assignments when taken out of inventory.

Ledger

The Ledger module  efficiently manages accounting processing according to any transactions  generated by other modules of the financial system (supplier accounts, client  accounts, payroll, purchasing management, etc.). This module is the spearhead of  the financial system because this is where nomenclature is defined, entries are  processed and periodic or annual closings are run. Data transmitted to the  ledger module can be used to issue reports with the financial report generator.

The architecture of  the Ledger module provides a very flexible means of arranging the accounting  system. Each account in the nomenclature can be associated with appendix lines  used to define financial reports. This makes it possible create various  documents analyzing accounting data in addition to the standard financial  statements. The module has another uncommon feature: printing of such documents  as the audit balance or accounting documents, even when the financial period is  not over.

The Ledger module respects established accounting principles  and generates reports on:
 

• transactions before accounting  processing;
  
   
• processed  entries;
  
   
• accounting  journals;
  
   
• the  auditing balance.
   

Finally, ledger  data can be reviewed on screen or on paper:

• querying  of accounts in several formats (comparison with a previous year, the budget,  link with appendix lines corresponding to financial reports, account  analysis);
  
   
• printing  of one or more accounts in the nomenclature;
  
   
• printing  of account analysis.
   

Incalculable  Advantages
 

• Managing  accounting for several firms and issuing consolidated reports.
  
   
• Processing  foreign currencies.
  
   
• Associating a project number  with an accounting entry in order to monitor project costs.
  
   
• Entering  the budget for each account in the nomenclature.
  
   
• At closing  for the financial period, automatic transfer of the years data to the previous  year (possibility of entering data for the previous year during installation of  the Ledger module).
  
   
• Querying  data on screen.
  
   
• Integrating other modules of  the financial system at any time.
  
   
• Reviewing  interactive documentation at anytime.
  
   
• Constant  technical support.
   

Financial  Report Generator

The Financial report  generator prints financial statements and various other accounting reports  requested by the user. This module has 7 appendices, each with 9999 lines,  giving an imposing range of options for defining reports. Once the module has  received the parameters used to define the report, it can calculate sums,  compile data and print the statement.

Developing financial reports from  the appendices enables the user to obtain the usual financial reports and  various reports covering sporadic needs. The Financial report generator module  can capture all amounts in ledger accounts or the appendices. The manufacturing  cost can be incorporated into reports, and the module can determine percentages  based on two appendix lines.

Users can also define the type of  comparison to be used in the report: current period and current year, current  year and previous year, budget, etc.
 

Incalculable  Advantages

• Generating  accounting reports and financial statements for multiple  companies.
  
   
• Generating  consolidated statements covering all companies within the system.
  
   
• Interrupting  appendix data.
  
   
• Using financial data  from the ledger or the appendices.
  
   
• Printing reports and  financial statements at any time, even if the accounting period is not  over.
  
   
• Defining new reports  at any time.
  
   
• Modifying data used  in reports.
  
   
• Reviewing  interactive documentation at anytime.
  
   
• Constant technical  support.
   

Accounts  Payable Module

The Accounts payable  module efficiently manages processing of supplier accounts. The module comprises  a folder of supplier files known as master files and the accounts payable file  itself, which contains information about invoicing and management of  payments.

In accordance with established accounting principles, the  module provides control documents:
 

• a control report  generated during entry of invoices for validation of entries before  processing;
  
   
• a list of checks  generated during payment of invoices.
   

The module also  prints various documents on:

• suppliers: supplier  files, lists of suppliers, statistics, labels with supplier  names;
  
   
• accounts payable:  list of transactions and distribution, list of purged accounts payable, history  log of accounts payable (also contains payments), age of accounts,  etc.
   

The module offers  data review capabilities both on screen and on paper: supplier data, invoice  file, payment file, etc.

Incalculable  Advantages

• Managing  accounts payable for multiple companies.
  
   
• Processing  foreign currencies.
  
   
• Automatically generating  invoice payments according to a user-defined schedule.
  
   
• Associating a project number  with a supplier account to monitor project costs.
  
   
• Managing  issuing of cheques from several bank accounts (multiple account  system).
  
   
• Interrupting supplier and  accounts payable data on screen.
  
   
• Transmitting financial data to  the ledger (this module must be installed) following processing of accounts  payable.
  
   
• Reviewing  interactive documentation at anytime.
  
   
• Constant  technical support.
   

Accounts  Receivable Module

The Accounts receivable  module efficiently manages processing of client accounts. The module’s client  files are known as master files. The accounts receivable folder contains  information about invoices and management of received payments.

In  accordance with established accounting principles, the module provides various  documents:
 

• a control report  generated during entry of received payments for validation of entries before  processing;
  
   
• the management of  the client’s credit file.
   

The module also  prints various documents on:

• clients: client  files, lists of clients, statistics, labels with client names, client credit  files, etc.;
  
   
• accounts receivable:  list of transactions and distribution, list of purged accounts receivable,  history log of accounts payable (also contains payments), age of accounts,  etc.
   

The module offers  data review capabilities both on screen and on paper: client data, payment file,  etc.

Incalculable  Advantages
 

• Managing  accounts receivable for multiple companies.
  
   
• Processing  foreign currencies.
  
   
• Associating a project number  with a client account to monitor project payments.
  
   
• Interrupting client and  accounts receivable data on screen.
  
   
• Transmitting financial data to  the ledger (this module must be installed) following processing of accounts  receivable.
  
   
• Reviewing  interactive documentation at anytime.
  
   
• Constant  technical support.