¿Its possible to get Purchaser Order Amount Totals Only with SQL Server Query?
If the answer is yes, ¿how can I do that?
If the answer is no, there is another way to do that and pass the data to SSRS out of dynamics ax 2012
I don’t want to use a solutions like that
public static void main(Args _args)
{
//Calculate totals per Purchase order
PurchTotals purchTotals;
PurchTable purchTable = PurchTable::find('PO.000018'); //Change the Purchase Order Id as per your system's data
AmountCur totalAmount;
purchTotals = PurchTotals::newPurchTable(purchTable);
purchTotals.calc();
totalAmount = purchTotals.purchTotalAmount();
info(strFmt("Purchase order: %1 - Total value: %2", purchTable.PurchId, totalAmount));
}
Please, I love the details.
