RE: Conceptually, what's the difference between ProjTransPosting, and the Proj___TransSale Tables?
Hello,
I'm going to try to answer at your question: each project can have a different type of transaction (as you have understood, we can have items, hours, expenses, and fee). However, not all transaction can create a general ledger voucher entry.
Example: you create items request by you haven’t already posted the packing slip. So, to sell all the transactions of a project, you can see the tables:
Items
- ProjItemTrans;
- ProjItemTransCost [internal cost]
- ProjItemTransSale [sales price]
Labor
- ProjEmplTrans;
- ProjEmplTransCost [internal cost]
- ProjEmplTransSale [sales price]
Expense
- ProjCostTrans;
- ProjCostTransCost [internal cost]
- ProjCostTransSale [sales price]
Fee
- ProjRevenueTrans
- ProjRevenueSales [internal cost]
So, see only the transaction that they have generated a general voucher entry, you can see the: ProjTransPosting.
Let me know if I have helped you.
Kind regard,
Giorgio Bonacorsi
