Peruttu

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.

Taidot: tekniikka, MySQL, PHP, tietojärjestelmäarkkitehtuuri, Ohjelmistojen testaus, Web hosting, Verkkosivun hallinta, Verkkosivujen testaus

Näytä lisää: 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

Tietoa työnantajasta:
( 37 arvostelua ) United States

Projektin tunnus: #3064210

6 freelanceria on tarjonnut keskimäärin 71$ tähän työhön

gkalish

See private message.

$85 USD 3 päivässä
(244 arvostelua)
6.3
shahramjaved0075

See private message.

$59.5 USD 3 päivässä
(11 arvostelua)
3.5
itsali0009

See private message.

$42.5 USD 3 päivässä
(14 arvostelua)
3.1
lkshakya

See private message.

$68 USD 3 päivässä
(17 arvostelua)
3.2
tatasthuinfotech

See private message.

$85 USD 3 päivässä
(13 arvostelua)
3.3
homi12345

See private message.

$85 USD 3 päivässä
(9 arvostelua)
2.7