I have created a new custom field in SOOrder, I want to retrieve SalesPerson.descr from SalesPerson table but not showing value. I want SalesPerson Description insert it into the SOOrder table.
[PXDefault(typeof(Search<SalesPerson.descr,
Where<SalesPerson.salesPersonID, Equal<Current<SOOrder.salesPersonID>>>>),
PersistingCheck = PXPersistingCheck.Nothing)]
[PXDBString(60)]
[PXUIField(DisplayName="SalesPerson Description")]
Best answer by darylbowman
Simply add the following attribute to the list of attributes you already have:
[PXFormula(typeof(Default<SOOrder.salesPersonID>))]This will cause the FieldDefaulting event to run for your custom field whenever SalesPersonID is updated.
The field is empty because PXDefault runs on insert, and when the SOOrder is created, SalesPersonID is null. After you update that field, PXDefault doesn’t trigger again.
I think you should remove the PXDefault attribute and instead create a Graph Extension with a FieldUpdated event handler like this:
+15
Simply add the following attribute to the list of attributes you already have:
[PXFormula(typeof(Default<SOOrder.salesPersonID>))]This will cause the FieldDefaulting event to run for your custom field whenever SalesPersonID is updated.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
