Custom amount field to append to the sales order total

@vineela95  Below is the code to calculate and automatically add the amount to the Sales Order Total field.

Hope this helps!

    public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry>
    {
        [PXMergeAttributes(Method = MergeMethod.Append)]
        [PXRemoveBaseAttribute(typeof(SOTaxAttribute))]
        [SOTaxRCExtensionAttribute(typeof(SOOrder), typeof(SOTax), typeof(SOTaxTran), TaxCalc = TaxCalc.ManualLineCalc)]
        protected virtual void _(Events.CacheAttached<SOLine.taxCategoryID> e) { }

        [PXMergeAttributes(Method = MergeMethod.Append)]
        [PXRemoveBaseAttribute(typeof(SOOrderTaxAttribute))]
        [SOOrderTaxRCExtension(typeof(SOOrder), typeof(SOTax), typeof(SOTaxTran), TaxCalc = TaxCalc.ManualLineCalc)]
        protected virtual void _(Events.CacheAttached<SOOrder.freightTaxCategoryID> e) { }

        #region Event Handlers
        protected void SOOrder_RowUpdated(PXCache sender, PXRowUpdatedEventArgs e, PXRowUpdated baseEvent)
        {
            baseEvent?.Invoke(sender, e);
            if (!sender.ObjectsEqual<SOOrderExt.usrAdditionalCharge>(e.OldRow, e.Row))
            {
                SOOrderTaxRCExtensionAttribute.Calculate<SOOrder.freightTaxCategoryID>(sender, e);
            }
        }
        #endregion
    }
    public class SOTaxRCExtensionAttribute : SOTaxAttribute
    {
        public SOTaxRCExtensionAttribute(Type ParentType, Type TaxType, Type TaxSumType)
            : base(ParentType, TaxType, TaxSumType)
        {
        }
        #region Event Handlers
        protected override void CalcDocTotals(PXCache sender, object row, decimal CuryTaxTotal, decimal CuryInclTaxTotal, decimal CuryWhTaxTotal, decimal CuryTaxDiscountTotal)
        {
            base.CalcDocTotals(sender, row, CuryTaxTotal, CuryInclTaxTotal, CuryWhTaxTotal, CuryTaxDiscountTotal);
            decimal AdditionalCharge = (decimal)(ParentGetValue<SOOrderExt.usrAdditionalCharge>(sender.Graph) ?? 0m);
            decimal CuryDocTotal = AdditionalCharge + (decimal)(ParentGetValue<SOOrder.curyOrderTotal>(sender.Graph) ?? 0m);
            ParentSetValue<SOOrder.curyOrderTotal>(sender.Graph, CuryDocTotal);
        }
        #endregion
    }
    public class SOOrderTaxRCExtensionAttribute : SOOrderTaxAttribute
    {
        public SOOrderTaxRCExtensionAttribute(Type ParentType, Type TaxType, Type TaxSumType)
            : base(ParentType, TaxType, TaxSumType)
        {
        }
        #region Event Handlers
        protected override void CalcDocTotals(PXCache sender, object row, decimal CuryTaxTotal, decimal CuryInclTaxTotal, decimal CuryWhTaxTotal, decimal CuryTaxDiscountTotal)
        {
            base.CalcDocTotals(sender, row, CuryTaxTotal, CuryInclTaxTotal, CuryWhTaxTotal, CuryTaxDiscountTotal);
            decimal AdditionalCharge = (decimal)(ParentGetValue<SOOrderExt.usrAdditionalCharge>(sender.Graph) ?? 0m);
            decimal CuryDocTotal = AdditionalCharge + (decimal)(ParentGetValue<SOOrder.curyOrderTotal>(sender.Graph) ?? 0m);
            ParentSetValue<SOOrder.curyOrderTotal>(sender.Graph, CuryDocTotal);
        }
        #endregion
    }

Hi, @darylbowman   "I implemented this quite some time ago and thoroughly tested all the scenarios, including the suggestions you mentioned earlier, but unfortunately, it didn't work for me.

Consequently, I/my team reached out to the Acumatica team and shared this sample. Could you kindly provide a concise code snippet, preferably under 10 lines, that fulfills this requirement? Your assistance will greatly benefit everyone here.

Yes @darylbowman  That’s right! It won’t work in on cases.

Therefore, I collaborated closely with the Acumatica team to ensure comprehensive support for every scenario, and after dedicated efforts, we successfully achieved functionality across all scenarios."

@Naveen Boga  Thank you for the response. I tried your solution and I noticed that the totals are updating correctly, however, when I try to apply a payment against the order, I receive “The order cannot be applied, the specified combination of the order type and order number cannot be found in the system.” error. I remove that code and don’t receive the error. Very confused as to why this error is occurring. 

Hi @Naveen Boga - were you able find anything for @vineela95! Thank you!

Hi @vineela95  I have checked it but seems like there is a change in the Base code in the new version. I request you to check with the Acumatica team and confirm this logic.

Hi @vineela95 were you able to find a solution? Thank you!