Populating Custom Fields in Create Purchase Orders (PO505000)

Hello @JWS539 ,

After the Unwrap statements on lines 41 and 42, the soOrder and SoLine objects are populated with sum data but no others.  How is this controlled?

I am trying to understand “populated with sum data”. Unwrap simply extracts the given DAC record from the PXResult object so in this case it should return the SOOrder and SOLine records.

Please share more information if it is not returning a single record.

Hi Harish,

Thanks for reviewing this topic. 

My English wasn’t as good as it could have been.  What I intended to say  was “the SOOrder and SoLine objects are populated with data for some of the fields but not others”. 

The below is a screen shot of the contents of soOrder after the code runs on Line 41 ie.

var soOrder = PXResult.Unwrap<SOOrder>(rec)

You can see that some of the properties of the object are populated and some are not.  For example CustomerRefNbr is null.  This is one of the fields I’m looking to retrieve.

So, it looks like there is something some where that influences what Unwrap returns and what it doesn’t

My thinking is that I probably need to override the projection further somehow as this is probably what determines which fields get populated and which do not.  If so I’m not sure how?

Hopefully the above is a better explanation of the issue.

Thanks,

John.

Hi @JWS539 ,

Thanks for more details!

I checked the BQL Select. Since the SOOrder is not the primary DAC in the BQL, all field values will not be displayed. Creating a Projection DAC including all the fields needed is an ideal approach for you.

Creation of Project DAC Link: https://asiablog.acumatica.com/2018/03/pxprojection-sql-views-using-bql.html 

Hope this helps!

Hi,

Thanks Andrii and Harish for your help,

The last solution above worked really well.  On thing I discovered though was that it seems you can’t call the base method from within the delegate (no major).  My first attempt was:

which resulted in only the three columns

But the revision below worked:

So, problem solved.  Thanks for the help.

John

@JWS539 You can call the baseMethod() from the delegate, you just didn’t return values that you got from it.

I’ve created a small example here - https://dotnetfiddle.net/Q1Kpoc

It’s simplified and does not use Acumatica, but it operates in the same way.

Just copy-pasting the entire field set from the original method will work for you, but it’s a less future-proof solution - in case the field set is changed in the future, you might need to spend some time searching for this change and then updating your customization.

Hi Andrii,

Thanks for the example