Cancelado

incomplete transactions report

Report to loop through and show incomplete and/or complete transactions for the same license plate for a specific date range and location

## Deliverables

We want to show any transaction that does NOT have a wash in it.

We can EXCLUDE the transactions that have a sales item in it:

20488 GiftCardSale 0.000 s 1 0 0 125.00 O 0 0 0 1 : 0- s

20489 GiftCertSale 0.000 s 1 0 0 125.00 O 5 0 0 1 : 0- s

23999 GoldGiftPkSp 0.000 S 1 0 0 64.95 F 0 0 0 1 : 0- S

24000 GoldGiftPak 0.000 S 1 0 0 77.94 F 0 0 0 1 : 0- S

24001 Coffee 0.000 V 1 0 0 0.25 F 0 0 0 1 : 0

24002 ClubPlan 1Yr 0.000 s 1 0 0 550.00 F 0 0 0 1 : 0

24003 ClubPlan 6Mo 0.000 s 1 0 0 315.00 F 0 0 0 1 : 0

24004 Merch. 0.000 V 1 0 0 50.00 O 1 1 0 1 : 0

24005 Food-No Tax 0.000 V 1 0 0 25.00 O 1 0 0 1 : 0

24006 FoodEmployee 0.000 V 1 0 0 20.00 O 1 0 0 1 : 0

24007 ClubSaleOpen 0.000 S 1 1 0 550.00 O 0 0 0 1 : 0

24008 Club6mo-2ndV 0.000 S 1 0 0 295.00 F 0 0 0 1 : 0

24009 ClubPlanDupl 0.000 s 1 0 0 5.00 F 0 0 0 0 : 0

24010 ClubPlan2ndV 0.000 S 1 0 0 500.00 F 0 0 0 1 : 0

24011 Ext Gift Pak 0.000 S 1 0 0 35.00 F 0 0 0 1 : 0

24012 ExtGiftPakOV 0.000 S 1 0 0 49.99 F 0 0 0 1 : 0

24013 ExtGiftPak. 0.000 S 1 0 0 39.99 F 0 0 0 1 : 0

24020 [url removed, login to view] 0.000 s 1 0 0 250.00 F 0 0 0 1 : 0

24050 Uniform Sale 0.000 U 1 0 0 50.00 O 0 0 0 1 : 0

25000 Cigs@C/S 0.000 V 1 0 0 0.00 F 0 0 0 0 : 0

25001 CancerSociet 0.000 V 0 0 0 1.00 F 0 0 0 1 : 0

29771 SilverCertif 0.000 s 1 0 0 13.99 F 0 0 0 1 : 0

What we are running into is the service advisor is entering just a license plate, then hitting cash, so no wash is going in to the transaction. We want to charge him for the error. Here’s where it get’s tricky; some of these guys catch it, but they are so dumb that they don’t know they can just reverse the transaction and start over, so they open a new transaction and start over an do it correctly. They enter the same license plate again in the new transaction. We’d want both transactions to show on this report next to each other. Sample:

| DATE | LOCATION | TRANS. NUMBER | TIME | SHIFT | TERM | SALESMAN | TRANSACTION CONTENTS |

| **2008-03-05** | **JX2** | **51** | **9:25:00 AM** | **1** | **3** | **10812** | **Card Number:**

**License Plate:** 5766 **

Cash = $0**.**00** |

| **2008-03-05** | **JX2** | **51** | **9:25:00 AM** | **1** | **3** | **10812** | **Card Number:

License Plate: 5766

ExteriorWash = $4.99

Cash = $4.99** |

So in other words, since the first transaction is without wash (or sales item), the code will search for other transactions FROM THAT SAME DAY where the license plate 5766 is included and report it just below. This way, we will know not to charge him, as he fixed the problem (in a way).

We will want to run this report weekly, so use the date range input boxes and an option to select by different locations or all locations. The sort would be by DATE then SALESMAN.

* * *This broadcast message was sent to all bidders on Tuesday Jan 12, 2010 10:20:25 PM:

please let me know if anyone is still interested in this project.

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: where to search for salesman, we want a salesman, the catch of the day, Service advisor, s&d coffee, get a salesman, cash engineering, cash#4, reverse engineering project, 10 99 tax, get salesman, trans, salesman, merch, License plate, incomplete, charge charge card, transaction report, sort contents, report service php, error code 500 php, error code 500, php loop date range, 295, transaction report php

Acerca do Empregador:
( 37 comentários ) United States

ID do Projeto: #3064210

6 freelancers estão ofertando em média $71 para este trabalho

gkalish

See private message.

$85 USD in 3 dias
(244 Comentários)
6.3
shahramjaved0075

See private message.

$59.5 USD in 3 dias
(11 Comentários)
3.5
itsali0009

See private message.

$42.5 USD in 3 dias
(14 Comentários)
3.1
lkshakya

See private message.

$68 USD in 3 dias
(17 Comentários)
3.2
tatasthuinfotech

See private message.

$85 USD in 3 dias
(13 Comentários)
3.3
homi12345

See private message.

$85 USD in 3 dias
(9 Comentários)
2.7