@girik06  Please use the Header DAC in PXImport

>PXImport(typeof(SOShipment))]
        ÂPXViewName(Messages.SOShipLine)]
       public PXSelect<SOShipLine, Where<SOShipLine.shipmentNbr, Equal<Current<SOShipment.shipmentNbr>>>, OrderBy<Asc<SOShipLine.shipmentNbr, Asc<SOShipLine.sortOrder>>>> Transactions;

@Naveen Boga I gave Header DAC in PXImport 

But Its not updating values(Descr,Ship Qty) from 2nd Line.

@girik06,

Do you have the Add Row(+ symbol) enabled in the Shipments Details grid? Are you using 23R1?

@Vignesh Ponnusamy 

Add row disabled and using 22R1.

Hi @girik06 

I can able to enable the 'Add Row' button in the Details section, but I've noticed that when I upload a file, it doesn't update the records. The issue appears to be that the uploaded file is not displaying the KEY fields, causing the system to be unaware of how to update the records, since those fields are disabled at line level

From my perspective, here are the available options:

1. Consider using an import scenario instead of investing additional effort in coding.
2. Enable the Key fields, which should resolve the issue with the File Upload feature in 23 R1.
3. Explore the possibility of creating a custom File Uploader specifically designed to handle Excel files, ensuring that it can both upload the file and update the associated records."

screenshot for reference.

 

Hi @Naveen Boga 

Base Upload Button didn’t work. So created new custom upload button to update the values from excel..
Values are Updating.

@girik06  Awesome !! Thanks a lot for sharing the update.