Skip to main content
Answer

Persisting PXProjection not saving multiple tables

  • February 1, 2024
  • 4 replies
  • 113 views

Forum|alt.badge.img+1

I am trying to make some changes to the TimeCardMaint screen. My goal is to join and load both the PMTimeActivity and CRActivity in one projection while being able to persist both.

However when I hit save PMTimeActivity is persisted while CRActivity is not, I get no errors so I am confused as what to do next. Can you please advise.

 

Attached is the projection EPTimecardDetail and below is the view in the DAC.

     

  [PXViewName("Time Card Detail")]
        public PXSelect<EPTimecardDetail,
            Where<PMTimeActivity.trackTime, Equal<True>>,
            OrderBy<Desc<EPTimecardDetail.date>>> Activities;

 

Also I have reviewed Understanding Acumatica's PXProjection Attribute | Acumatica Cloud ERP several times.

Best answer by Leif

The issue was that I needed to manually associate both records with via the NoteID and RefNoteID  fields.

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • February 6, 2024

@Leif  Have you tried with Persistent property, which mentioned in the above link

 

 


Forum|alt.badge.img+1
  • Author
  • Varsity I
  • February 9, 2024

I have, when reviewing the Projection class Persistent is set to true whenever you provide a persistent type list. In your example you must bc you did not provide the list, i do have the list.

 


Forum|alt.badge.img+1
  • Author
  • Varsity I
  • Answer
  • February 27, 2024

The issue was that I needed to manually associate both records with via the NoteID and RefNoteID  fields.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • February 27, 2024

Thank you for sharing your solution with the community @Leif!