Topic Options
#60242 - 03/04/19 01:55 PM GV and JC
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 923
Loc: GTA & North America (Remote Su...
Simple question (I hope): I am looking to create a View in GV based on all the Costs that have been posted in JobCosting, against various Jobs.
Problem is that I am not sure which table that data is maintained.
I initially selected J/C History Job Details, but it appears that this table had no records.
So, which table should I be selecting?
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#60243 - 03/04/19 03:22 PM Re: GV and JC [Re: Samuel Kopstick]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4521
Loc: Wynnewood, PA
J/C Job Details. Assuming you want jobs that have not been archived.

If you want only the costs, use Trx Type 5. The other Types code to billings, payments, and retainage.

Steve

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 111 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14500 Topics
70803 Posts

Max Online: 432 @ 01/20/25 10:17 PM
June
Su M Tu W Th F Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30