Skip to main content
Question

CRActivity and Contract Relations

  • May 22, 2024
  • 0 replies
  • 44 views

Forum|alt.badge.img

Hi Acumatica Community;

decimal actualRevenueAmount = PXSelectGroupBy<PMProjectRevenueTotal,
Where<PMProjectRevenueTotal.projectID, Equal<Current<Contract.contractID>>>,
Aggregate<Sum<PMProjectRevenueTotal.curyAmount>>>
.Select(Base)
.RowCast<PMProjectRevenueTotal>()
.Sum(rb => rb.CuryAmount ?? 0);

I’m developing a code. I need to connect CRActivity and Contact Dacs. There was not direct Relationship between those two. I need to get CRActivity.PercentCompletion Like above code. Can anyone help me.