Skip to main content
Solved

Adding field from subsidiary DAC to Form

  • February 25, 2025
  • 3 replies
  • 34 views

Forum|alt.badge.img

The Customers form already displays a few fields that are actually stored on the Default Customer Location record (like most of the detail on the Shipping tab).  I had a custom field (in DAC, not a UDF) on the Locations table for a drop ship ID that our primary vendor provides for each customer location (Location.usrDropShipID).  I’d like to add the drop ship ID for the Primary Location on the customer to the Shipping tab, so that we can populate it during customer setup, just like we do with default warehouse and default Ship Via.

Since the screen is already pulling in data from the default location record, I’m hoping this is as simple as (somewhere) defining this additional field for the form, and then adding it to the Shipping Instructions group just like if I were adding in a stock field from the Customer record.

Best answer by darylbowman

If I’m following correctly, if you find a section of fields already from the Location table, you should be able to add your custom field into that section. If you are hoping to add it somewhere else, you can either add a ‘form’ element which allows specifying the DataMember property (it should be DefLocation) which will allow you to add the field easily, or I think you could add a different field of the correct type and change the DataField property to DefLocation.UsrDropShipID.

View original
Did this topic help you find an answer to your question?

3 replies

darylbowman
Captain II
Forum|alt.badge.img+13
  • 1698 replies
  • Answer
  • February 25, 2025

If I’m following correctly, if you find a section of fields already from the Location table, you should be able to add your custom field into that section. If you are hoping to add it somewhere else, you can either add a ‘form’ element which allows specifying the DataMember property (it should be DefLocation) which will allow you to add the field easily, or I think you could add a different field of the correct type and change the DataField property to DefLocation.UsrDropShipID.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 27 replies
  • February 25, 2025

That’s what I was hoping, but I’m probably missing some simple piece.  The “Shipping” tab on AR303000 has a Form element already bound to the DefLocation datamember.  If I go into the Add Data Fields tab in Screen Editor on that form element or anything below it, my custom fields aren’t listed there (I have about half a dozen fields I’ve added to the CR.Location DAC).  I’m guessing I need to extend the DefLocation Datamember, and add the field.  That’s just a guess, though.


darylbowman
Captain II
Forum|alt.badge.img+13

PX.Objects.CR.Location is a projection. The dbo.Location table is reflected in the PX.Objects.CR.Standalone.Location DAC. You’ll need to add your new field definition to a cache extension of each DAC. Extensions of projections need to include BqlTable = typeof(*fieldType*) in the field definition.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings