Products-Stock System
 

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.