Skip to main content
Question

CRActivity and Contract Relations

  • 22 May 2024
  • 0 replies
  • 15 views

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.

Be the first to reply!

Reply