Dnyandeep Software Projects - 5

5. Inventory and Accounts of Universal Controls, Sangli

UNIVERSAL CONTROLS is a registered small scale unit  in Vasantdada Industrial Estate at Sangli, for manufacturing products related to agriculture which will help farmers.  These include Three Phase Auto Switch, Starter, Digital Timers, Single Phase Submersible Panel, Three Phase Control Panel, Water Level Controller, Run Capacitors, Start Capacitors, Unicon U. P. S. Inverter, Electronics Weighing Scale etc.

The software was developed to cover purchase of raw materials, sale of products , stock inventory,  and financial accounts of the factory

 A) Purchase of raw materials –  This included database operations for Purchase parties, Raw material categories, Raw items specifications, Raw item Stock register, outward raw material registers

 B)Stock Inventory

Stock of Raw Materials,  Items locked up in production stage, Stock of products for sale

C) Sale of Products– This included database operations for Sale parties, Product categories, Product items specification, Product Stock Register    

   Provision was made to  display  list of customers ( material suppliers, and sale parties), to add new customers or modify the list.

Transactions of purchase and sale were recorded from payment and receipt vouchers.

Payment vouchers –

a) Entries of cash/bank payments for purchases

b) Entries for other expenses by cash/bank 

Receipt vouchers –

Entries for sales by cash/bank 

Entries for other income by cash/bank

Books of account – Facility was provided to display and print Daybook, Ledger Book, Cash and Bank books, Income & Expenditure, Profit &  Loss Statements

Reports – Various reports are generated to view Ledger statement, Trial Balance, Balance sheet, Stock inventory for any time period.

The software was operated and updated for two years with backup, carryover of accounts and stock .