For many years, we have used self designed database in Lotus Approach, we want to switch to something more up to date.
Currently we handle: 1) CRM, 2) Purchasing/3) inventory/4) selling, 5) Checkbooks, 6) Indent sales (Where merchandise is shipped from an exporter direct to a client, and we receive a commission for this). Ideally the project would fuse 1-5 in a sigle aplication, and leave 6) as a separate module.
Our authorities constantly change VAT rates, official forms for invoices, etc. So it has to be easy modifiable by us.
We have brabches in 1 extra country, it can be interesting for us to have remote access to the databases.
Our computer equipment is generally modern (Most PC's less that one year old)
Product has to be multi user/ multi company / multi currency
You can download empty verions of our databases from
[url removed, login to view]
, so you can take a quick look. You must have Lotus approach to see them. Most of it is in Spanish, I have modified the APR file names to English, so it is easier to browse through them.
You can see an example of the multiple invoice formats in the tabs of invoicer.apr. Some macros in the samples will not work, since I have not included some files, that are the result of many years of "patching". Obvously we want less clutter in a brand new application.
databases must also allow for easy addtion of fields, for future needs. When a password is requested in the enclosed files, simply press enter (This for the APR files, the dbf files may still be locked, so you have to open them from the APR files)
I have suggested My SQL as database, but I am open to suggestions.
Database must allow much better product descriptions than currently, including photos.