I have inherited a point of sale application as part of the purchase of a second hand goods store. This application is poorly written and needs changing.
Basic info for application:
Uses MS Access backend.
Uses Delphi front end (want this changed to VB or VBA)
The Delphi code is compiled and I have been unable to decompile it adequately, although there are so many glitches that I would rather re-engineer it. It also does not cater for our business model. I am happy that the table structures can remain as they are with some additions as we add functionality.
The basic components of the application: (Currently)
Point of sale computer with stock numbers attached to prices, payouts for petty cash items, reciept printing, till drawer opening (not that hard to do).
A buyshop computer holding the database. It allows for second hand stock purchases, laybuy creation and payment, Pawn creation with interest calculations and receiving of payment against these, New stock input from suppliers.
The back shop computer. This is for pulling reports on stock levels, keeping tabs of which stock is in the store and which is on the floor, suggested price reductions on non moving items, inter shop transfers, indicators of the best sellers.
What I need is the front end components redesigned. I have and IT company and was a coder by trade. I just don't have the time to do this as I am learning the syntax as I go. I intend to release one component first to see if this arrangement works for me as this is the first time that I am using a freelance web based solution to my problem.
The first part that I want done is the new goods input screen. I have created the forms already (although they could be optimised). Basically new goods come in and are captured on a form from the invoice. There is a button to add a new supplier if needed. Basic fields like price, qty, category, description, and if it is new or graded goods (will explain on request). The form should total the cost and add tax so that it can be checked against the invoice. and that's about it. Tiny I know but there's more to come.
I must be able to understand the code to support it. It needs to be commented properly.
I need to know how long it will take as I am loosing man hours with the current system.
If you want more info please let me know. Specific questions would help.