Arabic is the preferred language for this project.
Create a report that shows the total value of goods sold after discount from a specific supplier or item(s) or category during a given timeframe, minus the total value of the goods returned of that specific supplier.
Table Billheader type 2 is a consists of our FullBill No, and date of the sale. Table Fbillitems consists of the item code, quantity and price. Table items consists of the company, and category of each item code. Table restore bill consists of all the returns including date, item code, quantity and price. Primary keys are indicated with (-) sign before them.
We need the results to show both totals view, and summary view. We need the ability to sort and filter the results by any field. The data is available in Microsoft sql and it is synced to mysql. It is preferred that the report is generated from the Microsoft sql tables, but from mysql will do as well.
This project will be divided into 2 milestones, one after development, and one after testing.
The important fields from the tables are posted below.
Please send me the database. 10+ years experience. 500+ projects completed successfully. I am very interested in this project. Please send me complete details. Ready to start ASAP.
8 freelancers are bidding on average $211 for this job
Hello Sir we are freelancer developers and designers and we have a team of 15 designers and developers ,we have done many webapplications and websites Kindly sir check Portfolio, Please Sir Reply usThank You
While being qualified in MySQL and MS SQL, I can come up with an MS SQL query as well as MySQL query to generate the report (which could then be imported into Excel etc.). This task doesn't seem to be difficult.