Can I tell if an Expenditure Item has been burdended via SQL?
Content
Hi,
I'm trying to work out how to tell, via SQL, if an Expenditure Item has been burdened via Projects > Costs > Tasks > Generate Burden Costs.
For example - I have a Project which has an individual Burden Schedule with a Burden Multiplier set to 0.2.
I created 2 Miscellaneous Cost Expenditure Items via ADFDI with a total value of 300.
I then went to Projects > Costs > Tasks > Generate Burden Costs and set the Parameters as follows:
- Business Unit: My BU
- From and To Project Number: 99991234
- Exp Item Through Date: 21/03/2020
- Transaction Status: New
That created a new Exp Item with an Exp Item Type of "Overheads" with a value of 60, which is 20% of 300.
Tagged:
0