Skip to main content

Code to get Sales order Total Value in Axapta | calculate total for sales order

This is sample Code to get Sales order Total Value in Axapta. You can try this job in Your Ax environment to check all vales . It will work well with open and Invoiced status sales order I hope it will help you and save your lot of time.

 static void SalesTotalAmountJOb(Args _args)  
   {  
     SalesTotals salesTotals;  
     SalesTable salesOrderTable;  
     SalesLine salesLine;  
     TaxAmountCur salesAmt,taxAmount,amt1,discountAmt,totcharges,totOfOrder,contributionRatio;  
     Tax tax;  
     ;  
     salesOrderTable = SalesTable::find("TD_SO_00069218");  
     salesLine = SalesLine::find(salesOrderTable.SalesId);  
     salesTotals = SalesTotals::construct(salesOrderTable);  
     tax = Tax::construct(NoYes::No);  
     salesAmt  = salesTotals.totalBalance();  
     taxAmount  = salesTotals.totalTaxAmount();  
     discountAmt = salesTotals.totalEndDisc();  
     totcharges = salesTotals.totalMarkup();  
     totOfOrder = salesTotals.totalAmount();  
     contributionRatio  = salesTotals.totalContributionRatio();  
     info(Strfmt("Sales Lines Amount %1",salesAmt ));  
     info(Strfmt("The VAT\tax amount is %1",taxAmount ));  
     info(Strfmt("The Discount Value is %1",discountAmt ));  
     info(Strfmt("Misc Markup %1",totcharges ));  
     info(Strfmt("Total Invoice Amount %1",totOfOrder ));  
     info(Strfmt("Total Contribution ratio %1",contributionRatio ));  
   }  

Popular posts from this blog

sales order Totals option getting error in Axapta

Problem: On  click sales order Totals option getting below error. Please help me how to solve it. Microsoft.Dynamics.Ax.Xpp.ClrErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ClrErrorException' was thrown. at Microsoft.Dynamics.Ax.Xpp.CLRInterop.MakeReflectionCall(Object instance, String methodName, Object[] parameters) at Dynamics.Ax.Application.TaxDocumentProxy.Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, String taxType, String taxComponent, Boolean , Boolean , Boolean ) in TaxDocumentProxy.sumByTaxAccountingProvider.xpp:line 15 at Dynamics.Ax.Application.TaxDocumentProxy.@Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, String _taxType, Boolean , Boolean ) at Dynamics.Ax.Application.TaxDocumentProxy.@Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, ...

X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )

Below is sample X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )      Args                       args = new Args();     CustInvoiceJour            custInvoiceJour;     SalesInvoiceJournalPrint   salesInvoiceJournalPrint;       select firstonly custInvoiceJour where custInvoiceJour.SalesId != '';       // Add record to be printed.     // In order to have the context table we need to set args.record().     args.record(custInvoiceJour);       salesInvoiceController = new SalesInvoiceController();     salesInvoiceController.parmReportName(         PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesOrderInvoice).getDefaultReportFormat());       salesInvoiceContract = salesInvoiceController.parmReportContrac...