Create Database software in Excel or MS access or even in SQL , not complicated just simple can create Quotation
1. Supplier Price List Multi Currency with conversion possibility
2. Product Information (Product Description, Buying Pack, Selling Pack, Licence Number, selling country, Technical sheet)
3. Market Information, average selling price + sales history last 3 Months
Data used for create quotation with Margin and Mark-up
Please note this is for import products from EU countries and Export to EU countries as well as sell in local market
There will be over 300 suppliers in 20 countries
Products over 1500
Buying as many different items and selling as one products for example selling product as “A” we buy from “A” from one country, “S” from different country and “E” from in different country
Search option for example if we search selling Products "X" should give all information, all suppliers prices with local conversion , Selling price, last three month sales, Margin on each supplier with the current average selling price.
Multi User access – enters prices/ selling information/ market information etc.
I am looking for simple database system, input data’s and create quotes
I will go more in detail when I give the job