web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

creating sales order not updating totals

(0) ShareShare
ReportReport
Posted on by 70

i made custom made sales quote but when i click create order everything works but totals are not updating the way they should and they stay 0

any suggestions? it seems that they are calculated fields

I have the same question (0)
  • Suggested answer
    THE Italian Profile Picture
    Microsoft Employee on at

    You should check the property update propagation and mimic exactly what the other documents (sales quote / order) does in the standard.

  • samerabd Profile Picture
    70 on at

    i solved this but i had to add a button and call a local procedure called redistribute totals but it doesn't work if you have not open the page already and added the records like when i create a sales order, i'll check what you suggested

  • Terrance Morgan Profile Picture
    515 on at

    Updating tax amount in the sales order field is not a good idea. CuryTaxTotal field in sales order is calculated field. It is calculated from SOTaxTran lines. So, in order to update tax amount in sales order you actually need to insert SOTaxTran lines into Taxes view of the SOOrderEntry graph.

    Something like that:

    //indicate that taxes are inserted in manual mode

    TaxAttribute.SetTaxCalc<SOLine.taxCategoryID>(graph.Transactions.Cache, null, TaxCalc.ManualCalc);

    // insert SOTaxTran

    SOTaxTran newTaxTran= new SOTaxTran();

    newTaxTran.TaxRate = 0.1; //put your actual values here

    newTaxTran.CuryTaxableAmt = 100; //put your actual values here

    newTaxTran.CuryTaxAmt = 10; //put your actual values here

    var taxTran = graph.Taxes.Insert(newTaxTran);

    --

    Terrance

    CRM Admin | Apps4Rent

  • samerabd Profile Picture
    70 on at

    i fixed it by using RedistributeTotalsOnAfterValidate()  on  trigger OnAfterGetCurrRecord() and it works very well

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,028 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,121 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 669 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans