Introduction
30.01.2023
150

About Leverage, Client/Server Environment and New Features

A. About LEVERAGE Version-4

LEVERAGE Accounting Software Version 4 comes with a new look and features that are more dynamic, more practical, and more interactive than LEVERAGE Version 3.

While maintaining the main characteristics of LEVERAGE which is easy to use (user friendly) and high accuracy, LEVERAGE 4 provides even more features and advantages that will help you run your business even easier and more enjoyable.

LEVERAGE 4 consists of modules packaged in one package, consisting of:

1. Purchase Module (Purchase Module): This module consists of a Purchase Request Form (Purchase Requisition Form), Purchase Order Form (Purchase Order Form), Received Item Form, Purchase Invoice Form, Form Purchase Return (Purchase Return Form) and Purchase Payment Form (Purchase Payment Form).

2. Sales Module: This module consists of Sales Quotation Forms, Sales Order Forms, Sales Invoice Forms, Sales Return Forms and Sales Forms. Sales Receipt Form.

3. Inventory Module: This module consists of a List of Items, an Inventory Adjustment Form, a Job Costing Form, a List of Warehouses, a Form Goods Group (Item Grouping Form), Goods Selling Price Adjustment Form(Set Selling Price Adjustment Form), and Item Transfer Form

4. General Ledger Module: This module consists of a List of Accounts, a List of Currency, Company Information, Journal Voucher Form, Final Process Month (Perid End Process), and Financial Statements (Financial Statement)

5. Cash Bank Module: This module consists of Other Payment Forms, Other Deposit Forms, Bank Books, Bank Reconciliation Forms.

6. Fixed Asset Module: This module consists of a New Fixed Asset Form, a List of Fiscal Fixed Asset Types, a List of Fixed Asset Types ), List of Fixed Assets (Fixed Asset List).

7. RMA Module: (Return Merchandise Authorization Module): this module consists of an RMA Form and an RMA Action Form.

8. Project Module: This module consists of a List of Raw Materials, a List of Project Costs, a Work Price Analysis Form, a Project Form, a Material In Used Form, a Project Survey Form, a Project Bill Form, a Project Ending Form

 

B. Client Server 

Along with the development of computer technology, so does the development of databases follow it. In the mid-1980s, database applications evolved into multi-user. So you don't need to go to where the computer is, you can input data anywhere on a computer that is connected to a network (intranet, LAN, Internet). Together with the database stored on the file server so that everyone on the network can run the same application. At the same time, it can also ensure that data for all users is in sync because there is only one copy of the database stored on the file server.                     

From the application point of view, the database files that are on the file server are as if they were on the local hard drive. If one of the user's computers requires, for example, wants to find item 'TV AA', then the application will search the index file. Based on the information obtained from the index, the application will then show you a place where information about AA TELEVISION can be obtained. If based on index.

If TV AA data is not found, the application will perform a sequential search (reading record by record). This is not only slow, but burdens the network with large network traffic. It was not until the 1990s that the size of databases grew larger and larger computer networks began to revolutionize multi-user database applications, migrating to client/server mode. From the perspective above, the application cannot directly view the database file, only the database server can do it. The application does much less work because there is no need to index the database. The application process is divided into two, between the database server and the local PC as a client.

Database applications in a client/server environment are compared to PCs in a LAN network, where PCs in a LAN network request files from a file server while client/server applications request data from a database server. The client side is an application running on a local PC, while the server side is running on a database server. Each of them is actively carrying out their respective functions.

Following are the reasons why LEVERAGE adopts client/server technology:

 

 Flexibility

Compared to previous desktop database models that force you to use certain tools for certain types of databases. The client/server environment allows you to choose from a variety of suitable tools to provide the solution you need. If you need a complete application, you can use Delphi, Visual Basic or various tools that support database servers. You can use the tools without having to get rid of your old database. LEVERAGE Accounting Software is made from the Delphi programming language.

 

• Reducing Network Traffic

One of the most expensive components in a network system is bandwidth. The more users on a network along with the increasing size of the database, efforts to protect and maintain bandwidth are increasingly complicated. A large group of users who happen to search together from a large database over a network can make the network system HANG. Migrating to a client/server environment will reduce network load because the client PC only sends a request for data while the server only sends the answers that are needed, so not the entire database file is sent.

 

• Capacity

The maximum size of a paradox table is 256 MB. A table in a client/server database is expressed in GB, not MB anymore. Comparison 1GB = 1024MB.

 

• Speed

With large tables, the difference in data search speed will be even more significant. Example: for a search using Paradox on a file server system that takes 2 minutes it only takes less than 20 seconds using a client/server based application.

 

• Scalability

Most database servers can run on multiple platforms (Novell, SCO UNIX, VAX, Sun, Linux, Windows NT) so you can add servers as your needs increase in the future.

 

• Integrity and Security

One of the responsibilities of the MIS/EDP department is to protect company assets. In this case the data is lost or used by unauthorized persons. It is very difficult to do if the data is on each local PC.

On the other hand, users (end users) want to use tools with which they are familiar. Client/server allows both parties (MIS and end users) to fulfill what is desired. End users can use the tools they like to read data, while MIS can back up all data from one place, while limiting who can read and who can change data.

 

• Programmable

The database server is programmable. You can write business rules and program them on the database server so that a general rule doesn't have to be rewritten in every application you build.

 

• Transaction Control

The ability of the database server to update multiple tables simultaneously and ensure that all of them are successfully updated is critical for complex database applications. If one of the tables fails to update, then everything that has been recorded from the last transaction must be canceled and returned to its original position. Only database servers have such capabilities.

 

 

C. New features in LEVERAGE Version-4

LEVERAGE 4 comes with new features that make this application easier to use by all users, both users who understand accounting or users who are unfamiliar with accounting.

Following are the new features in LEVERAGE 4:

1. Memorized Form Input 

 

2. Recording Recurring Transactions

 

3. Tracking history of goods based on serial numbers

 

4. Controlling the stock of goods based on the production batch number or expiration date

 

5. Drill Down dan Analyzing Report 

 

6. Export-Import transactions for companies with many offline branches.

 

7. Base Currency can be in foreign currency

 

8. RMA 

 

9. Project Management 

 

10.Accountant Review 

 

11.Create New Branch 

Was this article helpful?Yes (0)No (0)Thank you for your feedback!