I have a situation in where I do a lot of on-site service. What I want to do is the following:
- Get the customer info or select customer from DB when on-site just as the RMS new customer entry would be. (name, number, address, email, etc).
- Bill the customer remotely.
Now my questions are these.
Can I remotely add customers to the RMS DB cleanly? Meaning it wont cause problems? Can we develop an RMS remote billing page? Pull up the list of customers, select the customer or add the customer and not have it damage the main RMS DB?
Would I have to host the RMS DB perhaps in a co-located server where the data can be accessed via the internet easily? How secure is this really?
I know querying the database for customers is possible, but I am just afraid of adding to it from a 3rd party developed page in that I dont know how crucial it is to only add customers from the RMS application itself and not remotely.
For billing, I would just have the gateway info from my merchant and just develop a basic checkout page based on an item I input manually (it will always be service) and just hit checkout.
Basically in the end I would select a customer or add a customer, put the service price and hit bill now to send it to my merchant for processing.
Is this possible?
Also later on would it be possible to even make it more extensie and pick some items from the DB for sale onsite?
Essentially this could be technically creating a mini-remote POS terminal for onsite.
This could cause all of the accounting and reports to be off though? I am wondering whats the best way to do this?