Fetch sales order totals by x++ code. (Total Discount, Subtotal Amount & Invoice Amount) AX7 (Dynamics 365 for Operations)
Hi,
Below job gives Sales Total details i.e. fetching sales order totals (Total Discount, Subtotal Amount & Invoice Amount)
static void ShyamSalesTotalJob(Args _args)
{
//Total Discount from Sales Totals form
SalesTable salesTable1;
salesTable1= SalesTable::find(“000746”,false);
SalesTotals salesTotals;
salesTotals = SalesTotals::construct(salesTable1, salesUpdate::All);
container displayFields;
displayFields
= SalesTotals::displayFieldsServer(salesTable1,SalesUpdate::All,salesTotals.CurrencyCode());
DiscAmount totalDisc=0;RealBase subTotal=0;AmountCur invoiceAmount=0;
//Total Discount
totalDisc =
conpeek(displayFields, TradeTotals::posEndDisc());
info(Strfmt("Total discount %1", totalDisc));
//Subtotal Amount
subTotal=conpeek(displayFields, TradeTotals::posBalance());
info(Strfmt("Subtotal
Amount %1", subTotal));
//Invoice Amount
invoiceAmount
=conpeek(displayFields, TradeTotals::posTotalAmount());
info(Strfmt("Invoice
Amount %1", invoiceAmount));
}
Comments
Post a Comment