Just got back online @4:10 . ATT has been working since yesterday AM-- found problem in very sporadic service and an issue at their office. Seems better now.
Yes I've just seen your posts. I have concocted a few things while being offline.
I've been playing/relearning a few things. Here some detailed records generated from transactions.
I'm also attaching some jpgs.
Code:
EmplId |
Employee Name |
Payment Date |
Payment Number |
ID |
Payment Amount |
279900 |
Cody AkBare |
02/01/2015 |
1 |
33182 |
$1,350.51 |
279900 |
Cody AkBare |
16/01/2015 |
2 |
33186 |
$3,150.00 |
279900 |
Cody AkBare |
30/01/2015 |
3 |
33187 |
$3,150.00 |
279900 |
Cody AkBare |
13/02/2015 |
4 |
33185 |
$700.00 |
15463 |
Heesah Payne |
12/12/2014 |
1 |
33180 |
$27.00 |
15463 |
Heesah Payne |
26/12/2014 |
2 |
33188 |
$347.00 |
15463 |
Heesah Payne |
01/09/2015 |
3 |
33189 |
$347.00 |
15463 |
Heesah Payne |
23/01/2015 |
4 |
33190 |
$347.00 |
15463 |
Heesah Payne |
06/02/2015 |
5 |
33183 |
$1.99 |
12345 |
John Doe |
16/01/2015 |
1 |
2 |
$1,352.16 |
12345 |
John Doe |
30/01/2015 |
2 |
3 |
$4,507.20 |
12345 |
John Doe |
13/02/2015 |
3 |
4 |
$4,507.20 |
12345 |
John Doe |
27/02/2015 |
4 |
5 |
$4,507.20 |
12345 |
John Doe |
13/03/2015 |
5 |
32799 |
$4,507.20 |
12345 |
John Doe |
27/03/2015 |
6 |
32804 |
$4,507.20 |
12345 |
John Doe |
10/04/2015 |
7 |
32805 |
$4,507.20 |
12345 |
John Doe |
24/04/2015 |
8 |
32806 |
$4,507.20 |
12345 |
John Doe |
08/05/2015 |
9 |
32807 |
$4,507.20 |
12347 |
john Dough |
16/01/2015 |
1 |
33181 |
$1,352.16 |
12347 |
john Dough |
30/01/2015 |
2 |
33184 |
$12.78 |
2700 |
Test Employee |
16/01/2015 |
1 |
33151 |
$1,365.29 |
2700 |
Test Employee |
30/01/2015 |
2 |
33154 |
$3,100.01 |
2700 |
Test Employee |
13/02/2015 |
3 |
33155 |
$3,100.01 |
2700 |
Test Employee |
27/02/2015 |
4 |
33156 |
$3,100.01 |
I foresee a History fle to "save" transactions once they have been applied. Something like this
Code:
EmplId |
Employee Name |
ID |
PayGroup |
FirstPaymentDate |
FirstPaymentAmount |
LastPaymentDate |
LastPaymentAmount |
NumberPaymentsInBetween |
AmountofPaymentsInBetween |
HasBeenVerified |
AutoAssigned |
MovedToHistory |
2700 |
Test Employee |
1 |
testOK |
16/01/2015 |
$1,365.29 |
26/08/2015 |
$567.87 |
16 |
$68.88 |
-1 |
0 |
05/03/2015 2:01:55 PM |
279900 |
Cody AkBare |
1 |
testOK56 |
02/01/2015 |
$1,350.51 |
13/02/2015 |
$700.00 |
3 |
$3,150.00 |
-1 |
0 |
05/03/2015 2:33:30 PM |
12347 |
john Dough |
2 |
testfill |
16/01/2015 |
$1,352.16 |
30/01/2015 |
$12.78 |
1 |
$25.98 |
-1 |
0 |
05/03/2015 2:33:53 PM |
15463 |
Heesah Payne |
3 |
rrr |
12/12/2014 |
$27.00 |
06/02/2015 |
$1.99 |
4 |
$347.00 |
-1 |
-1 |
05/03/2015 2:34:11 PM |