Point of Sale and Inventory System

con Title file of cut-rate sales event remains for tilt master Enterprise Researchers Serolf, Jham Year 2013 Course calculator Science Technology Adviser CHAPTER 1 THE PROBLEM AND ITS BACKGROUND 1. 1 Introduction Man scram come a long way in doing short letter transactions with all(prenominal) opposite. From the primitive slipway of exchanging goods or barter system, to the to a greater extent complex e-commerce or doing business transactions with the help of the internet. With technology rapidly changing and upgrading every now and whence, companies must adopt to be able to excel in each businesses cut-throat competition.Automation of ones institutionalize of exchange and inventory system puts you a step leading in the game. It helps you conduct business transactions with ease as you only have to press a few keys. It liberates you from lookless news report carrys as computation of the days sale and memory track of inventory be done automatically. With these th ings in mind, we, the blue angel bear on Technology group , hopes that upon apogee of this proposed Point of cut-rate sale and schedule break throughment, treasure nonrecreational Enterprise will find it of great prize and an indispensable asset in the company.That done the use of this carcass, unnecessary loss of clock m spent on computation of payments will be aspersed and greater client satisfaction will be achieved. On the part of the management, discerning which products be in lack of procurement and which are not, will help ward off over stocking and greatly minimize unnecessary expenses. At the end of the day, all transactions will be properly documented and generation of reports will just be a few keystrokes away.Finally, we hope that with the suppuration of the said governance, we will be able to help Stone professional person Enterprise live a company more than competitive and quality wise, worthy of recognition in the local industry. 1. 2 land and purpose of the cin one caseive Most companies nowadays use computers in transacting with their clients. Companies are now making their systems computerized because victimization a computerized system will help the company minimize the time and apparent motions consumed by using manual(a) system.Stone professional person Enterprise provide not only cleaning services for your natural stones flooring, and as well as offer liberal variety of floor care supplies and products. A sale refers to the exchange of product or services for an centre of money or its equivalent while Inventory in a business, is a total amount of goods and the act of counting them. A company testifyer must know the particular number of concomitants in their storage areas in effect to place orders and control losses. figurerizing both Sales and Inventory System will make an easier and tenderer transaction with the customers as well as monitoring the stocks of the products.The reach of Point of Sale w ith Inventory system is that this system makes a business ofttimes more efficient, laborious the be of running the business while improving customer service and making the business more enjoyable to work in while Computerized inventory system helps management control the inventories, in tour of duty lowering overall operating costs in the areas of labor, facilities and logistics. A computerized inventory system also improves customer-service inflection and fulfillment rates. 1. 3 Theoretical Framework The composition is for Stone Pro Enterprise by using Visual Basic that were relatively easy to learn and use.The seek workers were able to analyze the speed properties. Analyzing the point of sale design and work out it is important because the study needs to have a quality for the transaction to be accepted and a good imitator of transaction. The study use IPO chart on knowing the output of the study. The input will be a design and code. The input will pass through several p rocess. These are the speed of transaction. 1. 4 Conceptual Framework view 1 Research prototype Point of Sale System Stone Pro Enterprise 1. 5 Statement of the Problem Stone Pro Enterprise System requires some computer literacy on the user part.Its not trivial enthronement in time or money to set up. If the user doesnt have basic knowledge then the technical requirements of this POS system may baffle him. Ignoring normal practices the this POS system will confound and frustrate each user. The whole subject of this system is for the user to follow the rules, learn accounting terminology and become more disciplined. If this will be practice, then this POS system jackpot bring a tremendous advantages. 1. 6 conjecture This study is intended to design and develop a Computerized Point of Sale System for Stone Pro Enterprise 2013. Specifically, this study aims . To minimize the effort of the staff in in bear on the on inventorying Inventory 2. To make an efficient and accurate comp utation of exchange Registry 3. To bring about a well-arranged entropybase and to utensil strong security of the system for data security. 1. 7 Significance of the theatre of operations To Admin Department The proposed system will help the admin section of Stuff the Buss School Supplies. It will help to lessen the time and effort of the payroll maker/bookkeeper preparing payments of employees. The System develop can accommodate changing figures and produce a paperless purlieu through well design database.To Proponents This study will help the proponents to enhance the ability on how to create an understandable computerized system in an easy way. This will serve to the proponents as a challenge to do a better system. To the separate Researcher This study gives knowledge to the researcher on how to create a Computerized System in understandable way. This will serve as a fresh ground for the researcher whose study will be related in the field of study Technology. 1. 8 Scope an d limit point Scope This study is designed to develop a Computerized Point of Sale System for Stone Pro enterprise.It covers the process of preparing the on stock inventory record, keeping of bullion registry records safety and computing the accept up play(a) revenue. The proposed computerized Point of Sale System is expected to generate receipts and report list of daily and monthly revenue. Limitation The proposed Computerized Point of Sale System for Stone Pro Enterprise does not oblige network topology implementation and online syllabus or online transaction. 1. 7 Definition of Terms Point of Sale orcheckoutis the place where a transaction occurs in exchange for goods or services.The point of sale often refers to the bodily electronic exchange register or dedicated POS hardware employ for checkout, but the POS is simply the location where the sale is conducted, money changes haves and a receipt is given. Transaction an check up onment, communication, or relocation carried out between a buyer and a seller to exchange an asset for payment. Cash take is a mechanical or electronic device for calculating and recording sales transactions, and an attached funds draughtsmanfor storing cash in. The cash register also normally prints areceiptfor the customer.Inventory Control System is a process for managing and locating objects or materials. Computer Software is a collection ofcomputer designsand relateddatathat provides the instructions for telling acomputerwhat to do and how to do it. Computer ironware equals the collection of physical elements that comprise acomputersystem. Computer System A complete, workingcomputer. Computer systems will intromit the computer along with anysoftwareandperipheral devicesthat are necessary to make the computer routine Program is a sequence ofinstructionswritten to perform a specified task with acomputer.CHAPTER 2 REVIEW OF THE RELATED LITERATURE 2. 1. Foreign Literature Over the years, more enhancements were made to the cash registers until the early 1970s, when the first computer- moiln cash registers were introduced. The first computer-driven cash registers were basically a mainframe computer incase as a store controller that could control certain registers. These point of sale systems were the first to commercially utilize client-server technology, peer-to-peer communications, Local Area Network (LAN) backups, and remote initialization.In the late 1980s, retail software base on PC technology began to make its way into mainstream retail businesses. Today, retail point of sale systems are lite years in the lead of where they began. Todays POS systems are faster, more secure, and more reliable than their predecessors, and allow retailers to operate every scene of their business with a single, integrated point of sale system. Since computer power was the critical resource, efficiency of processing became the main goal. Emphasis was placed on automating quick process such as pu rchasing or paying, often within single department as indicated by Jeffrey A.Hofer on Modern System compend and Design (1996). Points of sale (POS) systems are electronic systems that provide businesses with the capability to retain and analyze a wide variety of inventory and transaction data on a continuous basis. POS systems have been touted as semiprecious tools for a wide variety of business purposes, including refining tar bring in marketing strategies tracking provider purchases ascertain customer purchasing patterns analyzing sales (on a daily, monthly, or annual basis) of each inventory item, department, or supplier and creating reports for use in making purchases, reorders, etc.Basic points of sale systems underwayly in use include standalone electronic cash registers, also known as ECRs ECR-based network systems and controller-based systems. Today, point of sale systems are light years ahead of where they began. Todays POS systems are faster, more secure, and more reli able than their predecessors, and allow retailers to operate every facet of their business with a single, integrated point of sale system. 2. 2 Local Literature Computers began from a wild imaginative idea to the worlds highly prioritized tool.Computers today are now apply as a support to manual processes and other past inventions like the radio, television, etc. It is now used by plurality for much simpler, easier and faster way to do things. Some used it as a hobby, and some use it as a job. Technology has never stopped from advancing through the years. Its new innovations helps answer the peoples further complex questions. Why not use these advantages to benefit ourselves? Many people use computers in their daily lives.Some use it for transactions, some use it for educational purposes and others use it for data storage. Though it might impenetrable unnecessary but in some cases when storing a file for such a big company, can you manage it properly? Organizing, finding a file, etc. With computers, it can help you simplify the process of storing and managing the files you need for future use and make finding files easier than the manual process. With our proposed Point of Sales and Inventory System In business like Stone Pro Enterprise , Sales and Inventory system plays an important role.It is used to track all the transactions made by the business and responsible for monitoring the items supplies. All the business transactions must be properly recorded and must be fully secured by password. A Computerized system is the best solution and most innovative answer for their needs. The researchers had been motivated to do a study on this topic according to the above observation. The result may help others to understand more about computer-generated data processing, especially on how to deal with computers in terms of speed, accuracy and data security. 2. Related Studies In exploration, we find new techniques, new knowledge, even develop new substances, gadgets , equipment, processes or procedures, imagination and skill is sedulous by the researcher. The commodities, new devices, services, in technology are needs of man for a better instinct(predicate) life which is the concern of the research. These useful arts are the products of the technological environment and the end-user is society in general. The fast growing trend and innovation in technologies today prompts researchers to conduct studies about the efficiency of system program.This Chapter presents a brief re take hold of of literature and studies, both local and foreign that is related to these studies. 2. 4 Foreign Studies 2. 5 Local Studies 2. 6 Synthesis CHAPTER 3 RESEARCH METHODOLOGY This chapter outline the research methodology of this study. The research was conducted in six phases and the research methodology will be discussed under several phases research design, stage setting of the study, subject of the study, source data, hardware and software requirements and sta tistical treatment to be use to come up with an effective proposal. . 1 Research Design The descriptive method of research was used for this study. To define the descriptive type of research, Creswell (1994) stated that the descriptive method of research is to gather information about the present existing condition. The emphasis is on describing rather than on judging or interpreting. The aim of descriptive research is to command formulated hypotheses that refer to the present situation in order to elucidate it. The descriptive begin is quick and practical in terms of the financial aspect.Moreover, this method allows a flexible approach, thus, when important new issues and questions modernise during the duration of the study, further investigation may be conducted. Descriptive research on the other hand is a type of research that is mainly concerned with describing the nature or condition and the degree in detail of the present situation. This method is used to describe the natur e of a situation, as it exists at the time of the study and to explore the cause/s of particular a phenomenon. The aim of descriptive research is to have got an accurate profile of the people, events or situations.With this research type, it is essential that the researcher already has a clear view or picture of the phenomena being investigated before the data collection procedure is carried out. The researcher used this attractive of research to obtain first hand data from the respondents so as to formulate rational and hearty conclusions and recommendations for the study. The descriptive approach is quick and practical in terms of the financial aspect. 3. 3 cuneusject of the Study A Point of Sale (POS ) System is asystemfor managing the sales of retail goods.The term is used to refer to the software and hardware associated with check out stands, and all of the bundled features which are included. Most retailers use a POSsystemat their check stands or tabulators, and several m ajor manufacturers offer POS systems designed for sundry(a) types of businesses, ranging from foodstuff stores to clothing boutiques. Using a POSsystemmakes a business much more efficient, lowering the costs of running the business while improving customer serviceand making the business more pleasant to work in.In the retail trade, the pointofsale is the moment when a customer walks up to a counter with goods and prepares to purchase them. A POSsystemhandles the transaction, whether it takes the form of anadding machineand a hand written receipt pad, or a complex computer system. Except in the case of very small businesses, a current POSsystemusually takes the form of a computersystem. 3. 4 Sources of the Study Our source data is split up into 2 groups, namely the source data based on direct observation and data sources based on substantiative observations. . ) Source of data based on direct observation, among others Conductingfield studies, it was held at the time we worked at a company engaged in the field of office equipment. Observation of the market to mend market prices. Discussion fellow colleagues, college friends and group member . 2. ) Source of data based on indirect observations Searchingthe internet. Lecture notes Visual Basic Handbook 3. 5 Procedure of the Study We made our own questionnaire for our study to know the outcome of Point of Sale System. so we distribute it to our respondents after they answer the question we tallied and get the average of the verbal interpretation. 3. 6 Project Design pic pic 3. 7 System immix Chart pic Figure 2 System Flowchart 4. 5 System Algorithm Our computerized system allows business owners to track sales, cash flow and item inventory. This system will also calculate the total of all the items that have been purchased. It will realise not only that the items has been calculated accurately but it will also eliminate the chance of a improper price being entered.It help retrieved purchase history, ite m sales detail, stock positioning reports, monthly, yearly, and seasonal sales data. Also this will prevent theft and also help to maintain a record of what is being sold. This will also help to monitor the employees. It will generate and print superior looking receipts. 3. 9 Hardware and Software Requirements The Point of Sale System by Blue Link Technology is the software which will be used. The operating or the platform that will be exhalation to use is Windows XP, Visual Basic 6. 0 as the front end and Microsoft Access 2007 as the database. Hardware minimum requirements Intel Pentium 3 3. Ghz with 512mb RAM. 600 x 800 sieve. 3. 10 Statistical Treatment selective informationbase The united collection of data, usually stored in one computer file in one location, although databases can encompass information from legion(predicate) sources and locations. drop reductions to a basic price of goods or services Frequency Count This is the most straight-forward approach to workin g with quantitative data. Items are classified according to a particular scheme and an arithmeticalal count is made of the number of items (ortokens) within the text which belong to each classification (ortype) in the scheme.Percentage A componentorratiowith 100 as the fixed and understood denominator. Weighted Mean is similar to anarithmetic mean(the most common type ofaverage), where instead of each of the data points contributing equally to the net average, some data points contribute more than others. The notion of weighted mean plays a role indescriptive statisticsand also occurs in a more general form in several other areas of mathematics. Tender In business, a term synonymous with payment or type of payment. CHAPTER 4 intromission ANALYSIS AND INTERPRETATION OF DATAIn this chapter states the take of acceptability of the essential system, the significant difference on the perception of the respondents to the developed system, development of the system, program flowchart , program algorithm, program listing, program output and user manual. 4. 1 The level of acceptableness of the developed system Questions Cashier Employee of Stuff the Weighted Mean Verbal Interpretation Bus 1.The point of sales system is easy to handle? 3 1. 5 2. 25 Uncertain 2. The computation of the amount price is accurate in 3. 5 3 3. 25 go over the Point of Sale System? 3. The point of sales System can maximize the 3. 5 4. 4 Agree productivity of the cashiers work? 4.The Point of Sales System is used efficiently among 4. 5 2. 5 3. 5 Agree various stores? 5. Do you think Point of Sale System can help to your 5 2. 3. 75 Agree company? Average Weighted Mean 3. 9 2. 8 3. 35 Agree delay 3Computation of the level of acceptability of the developed system Question 1 shows that among 20 respondents uncertain that Point of Sale System is easy to handle, because of the weighted mean of 2. 25. Question 2 shows that among 20 respondents with the weighted mean of 3. 25. This simply fashion that respondents agree that the computation of the amount price is accurate in the Point of Sale System. Question 3 shows that among 20 respondents with the weighted mean of 4. 0. This shows that most of the respondents agree that the Point of Sale System can maximize the productivity of the cashiers works.Question 4 shows that among 20 respondents with the weighted mean of 3. 5. This shows that the most respondents agree that the Point of Sales System was used efficiently among various stores. Question 5 shows that among 20 respondents with the weighted mean of 3. 75. This shows the most of the respondents agree that the Point of Sale System can help to their company. Based on the table most of the respondents hold because of the average weighted mean of 3. 35 which falls on Agree Verbal Interpretation. 4. 2 The meaning Difference of the Perception of the Respondents to the Developed System Respondents DistributionThe population consists of 20 persons where 50% of the respondents are cashiers and the employee of Stone Pro Enterprise. Respondents Quality Percentage Cashiers 10 50% Customers 10 50% Table 1 Respondent Table Opinion Index The researchers will use questionnaires with the opinion index below to scale the effectiveness of the study of the respondents. Some questions have options and some are needed to be evaluated and answerable by number with agree verbal interpretation. ( see table 2 ). Scale Range Verbal Interpretation 5 4. 01 5. 00 strongly Agree 4 3. 01 4. 00 Agree 3 2. 01 3. 00 Uncertain 2 1. 01 2. 00 disagree 1 0. 01 1. 00 Strongly Disagree Table 2 Option Index 4. 3 Development of the System pic pic pic pic pic pic pic pic pic pic pic 4. 4 Program Flow Chart pic pic pic pic pic pic pic 4. 5 Program Algorithm Our computerized system allows business owners to track sales, cash flow and item inventory. This system wil l also calculate the total of all the items that have been purchased. It will ensure not only that the items has been calculated accurately but it will also eliminate the chance of a wrong price being entered. Also this will prevent theft and also help to maintain a record of what is being sold. This will also help to monitor the employees. It will generate and print professional looking receipts. 4. 6 Program Listing A.Member Log In Option Explicit occult stand in cmdClose_Click() If Me. cmdClose. fable = Close thus Dim suffice reaction = MsgBox(Do you realy want to let go of this program? , vbYesNo + vbQuestion, realise Quit) If reply = vbYes whence oddity fetch up If Else Unload Me hold back If finis champion hidden gun for hire cmdOk_Click() Me. Ado exploiter. freshen up If Me. cmdClose. Caption = Close then Me. AdoUser. Recordset. honor (UserName = & txtUser. text edition & ) If Me. txtnews. schoolbook = Me. AdoUser. Recordset. Fields(Password) Then If Me. AdoUser. Recordset. Fields(Previledge) = Admin Then mdi principal(prenominal). mnuItems. Enabled = True mdiMain. tbMain. Panels(2). schoolbook = Me. AdoUser. Recordset. Fields(UserName) frmSplash. Show mdiMain. Show balance If If Me. AdoUser. Recordset. Fields(Previledge) = User Then mdiMain. mnuItems. Enabled = off mdiMain. mnuUser. Enabled = morose mdiMain. mnuCustomers. Enabled = inconclusive mdiMain. mnuSuppliers. Enabled = False mdiMain. Toolbar1. Buttons(11). Enabled = False mdiMain. stbMain. Panels(2). schoolbook = Me. AdoUser. Recordset. Fields(UserName) Unload Me mdiMain. Show blockade If Unload Me Else MsgBox handicap Password , vbExclamation, Invalid Password Me. txtPassword. SetFocus Me. txtPassword = terminate If annihilate If culmination replace cloak-and-dagger hacek Form_Load() On erroneous belief recruit Next impose SQLDB(AdoUser, spot * from UserAccount) AdoUser. polish up txtUser. schoolbook = Admin close champion Private crampfish txtPassw ord_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then cmdOk_Click cmdAccess_Click eat up If final stage change Private hired gun txtUser_Click(Area As Integer) On Error Resume Next Dim temp Me. AdoUser. Recordset. Find (UserName = & txtUser. text edition & ) temp = Me. AdoUser. Recordset. Fields(1) End grinder B. Main Page Private wedge shape MDIForm_Load() With stbMain ensures all panels are visible upon loading DE. Connection1. ConnectionString = Provider=Microsoft. Jet. OLEDB. 4. Data Source= & App. Path & DBStonePro. mdbPersist Security Info=FalseJet OLEDBDatabase Password= mdiMain. Width = 15360 End submarine Private stand in MDIForm_Unload(Cancel As Integer) Dim reply reply = MsgBox(Do you want to Quit this program? , vbYesNo + vbQuestion, Confirm Quit) If reply = vbYes Then End End If error Cancel = -1 End paladin Private Sub mnuAbout_Click() frmAbout. Show vbModal End Sub Private Sub mnuBD_Click() frmDatabase. Show vbModal End Sub Private Sub mnuCustomers_Click () frmCustomers. Show vbModal End Sub Private Sub mnufind_Click() frmfind. Show 1 End Sub Private Sub mnuGp_Click() frmGroup. Show vbModal End SubPrivate Sub mnuItems_Click() frmFItems. Show vbModal End Sub Private Sub mnuLog morose_Click() Dim reply reply = MsgBox(Do you really want to LogOff? , vbYesNo + vbQuestion, Confirm Log-Off) If reply = vbYes Then frmLogin. cmdClose. Caption = Cancel frmLogin. Show vbModal End If End Sub Private Sub mnuNewSales_Click() On Error Resume Next call out SQLDB1(frmNewSales. AdoSales, opt * from Sales) Call SQLDB2(frmNewSales. adoCustomer, take away * from Customer order by CustomerNumber) If frmNewSales. AdoSales. Recordset. RecordCount = 0 And frmNewSales. AdoSales. Recordset. RecordCount 9 Then frmNewSales. xtSalesNumber. text = 00000 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 9 And frmNewSales. AdoSales. Recordset. RecordCount 99 Then frmNewSales. txtSalesNumber. schoolbo ok = 0000 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 99 And frmNewSales. AdoSales. Recordset. RecordCount 999 Then frmNewSales. txtSalesNumber. textbook = 000 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 999 And frmNewSales.AdoSales. Recordset. RecordCount 9999 Then frmNewSales. txtSalesNumber. school text = 00 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 9999 And frmNewSales. AdoSales. Recordset. RecordCount 99999 Then frmNewSales. txtSalesNumber. text = 0 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 99999 And frmNewSales. AdoSales. Recordset. RecordCount 999999 Then frmNewSales. txtSalesNumber. school text = frmNewSales. AdoSales. Recordset. RecordCount + 1 End If frmNewSales. xtAmountPaid. school text = 0. 00 frmNe wSales. txtBalance. text = 0. 00 frmNewSales. txtTotalCost. Text = 0. 00 frmNewSales. txtDeliverySatus. Text = Undelivered frmNewSales. dtDate. honour = date frmNewSales. DTDelivery = date frmNewSales. Show vbModal End Sub Private Sub mnuOrder_Click() frmOrders. Show vbModal End Sub Private Sub mnuOrder2_Click() frmOrders. Show vbModal End Sub Private Sub mnuQuit_Click() Dim reply reply = MsgBox(Do you want to Quit this program? , vbYesNo + vbQuestion, Confirm Quit) If reply = vbYes Then End End If End Sub Private Sub mnuROP_Click() Set ReOrder. DataSource = frmReProd. Adodc1.Recordset ReOrder. Refresh ReOrder. Show End Sub Private Sub mnuRDelivered_Click() frmDelivered. Show vbModal End Sub Private Sub mnuRItems_Click() frmFItems. Show vbModal End Sub Private Sub mnuRP_Click() frmReProd. Show vbModal End Sub Private Sub mnuRPR_Click() frmReProd. Show vbModal End Sub Private Sub mnuRSales_Click() frmSalesReport. Show vbModal End Sub Private Sub mnuRSupplier_Click() frmSupplier. Sho w vbModal End Sub Private Sub mnuRUndelivered_Click() frmUndelivered. Show vbModal End Sub Private Sub mnuSuppliers_Click() frmSupplier. Show vbModal End Sub Private Sub mnuTips_Click() frmTips. Show vbModal End SubPrivate Sub mnuUpdateSales_Click() frmUpdateBalance. Show vbModal End Sub Private Sub mnuUser_Click() frmUser. Show vbModal End Sub Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib. Button) Select Case Button. Index Case 3 Call mnufind_Click Case 5 Popup calling card mnuTransaction, , Button. Left, (Button. draw + Button. Height) Case 7 PopupMenu mnuReport, , Button. Left, (Button. Top + Button. Height) Case 9 PopupMenu mnuAccount, , Button. Left, (Button. Top + Button. Height) Case 11 PopupMenu mnuHelp, , Button. Left, (Button. Top + Button. Height) Case 13 Dim reply reply = MsgBox(Do you want to Quit this program? , vbYesNo + vbQuestion, Confirm Quit) If reply = vbYes Then End End If error Cancel = -1 End Select End Sub C. Transaction Page Private Sub cmdAd d_Click() Grid_DblClick cmdEditItems. Enabled = True cmdRemove. Enabled = True End Sub Private Sub cmdCalculator_Click() Shell calc. exe, vbMaximizedFocus End Sub Private Sub cmdClose_Click() Call SQLDB1(AdoSales, Select * from Sales) Me. AdoSales. Refresh If Val(Me. txtTotalCost. Text) = 0 Then Unload Me Else If Me. txtCustomerName. Text = Then MsgBox Please complete data before closing. , vbInformation, Information Else With Me. AdoSales .Refresh .Recordset.AddNew .Recordset. Fields(SalesNumber) = Me. txtSalesNumber. Text . Recordset. Fields(CustomerNumber) = Me. txtCustomerNumber. Text . Recordset. Fields(CustomerName) = Me. txtCustomerName. Text . Recordset. Fields(Datepurchased) = Me. dtDate. encourage .Recordset. Fields(DeliveryDate) = Me. DTDelivery. cling to .Recordset. Fields(DeliveryStatus) = Me. txtDeliverySatus. Text . Recordset. Fields(TotalCost) = Me. txtTotalCost. Text .Recordset. Fields(total) = Me. Text3. Text .Recordset. Fields(Discount) = Me. Text2. Text .Recor dset. Fields(AmountPaid) = Me. txtAmountPaid. Text .Recordset.Fields(Balance) = Me. txtBalance. Text .Recordset. Update .Refresh Unload Me End With End If End If End Sub Private Sub cmdEditItems_Click() Me. AdoItems. Refresh Me. AdoItems. Recordset. Find (ItemNumber = & Me. AdoSalesInfo. Recordset. Fields(ItemNumber) & ) frmEditItems. txtinfo(0). Text = Me. AdoSalesInfo. Recordset. Fields(SalesNumber) frmEditItems. txtinfo(1). Text = Me. AdoSalesInfo. Recordset. Fields(Date) frmEditItems. txtinfo(2). Text = Me. AdoSalesInfo. Recordset. Fields(ItemNumber) frmEditItems. txtinfo(3). Text = Me. AdoSalesInfo. Recordset. Fields(ItemName) frmEditItems. txtinfo(4).Text = Me. AdoSalesInfo. Recordset. Fields(Qty) frmEditItems. txtinfo(5). Text = Me. AdoSalesInfo. Recordset. Fields(UnitPrice) frmEditItems. txtinfo(6). Text = Me. AdoSalesInfo. Recordset. Fields(TotalPrice) frmEditItems. Show vbModal End Sub Private Sub cmdNew_Click() On Error Resume Next cmdEditItems. Enabled = False cmdRemove . Enabled = False Call SQLDB1(AdoSales, Select * from Sales) Me. AdoSales. Refresh If Val(Me. txtTotalCost. Text) = 0 Then Else If Me. txtCustomerName. Text = Then MsgBox Please complete data before closing. , vbInformation, Information Else With Me. AdoSales .Refresh .Recordset.AddNew .Recordset. Fields(SalesNumber) = Me. txtSalesNumber. Text . Recordset. Fields(CustomerNumber) = Me. txtCustomerNumber. Text . Recordset. Fields(CustomerName) = Me. txtCustomerName. Text . Recordset. Fields(Datepurchased) = Me. dtDate. Value .Recordset. Fields(DeliveryDate) = Me. DTDelivery. Value .Recordset. Fields(DeliveryStatus) = Me. txtDeliverySatus. Text . Recordset. Fields(TotalCost) = Me. txtTotalCost. Text .Recordset. Fields(AmountPaid) = Me. txtAmountPaid. Text .Recordset. Fields(Discount) = Me. Text2. Text .Recordset. Fields(Balance) = Me. txtBalance. Text .Recordset.Fields(total) = Me. Text3. Text .Recordset. Update .Refresh Me. txtCustomerName. Locked = False Me. txtCustomerNumber. Locke d = False Me. txtCustomerName. Text = Me. txtCustomerNumber. Text = Me. txtAmountPaid. Text = 0. 00 Call SQLDB1(frmNewSales. AdoSales, Select * from Sales) Call SQLDB2(frmNewSales. adoCustomer, Select * from Customer order by CustomerName) If frmNewSales. AdoSales. Recordset. RecordCount = 0 And frmNewSales. AdoSales. Recordset. RecordCount 9 Then frmNewSales. txtSalesNumber. Text = 00000 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales.AdoSales. Recordset. RecordCount = 9 And frmNewSales. AdoSales. Recordset. RecordCount 99 Then frmNewSales. txtSalesNumber. Text = 0000 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 99 And frmNewSales. AdoSales. Recordset. RecordCount 999 Then frmNewSales. txtSalesNumber. Text = 000 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 999 And frmNewSales. AdoSales. Recordset. RecordCount 9999 Then frm NewSales. txtSalesNumber. Text = 00 & frmNewSales.AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 9999 And frmNewSales. AdoSales. Recordset. RecordCount 99999 Then frmNewSales. txtSalesNumber. Text = 0 & frmNewSales. AdoSales. Recordset. RecordCount + 1 End If If frmNewSales. AdoSales. Recordset. RecordCount = 99999 And frmNewSales. AdoSales. Recordset. RecordCount 999999 Then frmNewSales. txtSalesNumber. Text = frmNewSales. AdoSales. Recordset. RecordCount + 1 End If frmNewSales. txtAmountPaid. Text = 0. 00 frmNewSales. txtBalance. Text = 0. 00 frmNewSales. txtTotalCost. Text = 0. 00 rmNewSales. Text3. Text = 0. 00 frmNewSales. txtDeliverySatus. Text = Undelivered frmNewSales. dtDate. Value = date frmNewSales. DTDelivery = date Me. cmdNew. Enabled = False Me. cmdNewCustomer. Enabled = True Me. cmdPayment. Enabled = False Me. cmdReciept. Enabled = False Me. cmdEditItems. Enabled = False Me. cmdRemove. Enabled = False Call SQLDB3(AdoIt ems, Select * from Items where RemainingQty 0) Call SQLDB(AdoSalesInfo, Select * from SalesInfo where SalesNumber= & Me. txtSalesNumber. Text & ) AdoSalesInfo. Refresh AdoItems. Refresh Me. cmdNew. Enabled = True Set Grid2. DataSource = AdoSalesInfoGrid2. Columns(1). open = False Grid2. Columns(2). tangible = False Grid2. Columns(5). NumberFormat = 0. 00 Grid2. Columns(6). NumberFormat = 0. 00 Set Grid. DataSource = AdoItems Grid. Columns(0). open = False Grid. Columns(2). evident = False Grid. Columns(5). telescopic = False Grid. Columns(6). Visible = True Me. txtCustomerName. Locked = False Me. txtCustomerName. Locked = False lblChange. Caption = 0. 00 Me. txtCustomerName. Text = Me. txtCustomerNumber. Text = Me. txtAmountPaid. Text = 0. 00 Me. txtCustomerName. Locked = False Me. txtCustomerNumber. Locked = False Me. txtCustomerName. Text = Me. txtCustomerNumber. Text = Me. txtAmountPaid. Visible = True Unload Me End With End If End If End Sub Private Sub cmdNewCustomer_C lick() With frmNewCustomer If Me. adoCustomer. Recordset. RecordCount = 0 And Me. adoCustomer. Recordset. RecordCount 9 Then . txtinfo(0). Text = 00000 & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount = 9 And Me. adoCustomer. Recordset. RecordCount 99 Then . txtinfo(0). Text = 0000 & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount = 99 And Me. doCustomer. Recordset. RecordCount 999 Then . txtinfo(0). Text = 000 & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount = 999 And Me. adoCustomer. Recordset. RecordCount 9999 Then . txtinfo(0). Text = 00 & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount = 9999 And Me. adoCustomer. Recordset. RecordCount 99999 Then . txtinfo(0). Text = 0 & Me. adoCustomer. Recordset. RecordCount + 1 End If If Me. adoCustomer. Recordset. RecordCount = 99999 And Me. adoCustomer . Recordset.RecordCount 999999 Then . txtinfo(0). Text = Me. adoCustomer. Recordset. RecordCount + 1 End If .Show vbModal End With End Sub Private Sub cmdPayment_Click() If Me. AdoSalesInfo. Recordset. RecordCount = 0 Then MsgBox You cannot proceed to payment because there is no item in your sales item list , vbExclamation, Error Else frmPayment. txtBalance. Text = Me. txtBalance. Text frmPayment. Text3. Text = Me. txtTotalCost. Text frmPayment. txtChange. Text = 0. 00 frmPayment. txtPayment. Text = 0 frmPayment. Show vbModal End If End Sub Private Sub cmdReciept_Click() If Me. AdoSalesInfo. Recordset.RecordCount = 0 Then MsgBox There is no item , vbExclamation, StonePro System Else If Me. txtCustomerName. Text = Or Me. txtDeliverySatus. Text = Then MsgBox Please supply personal data before you view the receipt. , vbInformation, Information Else Set RptReceipt. DataSource = Me. AdoSalesInfo RptReceipt. Refresh RptReceipt. Sections(Section2). Controls(lblSalesNumber). Caption = fr mNewSales. txtSalesNumber. Text RptReceipt. Sections(Section2). Controls(lblTotalCost). Caption = Format(frmNewSales. Text3. Text, ,0. 00) RptReceipt. Sections(Section2). Controls(lblCustomerNumber).Caption = frmNewSales. txtCustomerNumber. Text RptReceipt. Sections(Section2). Controls(lblCustomerName). Caption = frmNewSales. txtCustomerName. Text RptReceipt. Sections(Section2). Controls(lblDatePurchased). Caption = frmNewSales. dtDate. Value RptReceipt. Sections(Section2). Controls(lblDeliveryDate). Caption = frmNewSales. DTDelivery. Value RptReceipt. Sections(Section2). Controls(lblDis). Caption = Format(frmNewSales. Text2. Text, ,0. 00) RptReceipt. Sections(Section2). Controls(lblAmountPaid). Caption = Format(frmNewSales. txtPayment. Text, ,0. 00) RptReceipt.Sections(Section2). Controls(lblBalance). Caption = Format(frmNewSales. txtBalance. Text, ,0. 00) RptReceipt. Sections(Section2). Controls(lblChange). Caption = Format(frmNewSales. lblChange. Caption, ,0. 00) cmdNew. Enabled = True RptReceipt. Show 1 End If End If End Sub Private Sub cmdRemove_Click() Dim reply reply = MsgBox(Are you sure you want to terminate this item to sales list? , vbYesNo + vbQuestion, Confirmation to Remove) If reply = vbYes Then frmNewSales. AdoItems. Refresh Call SQLDB3(AdoItems, Select * from Items) frmNewSales. AdoItems. Recordset. Find (ItemNumber= & Me. AdoSalesInfo.Recordset. Fields(ItemNumber) & ) frmNewSales. AdoItems. Recordset. Fields(RemainingQty) = Val(frmNewSales. AdoItems. Recordset. Fields(RemainingQty)) + Me. AdoSalesInfo. Recordset. Fields(Qty) frmNewSales. AdoItems. Recordset. Update frmNewSales. AdoItems. Refresh frmNewSales. txtTotalCost. Text = Format(Val(frmNewSales. txtTotalCost. Text) Me. AdoSalesInfo. Recordset. Fields(TotalPrice), 0. 00) frmNewSales. txtBalance. Text = Format(Val(frmNewSales. txtBalance. Text) Me. AdoSalesInfo. Recordset. Fields(TotalPrice), 0. 00) frmNewSales. AdoSalesInfo. Recordset. Delete frmNewSales.AdoSalesInfo. Refresh Call S QLDB3(AdoItems, Select * from Items where RemainingQty 0) Call SQLDB(AdoSalesInfo, Select * from SalesInfo where SalesNumber= & Me. txtSalesNumber. Text & ) AdoSalesInfo. Refresh AdoItems. Refresh Me. cmdNew. Enabled = True Set Grid2. DataSource = AdoSalesInfo Grid2. Columns(1). Visible = False Grid2. Columns(2). Visible = False Grid2. Columns(5). NumberFormat = 0. 00 Grid2. Columns(6). NumberFormat = 0. 00 Set Grid. DataSource = AdoItems Grid. Columns(0). Visible = False Grid. Columns(2). Visible = False Grid. Columns(5). Visible = False If Me. AdoSalesInfo. Recordset.RecordCount = 0 Then Me. cmdEditItems. Enabled = False Me. cmdRemove. Enabled = False Me. cmdPayment. Enabled = False End If Else End If End Sub Private Sub Form_Load() On Error Resume Next Call SQLDB3(AdoItems, Select * from Items where RemainingQty 0) Call SQLDB(AdoSalesInfo, Select * from SalesInfo where SalesNumber= & Me. txtSalesNumber. Text & ) Call SQLDB2(frmNewSales. adoCustomer, Select * from Customer Order by CustomerName) adoCustomer. Refresh AdoSalesInfo. Refresh AdoItems. Refresh Me. cmdNew. Enabled = True Set Grid2. DataSource = AdoSalesInfo Grid2. Columns(1). Visible = False Grid2. Columns(2).Visible = False Grid2. Columns(5). NumberFormat = 0. 00 Grid2. Columns(6). NumberFormat = 0. 00 Set Grid. DataSource = AdoItems Grid. Columns(0). Visible = False Grid. Columns(2). Visible = False Grid. Columns(5). Visible = False Grid. Columns(6). Visible = True Grid2. Refresh Call setgrid Call settext Call setgrid lblTotal. Caption = Total Number of Records & Me. AdoSalesInfo. Recordset. RecordCount End Sub Private Sub setgrid() Set Me. Grid2. DataSource = Me. AdoSalesInfo Grid. Columns(0). Visible = False Grid. Columns(2). Visible = False Grid. Columns(3). Visible = False Grid. Columns(4). Visible = FalseGrid. Columns(5). Visible = False Grid. Columns(6). Visible = True End Sub Private Sub Grid_DblClick() With frmSalesConfirm .txtinfo(0). Text = Me. txtSalesNumber. Text .txtinfo(1). Text = Me. dtDate. Value .txtinfo(2). Text = Me. AdoItems. Recordset. Fields(ItemNumber) . txtinfo(3). Text = Me. AdoItems. Recordset. Fields(ItemName) . txtinfo(4). Text = 0 .txtinfo(5). Text = Me. AdoItems. Recordset. Fields(UnitPrice) . txtinfo(6). Text = 0. 00 If Me. AdoItems. Recordset. Fields(Unit) = kilo Then .Label5. Caption = Quantity End If .Show vbModal End With End Sub Private Sub lvButtons_H3_Click()Unload Me End Sub Private Sub Text1_Change() On Error Resume Next Me. AdoItems. Refresh Me. AdoItems. Recordset. Filter = ItemName equivalent & LCase(Me. Text1. Text) & * Call settext Call setgrid If Me. Text1. Text = Then Me. AdoItems. Refresh setgrid End If End Sub Private Sub txtAmountPaid_Change() If Val(Me. txtAmountPaid. Text) Val(Me. txtTotalCost. Text) Then MsgBox Amount paid is lower than its total cost. , vbExclamation, Stone Pro System Me. txtAmountPaid. Text = 0. 00 Else Me. txtBalance. Text = Format(Val(Me. txtTotalCost. Text) Val(Me. txtAmountPaid. Text), 0. 00) End If End SubPrivate Sub txtAmountPaid_KeyPress(KeyAscii As Integer) If KeyAscii = 8 Then going Sub End If If KeyAscii = 46 Then blow over Sub End If If KeyAscii 48 Or KeyAscii 57 Then KeyAscii = 0 End If End Sub Private Sub txtCustomerName_Change() On Error Resume Next Me. adoCustomer. Refresh Me. adoCustomer. Recordset. Find (CustomerName = & Me. txtCustomerName. Text & ) Me. txtCustomerNumber. Text = Me. adoCustomer. Recordset. Fields(CustomerNumber) End Sub Private Sub txtCustomerNumber_KeyPress(KeyAscii As Integer) KeyAscii = False End Sub Private Sub txtDeliverySatus_KeyPress(KeyAscii As Integer) KeyAscii = False End SubConfirm Transaction Private Sub Check1_Click() If Check1. Value = 1 Then Me. Text2. Text = Format(Val(Me. Text3. Text * 0. 1), ,0. 00) Me. Text1. Text = Format(Me. Text2. Text, ,0. 00) run low Sub End If If Check1. Value = 0 Then Me. Text1. Text = 0. 00 Me. Text1. Text = Format(Val(Me. txtPayment. Text) Val(Me. Text2. Text), ,0. 00) Exit Sub End If End Sub Private Sub cmdClose_Click() frmNewSales. lblChange. Caption = Me. Text4. Text frmNewSales. Text2. Text = Me. Text1. Text Unload Me End Sub Private Sub cmdOk_Click() Dim reply reply = MsgBox(Are you sure of this payment?. Payment can be done only once in this transaction. , vbQuestion + vbYesNo, Confirmation) If reply = vbYes Then If Val(Me. txtPayment) Val(frmNewSales. txtTotalCost) Then Me. txtBalance. Text = 0. 00 Me. cmdOk. Enabled = False frmNewSales. txtBalance. Text = 0. 00 frmNewSales. txtPayment. Text = Val(Me. txtPayment) Me. Text4. Text = Format(Val(Me. txtPayment) Val(Text3. Text) + Val(Text1. Text), ,0. 00) frmNewSales. txtAmountPaid. Visible = False frmNewSales. cmdReciept. Enabled = True frmNewSales. cmdPayment. Enabled = False frmNewSales. cmdEditItems. Enabled = False frmNewSales. cmdRemove. Enabled = False frmNewSales. Text3. Text = Format(Val(Text3.Text) Val(Text1. Text), ,0. 00) Me. Text1. Text = 0. 00 Else Me. txtBalance. Text = Format(Val(Me. txtPaym ent) Val(Me. Text3. Text) Val(Me. Text1. Text), ,0. 00) Me. txtChange. Text = 0. 00 Me. cmdOk. Enabled = False frmNewSales. txtBalance. Text = Format(Val(Me. txtPayment) Val(Me. Text3. Text) Val(Me. Text1. Text), ,0. 00) frmNewSales. txtBalance. Text = Format(Val(Me. Text3) Val(Me. txtPayment. Text) Val(Me. Text1. Text), ,0. 00) frmNewSales. lblChange. Caption = 0. 00 frmNewSales. txtAmountPaid. Text = Val(Me. txtPayment) frmNewSales. txtPayment. Text = Val(Me. xtPayment) frmNewSales. cmdReciept. Enabled = True frmNewSales. cmdPayment. Enabled = False frmNewSales. cmdEditItems. Enabled = False frmNewSales. cmdRemove. Enabled = False frmNewSales. Text3. Text = Format(Val(Text3. Text) Val(Text1. Text), ,0. 00) Me. Text1. Text = Format((frmNewSales. Text3. Text), ,0. 00) frmNewSales. Text2. Text = Me. Text1. Text End If Else End If If Check1. Value = 1 Then Me. Text2. Text = Format(Val(Me. Text3. Text * 0. 1), ,0. 00) Me. Text1. Text = Format(Me. Text2. Text, ,0. 00) Exit Sub En d If If Check1. Value = 0 Then frmNewSales. Text2. Text = 0. 00 Me. Text1.Text = 0. 00 Exit Sub End If End Sub Private Sub txtPayment_Change() If Check1. Value = 1 Then Me. Text2. Text = Format(Val(Me. Text3. Text * 0. 1), ,0. 00) Me. Text1. Text = Format(Me. Text2. Text, ,0. 00) Exit Sub End If If Check1. Value = 0 Then Me. Text1. Text = 0. 00 Exit Sub End If End Sub 4. 7 Program Output pic 4. 8 User manual(a) Title Automated Sales and Inventory System of Stone Pro Enterprise Table of table of contents 1. Introduction 1. 1 System Requirements 1. 1. 1 Hardware 1. 1. 1. 1 Desktop 1. 1. 1. 2 Display 1. 1. 1. 3 Cash Drawer 1. 1. 1. 4 Receipt Printer 1. 1. 2 Software 1. 2 Convention 2. getting Started . 1 Member Log in 2. 2 Performing Transaction 3. Software Features 4. Message Boxes 5. User Interface Parts, Text boxes and Buttons 1. Introduction Most Large retail stores have migrated from the old trusty cash register to more modern computerized point of sale (POS) systems. This appli cation Guide explores computerized POS technology and provides a roadmap for Stone Pro Enterprise. 1. 1 System Requirements 1. 1. 1 Hardware If you are a computer user, youre no surmise familiar with the most common desktop peripherals the keyboard, mouse. Blue Link Technology systems are based on ordinary desktop computer and operating system . 1. 1. 1. Desktop Desktop with larger but quieter fans to minimize heat and noise. Heavy duty power supply that last longer than the standard items. Hard drive doesnt have to be in large capacity but it has to be reliable. We also want to ensure that youre using good surge protector and UPS ( battery backup) to prevent power related crashes. 1. 1. 1. 2. Display At the very least, youll need a basicmonitorat your POS to see what youre doing. Touch screenshave become a more popular and affordable option these days since they are a user favorable option that can help speed up the checkout process.Adding customer-facingandpole displayswill offe r a clearer customer experience and are a great way to promote special offers to customers while they are in line. 1. 1. 1. 3. Cash Drawer They may be the simplest peripheral in a POS system, butcash drawersare still an essential part of your system. You need to have a secure place to keep cash, checks 1. 1. 1. 4. Receipt Printer Every transaction ends with a receipt for the customer straight from areceipt printer. Having a printer go down is one of the most crippling things to any POS system. devising sure you have a printer thatll support your print volume and is easy to use is essential.Most printers are thermal based so you dont even have to deal with ribbon cartridges anymore. Just load the paper and you are back up and running Whatever your receipt size or type requirements are, theres a printer to fit your needs. There are numerous types of receipt printers, categorized like any other computer printer by its printing technology and its computer interface. 1. 1. 2. Software ThePOS softwareby Blue Link Technology is the brains of Stone Pro Enterprise POS system. 1. 2 Convention Double Click conjure up to user action Log in Window reference to user interfaceLog in Button Refer to object Enter Key Refer to Keyboard key 2. 0 Getting Started I. Daily Start-Up 1. Turn the Computer ON Press the ON/OFF button. (On top of the computer for Stone Pro Enterprise. ) WAIT. It will take a few moments but eventually Stone Pro Enterprise System and an Address hunt application will automatically start up. A desktop with icons will appear including pic A Login screen will appear pic 2. Sign on to the System a) When the Security Login screen appears, User ID = (ask for an access code to the admin assign ) unless you have been assigned something else.Password = the password you selected. It will NOT appear for security reasons. ENTER b) The Main Desktop will appear pic II. Start of Shift A. Cash commemorate Processing. 1. Press the Transaction Menu button. 2. Select TRANSACTION then NEW SALE. pic ( You are now ready to perform Cash Register Operations. ) III. End of Shift A. Clerk Out Start at the Transaction screen. Press CLOSE to Exit from the Transaction Screen. IV. End of Day In the evening you will need to 1. Leave the cash drawer open. 2. Close Stone Pro Enterprise System Main Page 3. Exit Stone Pro Enterprise System. 4.Turn off the computer. After you finish the End of Shift procedure, complete the following A. Log Off of Stone Pro Enterprise System 1. At the main Stone Pro Enterprise System desktop B. Shut Down the Computer 1. Select the Start button in the lower unexpended hand corner. 2. Select Shut Down from the list. A Shut Down Windows window will appear. 3. Select Shut Down from the drop down list. The monitor will go black and say No Sync for a bit. CHAPTER 5 FINDINGS, CONCLUSIONS AND RECOMMENDATION In this chapter states the summary of findings, conclusion and recommendation. 4. 1 Summary of FindingsPoint of Sale System for St one Pro Enterprise aims to develop an expert system that would enable the emergence of Point of Sale and maximize the capabilities. It shows how efficient accurate and well function, the point of sale compared to manual registry. 4. 2 conclusion We conclude that the research has shown that the study can be useful for the company Stone Pro Enterprise. In this study considering all the factors affecting. 4. 3 Recommendation The Researchers recommend this Point of Sale System of Stone Pro Enterprise to be used in interested establishment in improving and helping people retail their products. BIBLIOGRAPHY