We want to update some incorrect Ext. Price on the Sales Order with already completed status.

@sharmaineongyaco56  Can you please let us know when you wanted to update Ext  Price field?

Hi @param2022 and @Naveen Boga, do you have a code that updates the Ext.Price for the Stock Items? Tia.

Glad that I helped you with the above code and thanks for sharing the update! @param2022 

@Naveen Boga that worked thank you.

Hi @param2022  Can you please try with the below code?

     protected void CROpportunityProducts_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e)
            {
                CROpportunityProducts row = (CROpportunityProducts)e.Row;
                CROpportunityProductsExt rowExtension = row.GetExtension<CROpportunityProductsExt>();
                if (row is null) return;
                InventoryItem inventoryItem = PXSelectorAttribute.Select<CROpportunityProducts.inventoryID>(cache, row) as InventoryItem;
                if (inventoryItem is null) return;
                InventoryItemCurySettings curySettings =
                     InventoryItemCurySettings.PK.Find(
                     this.Base, inventoryItem.InventoryID, rowExtension.UsrInventoryCuryId ?? "USD");

                bool isStkItem = inventoryItem.StkItem ?? false;
                if (!isStkItem)
                {
                    // get inventoryItemCurySettings extension
                    InventoryItemCurySettingsExt inventoryItemCurySettingsExt = curySettings.GetExtension<InventoryItemCurySettingsExt>();
                    if (rowExtension.UsrSelectedPriceModifier != 0 || rowExtension.UsrSelectedPriceModifier != null)
                    {
                        PriceModifier priceModifier = PXSelectorAttribute.Select<CROpportunityProductsExt.usrSelectedPriceModifier>(cache, row) as PriceModifier;
                        if (priceModifier != null)
                        {
                            var extPrice = row.CuryExtPrice;
                            decimal data = (decimal)priceModifier.Percentage / 100;
                            row.CuryExtPrice = rowExtension.UsrInternalExtCost + (data * rowExtension.UsrInternalExtCost);
                            cache.RaiseFieldUpdated<CROpportunityProducts.curyExtPrice>(row, extPrice);
                        }
                    }
                }
            }

@Naveen Boga plz see it below

protected void CROpportunityProducts_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e)
        {
            CROpportunityProducts row = (CROpportunityProducts)e.Row;
            CROpportunityProductsExt rowExtension = row.GetExtension<CROpportunityProductsExt>();
            if (row is null) return;
            InventoryItem inventoryItem = PXSelectorAttribute.Select<CROpportunityProducts.inventoryID>(cache, row) as InventoryItem;
            if (inventoryItem is null) return;
            InventoryItemCurySettings curySettings =
                 InventoryItemCurySettings.PK.Find(
                 this.Base, inventoryItem.InventoryID, rowExtension.UsrInventoryCuryId ?? "USD");

            bool isStkItem = inventoryItem.StkItem ?? false;
            if (!isStkItem)
            {
                // get inventoryItemCurySettings extension
                InventoryItemCurySettingsExt inventoryItemCurySettingsExt = curySettings.GetExtension<InventoryItemCurySettingsExt>();
                if (rowExtension.UsrSelectedPriceModifier != 0 || rowExtension.UsrSelectedPriceModifier != null)
                {
                    PriceModifier priceModifier = PXSelectorAttribute.Select<CROpportunityProductsExt.usrSelectedPriceModifier>(cache, row) as PriceModifier;
                    if (priceModifier != null)
                    {
                        decimal data = (decimal)priceModifier.Percentage / 100;
                        row.CuryExtPrice = rowExtension.UsrInternalExtCost + (data * rowExtension.UsrInternalExtCost);
                        row.ExtPrice = rowExtension.UsrInternalExtCost + (data * rowExtension.UsrInternalExtCost);
                    }
                }
            }
        }

Hi @param2022  Can you share the complete event code?

@Naveen Boga I have customization that updates the Ext.Price for the Non Stock Items. Here is the code snippet. The Ext.price is updated but not the Amount.

CROpportunityProducts row = (CROpportunityProducts)e.Row;

CROpportunityProductsExt rowExtension = row.GetExtension<CROpportunityProductsExt>();

row.CuryExtPrice = rowExtension.UsrInternalExtCost + (data * rowExtension.UsrInternalExtCost);

Hi @param2022  Yes

Ext.Price = Qty * Unit Price

Amount = Qty * Unit Prie - Discount Amount 

1. Do you have any customization with those fields? if yes, please unpublish and check to identify the root cause
2. I see there are no line level discounts but any Document level discount applied