How to get primary key field value from RowInserted event

Question

Hello,

I’m new to Acumatica customisation so I’m looking for some pointers.

I want to write some data to a custom table when a new record is inserted into the SOShipLine table.

My custom table is similar to the SOShipLineSplit table with 3 primary keys of ShipmentNbr, LineNbr and PickNbr.

I want to enter data into my table when a new row is created in SOShipLine so I’m using the RowInserted event - SOShipLine_RowInserted(PXCache sender, PXRowInsertedEventArgs e).

I’ve found that in the RowInserted event I cannot get access to the field values for ShipmentNbr and LineNbr, I guess this is because the data hasn’t been submitted to the database yet. But without these values I cannot set the values for ShipmentNbr and LineNbr in may custom table either.

I’ve tried quite a few idea to get the key values from the new record but I’m starting to think that perhaps I’m taking the wrong approach to this problem. Perhaps I’m using the wrong event, or maybe I should be looking to set up parent/child relationships between SOShipLine and my custom table.

Any ideas are welcome.

Thanks

Steve

icon

Best answer by Gabriel Michaud 20 October 2021, 14:37

View original

Gabriel Michaud · Accepted Answer

Hi @stephenward03,You are right, the field values are not yet available because the record hasn’t been physically inserted in the database at this point.The good news is that you don’t need to deal with this logic yourself, as long as you set the necessary attributes on the DAC fields.One of the ways I learned how to program for Acumatica (beside going through the complete training curriculum) is by looking at the source code of other modules that employ a pattern similar to the one I’m looking for. In your case you already pointed out that you want a table similar to SOShipLineSplit, so you can take a look at how the DAC is declared by usingthe Source Code browserin Acumatica.Let’s take a look at the ShipmentNbr field in SOShipLineSplit (I simplified it so that we can focus on the important stuff):[PXDBString(15, IsKey = true)][PXDBDefault(typeof(SOShipment.shipmentNbr))][PXParent(typeof(FK.Shipment))][PXParent(typeof(FK.ShipmentLine))]public virtual String ShipmentNbr { get; set;}It’s part of the key fields of the table, so it is marked with IsKey=True. This is very important, Acumatica will not let you have multiple rows with the same key values in a cache.PXDBDefault is how the system will default the value when it is inserted in the database; it will retrieve the value assigned to SOShipment.ShipmentNbr. You should never have to set this field yourself.Important: for LineNbr, another key field, you’ll see that PXDefault is used instead of PXDBDefault; that’s because the line number is assigned right away, not on database insertion. Don’t confuse this field with ShipLineNbr, which is there to ensure each shipment split has a unique line number.PXParent is there to ensure the record automatically gets deleted (cascade delete) if one of the parent records gets removedIf you need to insert a row in your table automatically when a new row is added to SOShipLine, you can insert it into the cache without setting all the fields which are defaulted by the system. I don’t remember 100% if a row becomes the current row of its respective cacheautomatically before RowInserted is invoked; if not you will have to make it the current row of the SOShipLine cache before you insert your row.If someone here can confirm the behaviour I wouldappreciate :)

Naveen Boga · Answer

Hi @stephenward03 I’m NOT sure why you wanted to insert the details into your custom table on RowInserted event.

You can event write this logic in persist delegate, while saving the this persist delegate will invoke and write a logic to fetch and insert the details into your custom table.

Please find the sample code for your reference.


 public class SOShipmentEntryExt : PXGraphExtension<SOShipmentEntry>
    {

 public delegate void PersistDelegate();
        [PXOverride]
        public void Persist(PersistDelegate del)
        {
          del();

           // logic here for inserting the details into your custom table.

         }   
}

Hope this helps!!

How to get primary key field value from RowInserted event

3 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded