Sales Order Total by Code (x++)
Views (16549)
Sohaib Cheema
48,813
User Group Leader
Like
Share
ReportSummary:-
Vey frequently a question is asked, that is how to calculate sales order or PO total by x++ code.
Description/ Resolution:-
Using standard Dynamics AX you can navigate to any orders and select Totals/ sum button, which will bring you around totals.
Now when it is needed to have totals of any of control document, first look into AOT for built-in classes e.g. SalesTotals, PurchTotals (for purchase total). Using built-in classes is very important as AX involves too many assumptions for calculating total of orders. Just by having sum of lines directly at table may not work perfectly all the time.
Here goes the way to calculate total for sales order:
static void SalesTotalJobTest1(Args _args)
{
SalesTotals salesTotals;
SalesTable salesTable;
SalesLine salesLine;
TaxAmountCur salesAmt,taxAmount,amt1,discountAmt,totcharges,totOfOrder,contributionRatio;
Tax tax;
;
salesTable = SalesTable::find("000746");
salesLine = SalesLine::find(salesTable.SalesId);
salesTotals = SalesTotals::construct(salesTable);
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("Subtotal Amount %1",salesAmt ));
info(Strfmt("The tax amount is %1",taxAmount ));
info(Strfmt("The Discount is %1",discountAmt ));
info(Strfmt("Charges/ Markup %1",totcharges ));
info(Strfmt("Invoice Amount %1",totOfOrder ));
info(Strfmt("Contribution ratio %1",contributionRatio ));
}
Keep DAXing !
*This post is locked for comments