Em Andamento

Value of goods sold report

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.

fbillitems:

-id

No

ItemCode

Stock

TQuantity

Price

billheader:

-No

-Type

Date

Discount

items:

AName

EName

-Code

Company

Category

restorebill:

No

BillNo

Date

ItemCode

Stock

Quantity

Price

Habilidades: MySQL, PHP, Arquitetura de software, SQL

Ver mais: sql create table price, discount keys, Value, bill of quantity, mysql sort field, mysql create table sort, create sql report, arabic development, table sort filter, stock report, date mysql sort, mysql discount, item sold, table milestones, php mysql filter results, stock data mysql, sql create report, php sql filter, create php report mysql, php mysql report total value, create mysql filter, filter sort mysql php, sql stock project, report generated php mysql, type date

Acerca do Empregador:
( 3 comentários ) Portland, Libya

ID do Projeto: #5112255

Premiar a:

eperfections

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.

$150 USD em 3 dias
(259 Avaliações)
7.1

8 freelancers are bidding on average $211 for this job

nuprogramer

We are expert in generating reports from data and we can make a complete report with summary and details. We have viewed the fields that you mentioned and we can go with SQL but we will prefer MYSQL as that's synch alr Mais

$568 USD in 10 dias
(34 Comentários)
6.0
mituld

A proposal has not yet been provided

$93 USD in 4 dias
(10 Comentários)
4.1
jblsolution

READY TO START YOUR WORK NOW... s k ype bhagyavendra1 NO NEED TO PAY [url removed, login to view] I WILL GIVE YOU UPDATE THEN YOU CAN CREATE MILE STONE PAY [url removed, login to view] [url removed, login to view] http://www Mais

$73 USD in 3 dias
(14 Comentários)
3.4
vijaywebsol

Hi, we are interested to work on your project.50+ skilled development team is ready to start for the project. Please give few minutes for Project discussion. we have 50+ highly skilled team ,please give few minutes Mais

$100 USD in 2 dias
(5 Comentários)
3.1
sweetoasis

A proposal has not yet been provided

$147 USD in 3 dias
(2 Comentários)
3.1
webroyals

A proposal has not yet been provided

$242 USD in 12 dias
(1 Comentário)
2.7
techwizards786

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

$50 USD in 4 dias
(2 Comentários)
2.0
niksdotnet

Let's discuss more...Let's discuss more...Let's discuss more...Let's discuss more...Let's discuss more...Let's discuss more...Let's discuss more...Let's discuss more...Let's discuss more...Let's discuss more...Let's di Mais

$277 USD in 3 dias
(1 Comentário)
1.1
mkhalelulah

A proposal has not yet been provided

$155 USD in 3 dias
(1 Comentário)
0.0
rslpvtltd

we believe we should do it the way our customers want, and not the other way around. Our customers don't see us as just suppliers, but as true partners, helping them to achieve their deadlines, solving their difficult Mais

$250 USD in 5 dias
(0 Comentários)
0.0
maxlogics

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Mais

$147 USD in 3 dias
(3 Comentários)
0.0
kasparg

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.

$83 USD in 3 dias
(0 Comentários)
0.0