SUPPLIES INVENTORY SYSTEM WITH ICS RECORDING (SIS-ICS)
FEATURES OF THE SYSTEM
- User Friendly VB.NET IN MYSQL DATABASE SIS which is customized for the General Services Office and the City Accounting Office in the Local Government operations in accordance with RA 7160 and COA Circular 92-386;
- The SIS could be connected to LAN or multiple computers using HUB/Routers which shall run in server and terminal mode;
- The SIS electronically records bulk quantities of delivered items for warehousing or direct issuances to be distributed to identified offices;
- The SIS accepts the maximum ceiling of allotment per office and controls the issuance of items based on the quarterly allocated budget;
- It also records the distribution of delivered items per office based on allocated stocks on PPMP;
- The system controls the issuance of the items on a FIFO scheme in order to arrive at an accurate computations for the Accounting office to book the balance of stocks and the generation of report of the utilized items per office;
- The SIS allows the issuance of the items based on expiration period or items that are first delivered as the user’s option;
- It also records the issuance of stocks to every office, name of recipients, quantity, date of issuance, RIS no. and reflects its corresponding remaining balance;
- The system can record monthly, quarterly, annually or any given period the quantity balance of stocks per item, per office and the whole stocks;
- It can report all items consumed per office at a given period;
- It can report the list of items, quantity and the cost delivered by a particular supplier for monitoring purpose;
- It automatically records the real time balance of stocks and ending report of the year and shall automatically be treated as beginning balance in the ensuing year;
- The system allows return of stocks in case of damage or expired items to be removed from the inventory;
- It can produce report on summary of supplies for all offices;
- It can automatically generate the accomplished issuance forms for signature of the recipient;
- It can automatically generate reports on summary of supplies issued per office;
- It can automatically generate reports on summary of supplies issued by office per item;
- It can automatically generate reports on Grand Summary of all delivered and issued item of all offices;
- It automatically reflect the remaining balance of every item while encoding the stocks added as delivery;
- Per COA Circular 2005-002, ICS is recorded per End-user for the monitoring of usage of Semi-Expendable supplies;
- ICS report system that could be printed employee to reveal accountabilities;
- Supplies are classified into ICS (Semi-Expendable items and Disposable items (RIS);
- ICS Report System that could be printed on selected start-date to end-date;
- Data Inquiry System to determine the ICS accounted per individual employee as reference for the issuance of the next semi-expendable items.
- The system can generate ICS report per Department, Accountable, and Status.
- Automated Generation of ICS for signature of the Accountable Officer;
- Spareparts listed in the maintenance of PPE are also encoded to the SIS classified as expendable and semi expendable items;
- It has transfer feature for ICS accounted to employees whether temporary or permanent;
- The SIS can precisely reduce the processing time down to 75% compared to manual and it lessens the work load of the stocks officer/supply officer so they can do more;
- The SIS is connected to the GSO, ACCOUNTING OFFICE, MAYOR’S OFFICE and if requested, it may be connected to the COA as terminal mode.