I am looking an invoicing system to fit the following scene::
A heating boiler maintenance man (Mr A) has two businesses. One servicing gas boilers with Mr B, and the other servicing Oil boilers with Mr C.
If Mr A is at a customers site servicing a gas boiler, he wishes to log in using Tcp/IP on his laptop to his workshop, log into his gas business, and raise an invoice to the customer at time of service for a mixture of labour and parts. If he is out later servicing an oil boiler, he wants to use same program , but log into his oil boiler business to raise the same type of invoice.
Mr B will only ever log into the gas business, and Mr C only into the oil business.
ie a central server running postgres holding the following types of data::
Database for gas company, one for oil business::
each database holding:
Customer Name
Stocks/Inventories
Invoice details
As it would be mobile connectivity, the Stock files would ideally be
held on his laptop (ie stock files only change rarely through prices or new items) so that the invoicing system would perform a local lookup rather than having to perform internet lookups.
Reports would really be a list of invoices raised.
Inventory/Stock control and accounts receivable are not essential.
System would ideally be Delphi based, as .Net may be too memory hungry for the current computers being used.
Postgres has been recommended as it is currently the database server beng used by his website which sells boilers.