sales detail in desc order

(0) Share

Report

Posted on by CU02060633-1

371

want to arrange the amount in desc order how to do that...

static void AMY_job14(Args _args)
{
CustInvoiceJour CustInvoiceJour;
CustTable CustTable;
AccountNum AccountNum;
AmountMST TotalSalesBalance;
while select CustTable

{
AccountNum = CustTable.AccountNum;

while select sum(InvoiceAmount) from CustInvoiceJour where CustInvoiceJour.InvoiceAccount == CustTable.AccountNum

{

info(strFmt("%1....%2",AccountNum,CustInvoiceJour.InvoiceAmount));
}
}
}

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

Mea_ 60,286 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Vinay Tak,

You can use order by, something like

while select sum(InvoiceAmount) from CustInvoiceJour order by InvoiceAmount desc where CustInvoiceJour.InvoiceAccount == CustTable.AccountNum

Please read this msdn article for details msdn.microsoft.com/.../aa656402.aspx

Was this reply helpful? Yes No
CU02060633-1 371 on at

Like
a
(0)

Report
Copy link

Link copied!

@ievgen Miroshnikov its not working it will not arrange in desc order when i apply this code

static void AMY_job15(Args _args)

{

CustInvoiceJour CustInvoiceJour;

CustTable CustTable;

AccountNum AccountNum;

AmountMST TotalSalesBalance;

while select CustTable

{

AccountNum = CustTable.AccountNum;

while select sum(InvoiceAmount)

from CustInvoiceJour

order by CustInvoiceJour.InvoiceAmount desc

where CustInvoiceJour.InvoiceAccount == CustTable.AccountNum

{

info(strFmt("%1....%2",AccountNum,CustInvoiceJour.InvoiceAmount));

}

}

}

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like
a
(0)

Report
Copy link

Link copied!

What do you mean under "not working" ? It's not selecting data in desc order or you have compile error ?

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like
a
(0)

Report
Copy link

Link copied!

it should be

order by InvoiceAmount desc

not

order by CustInvoiceJour.InvoiceAmount desc

Was this reply helpful? Yes No
CU02060633-1 371 on at

Like
a
(0)

Report
Copy link

Link copied!

it's not selecting data in desc order or acs order when i write the code " order by InvoiceAmount desc " also means there is no effect on the info log

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like
a
(1)

Report
Copy link

Link copied!
Hey Vinay Tak,

You are actually right. I totally forgot that you cannot do order by aggregated field in AX, it just ignores order by statement.

To overcome this issue you can create simple view that has 2 fields: invoice account and sum of invoice amounts with grouping by invoice account.

Now you can use next job:

CustInvoiceJourSumAmountView custInvoiceJour; while select SumOfInvoiceAmount, InvoiceAccount from custInvoiceJour order by SumOfInvoiceAmount desc { info(strFmt("%1....%2", custInvoiceJour.InvoiceAccount, custInvoiceJour.SumOfInvoiceAmount)); }

It will give you accounts ordered by total invoice amount in desc order.

Was this reply helpful? Yes No
CU02060633-1 371 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you @ievgen Miroshnikov for help..after making view its works.....thanku so much more more thing i learn today....

Was this reply helpful? Yes No