I can create WIP, Revenue, & Billed numbers two different ways:
Using:
ProjTransPosting
Or a combination of 3 tables (for the 3 transaction types we currently utilize)
ProjCostTransSales (Expense)
ProjEmplTransSale (Labor)
ProjRevenueTranssale (Fees)
To my understanding, both routes should be able to get the same answer. In our case, they don't - because of some messed up imported transactions from when we implemented FO.
So OK, if I want to match [Fee Management]'s #s in FO, I need to go the ProjTransPosting route for WIP, Billed, & Revenue.
My question is:
What's the difference? I understand the 3 tables, I don't quite get how ProjTransPosting differs. And say, in the 3 tables - each transid is unique, but a transid can appear multiple times in ProjTransPosting.