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 [url removed, login to view] s 1 0 0 [url removed, login to view] O 0 0 0 1 : 0- s

20489 GiftCertSale [url removed, login to view] s 1 0 0 [url removed, login to view] O 5 0 0 1 : 0- s

23999 GoldGiftPkSp [url removed, login to view] S 1 0 0 [url removed, login to view] F 0 0 0 1 : 0- S

24000 GoldGiftPak [url removed, login to view] S 1 0 0 [url removed, login to view] F 0 0 0 1 : 0- S

24001 Coffee [url removed, login to view] V 1 0 0 [url removed, login to view] F 0 0 0 1 : 0

24002 ClubPlan 1Yr [url removed, login to view] s 1 0 0 [url removed, login to view] F 0 0 0 1 : 0

24003 ClubPlan 6Mo [url removed, login to view] s 1 0 0 [url removed, login to view] F 0 0 0 1 : 0

24004 Merch. [url removed, login to view] V 1 0 0 [url removed, login to view] O 1 1 0 1 : 0

24005 Food-No Tax [url removed, login to view] V 1 0 0 [url removed, login to view] O 1 0 0 1 : 0

24006 FoodEmployee [url removed, login to view] V 1 0 0 [url removed, login to view] O 1 0 0 1 : 0

24007 ClubSaleOpen [url removed, login to view] S 1 1 0 [url removed, login to view] O 0 0 0 1 : 0

24008 Club6mo-2ndV [url removed, login to view] S 1 0 0 [url removed, login to view] F 0 0 0 1 : 0

24009 ClubPlanDupl [url removed, login to view] s 1 0 0 [url removed, login to view] F 0 0 0 0 : 0

24010 ClubPlan2ndV [url removed, login to view] S 1 0 0 [url removed, login to view] F 0 0 0 1 : 0

24011 Ext Gift Pak [url removed, login to view] S 1 0 0 [url removed, login to view] F 0 0 0 1 : 0

24012 ExtGiftPakOV [url removed, login to view] S 1 0 0 [url removed, login to view] F 0 0 0 1 : 0

24013 ExtGiftPak. [url removed, login to view] S 1 0 0 [url removed, login to view] F 0 0 0 1 : 0

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

24050 Uniform Sale [url removed, login to view] U 1 0 0 [url removed, login to view] O 0 0 0 1 : 0

25000 Cigs@C/S [url removed, login to view] V 1 0 0 [url removed, login to view] F 0 0 0 0 : 0

25001 CancerSociet [url removed, login to view] V 0 0 0 [url removed, login to view] F 0 0 0 1 : 0

29771 SilverCertif [url removed, login to view] s 1 0 0 [url removed, login to view] 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 = $[url removed, login to view]

Cash = $[url removed, login to view]** |

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: search salesman, service advisor, cash engineering, reverse engineering project, get salesman, trans, salesman, merch, license plate, incomplete, transaction report, sort contents, report service php, error code 500 php, error code 500, php loop date range, 295, transaction report php, option report, report sales, project engineering report, 25000 words, 500 report words, license plate code, 500 words food

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