|
Required
System
The
system software is developed under Microsoft Visual FoxPro 8.0.
The hardware system required to run the software is a Pentium PC
with a minimum of 256 MB RAM.
The written software is color-oriented. A laser printer or a dot
matrix printer of 132 columns(preferably about 270 cps) one is needed
to produce reports.
Please note that the following description of the software system
is based on different modules. All systems have certain number of
features of which we may list the following:
- Management facilities in data entry screens such as creating,
deleting, modifying and searching for entries.
-
All screens have the feature of using the mouse or the arrows and
the ability to open multiple screens at one time.
-
Reports can be produced on printer and screen as well.
Brief
Description of the Software:
This
section describes in brief the features of the software.
General Specifications:
- Integrated.
- Multi company.
- Multi currency.
- User friendly.
- Use of arrow keys to scroll and select options.
- Fully menu driven system.
- High level of security.
Access Control:
- Protection and restriction to the access
of data and operations.
- Unlimited number of users.
- Access restriction according to user's category.
- Password modification is user available.
Stock
System:
-
Codification of Items according to group and sub groups.
- Stock management for unlimited warehouses, each in different companies.
- Input of stock exchange values in local or foreign currencies.
- Stock inventory per warehouse or consolidated.
- Transfer of items.
- Selling price depending on quantity and/or customer's class.
- Price lists.
- Stock value according to different prices.
- landed cost report.
- Daily entry values.
Invoicing
:
- Multi currency invoicing.
- Daily sales values : global and detailed.
Orders :
- Management of supplier's and customer's purchase order.
- Grouping of orders.
- Multiple deliveries.
- Pending purchase orders, customerwise and itemwise.
- Scheduling of payments and integration into cashflow.
- Management of purchase fees.
Aging of Invoices :
- Client invoices.
- Supplier invoices.
Statistics and reports on sales :
- Developped statistics :
. Quantities
. Sales values presented according to the combinaisons between the
following parameters :
.... by supplier
.... by client
.... by item
.... by group and sub-group
.... by saleperson
Detailed Description of the Software:
A.
DATA ENTRY Menu:
1.
ITEM Module:
This module creates all item parameters such as group, subgroup,
supplier, unit measure, etc...
2.
GROUP Module :
It allows the user data such as code and description related to
the group section.
3.
SUB-GROUP Module:
Same as the previous module except that the data entered is related
to the sub-group which is in turn related to specific group.
4.
UNIT MEASURE Module:
It creates the unit measurement that is used in a specific company
such Kilo, Box, Meter, etc...
5.
SUPPLIER Module :
It creates a file in which all information about suppliers are stored.
6.
Currency Module:
This module allows you to input the codes of the different currencies
you may deal with, their descriptions as well as their symbols.
7.
AREA Module:
This module creates the codes of different area.
8.
DISTRICT Module:
This module specifies the various districts located under a certain
area.
9.
CATEGORY Module :
This module is used to classify the company's clients. This is used
later for statistical reports.
10.
SALES CATEGORY Module:
This module creates the type of sales for every customer such as
whole sale and retail.
11.
SALESPERSONS Module:
This module allows you to enter the required data about the salespersons
in the company.
12.
CUSTOMER Module:
This module allows you to enter the required data about the customers
of the company.
13.
DEPARTEMENT Module:
This module differentiates the goods between one warehouse and another.
14.
ITEM TYPE Module:
This module allows you to enter the type of an item such as normal,
with expiry date etc...
15.
CHARGE Module:
This module allows you to enter all charges with their currencies
so they could be used to calculate the landed cost of items.
B.
OPERATIONS Menu:
1.
CURRENCY RATES Module:
This module is needed to enter the currency rates that correspond
to the amount of transactions. These rates are entered on daily
basis.
2.
ORDER Module:
This module allows you to place orders on computers to be compared
with the invoice issued by the supplier.
3.
ENTRY Module:
This module is used to enter quantity and prices, and to calculate
the weighted average cost of the item entered.
4.
OFFER Module:
This module prints out computerized offer based on the description
that the user needs.
5.
DELIVERY NOTE Module:
This module is used to reserve quantity.
6.
INVOICE Module:
This module is used to issue an invoice when goods are sold.
7.
RETURN Module:
This module is used for returned goods.
8.
QUANTITY IN STOCK Module:
This module lists on screen the remaining quantities in stock per
warehouse for a specific items.
9. COST Module:
This module displays the cost ex-factory, the last cost, the weighted
average cost and beginning cost in L.L., $US, and the item currency
for a specific item.
10.
PAYMENTS / RECEIVALBES Module:
This module prints out cash receipts paid by the customer or payment
voucher paid to the supplier.
11.
ASSEMBLING / DISASSEMBLING ITEMS Module:
This module is able to group different items in one item and calculate
automatically the cost of the new item and vice-versa.
12.
ADJUSTMENT OF STOCK (PLUS-MINUS) Module:
This report is used to adjust the company's stock at the end of
every year between the physical stock and the stock on the computer.
13.
INSTALLMENTS Module:
This module is able to generate flat and non-flat rate installments
and directly printed if required.
C.
REPORTS Menu:
1.
QUANTITY & STOCK VALUE Module:
This report lists the quantities of the stock between two given
dates such as starting quantities, quantities in, quantities out,
and balance. An additional feature is that by choosing the 'value'
key, the output will include values of the stock.
2.
CLIENT ITEM SALES Module:
This report outputs the turnover for every client: sales value of
the quantity sold, sales value of the quantity returned and the
balance.
3.
SALESPERSON ITEM SALES Module:
This report outputs the turnover for the salespersons in your company.
4.
TARGET SALES Module:
This report lists the amount that every salesperson should sell
according to a specific target on monthly basis that the marketing
department sets for.
5.
STOCK VALUE Module:
This report prints out quantities and values of all your stock up
to a given date.
6.
SUPPLIER ITEM SALES Module:
This module lists all the stock quantity values related to one or
more specific suppliers.
7.
GENERAL SALES Module:
This report summarizes the stock quantity values in our report per
month on yearly basis. This report can be produced by item, client,
salesperson, group, subgroup, and by any desired combination.
8.
AGING Module:
This report is very essential to the administration . The financial
situation of every client and the amount owed to the company.
9.
SALESPERSON / INVOICES & RETURNS Module:
This report lists for every salespersons the invoices and returns
issued between two given dates along their amounts.
10.
CLIENTs INVOICES & RETURNS Module:
This report lists for every client the invoices and returns issued
between two given dates along their amounts.
11.
EXPIRING DATES Module:
This report prints all existing and/or expected expiring dates of
the available stock.
12.
AUTOMATIC GENERATING SALES PRICES Module:
This program generates automatically the sales prices of certain
commodities based on a given percentage number which could be a
positive or a negative number. This can be applied on the last cost
or weighted average cost.
13.
TOTAL SALES CLIENTS Module:
This report prints a summary of the total amount of sales per client
between two given dates.
14.
TOTAL SALES BY SALESPERSONS Module:
This report prints a summary of the total amount of sales per salesperson
between two given dates.
D. END OF SESSION Menu:
1.
PACK & REINDEX Feature:
This feature reorganizes the data files when
requested. It is very important to use this feature once every a
certain period of time.
2.
BACKUP Feature:
It is very important to store data on tapes
for later use in case of probable damage. You can run this command
directly from the system without quitting.
E.
SYSTEM Menu:
1.
CHANGE COMPANY Module:
By using this module, you can shift from one
company to another. This applies on a company that has under its
wings many other companies. All corresponding files will be open
to the new entering data.
2.
Other Features:
The stock system provides you with the following
additional features:
a.
You may change the system password by using password option.
b. You may run your system in English, Arabic, or French.
e. You may use calculator and calendar directly from the program
without quitting.
|