3,027
Hi
In a report i have source table G/L Entry . In C/al Code i want sorting by Transaction in Ascending , Amount Descending . How it can be done
I am trying below code but it is not working
"G/L Entry".SETCURRENTKEY("Transaction No." , Amount);
"G/L Entry".SETASCENDING(Amount,Descending);
Thanks
*This post is locked for comments
I think adding a key in the table can't be a good solution. I suggest just look into the two reports which i've mentioned already will serve your query.
To sort for two fields you need to have these two fields in a key.
An alterntive is to use code and "re-arrange" the records in code. Customer Top 10 list is an example but I suggest to use a more easy way. If you want to do that in code, first sort by Transaction No. (this is a standard key field and you can sort as I've suggested before).
Then, loop through these sorted records, calculate the Amount field and use a temporary table to save the records in the right order.
My suggestion: to be simple and use few lines of code, just add a new key to the Customer table. This is a quite common operation and more performant than using strange tricks.
Hi Stefano
Isn't it possible without making any changes in the table
Thanks
SETASCENDING OR ASCENDING are the only 2 keywords available for this.
Stefano explained how to use either of them!!
I think there is no need to change the table definition when we could get the required result without any table change. The logic of the reports I've mentioned already will help to solve your issue.
To order records, you need to:
1) create a key that you want on the original table (or use an existing key)
2) Use SETCURRENTKEY to use the selected key
3) Use ASCENDING (or SETASCENDING) to set the key order
For example:
GLEntry.SETCURRENTKEY(GLEntry."Transaction No.");
GLEntry.ASCENDING(TRUE);
or
GLEntry.SETCURRENTKEY(GLEntry."Transaction No.");
GLEntry.SETASCENDING("Transaction No.",TRUE);
For the Amount field, create a key that is "Transaction No." and Amount.
Hi
Could not get . secondly i have existing key on Transaction No only.
Thanks
Hi,
Look into the base report 1. Customer - Top 10 List or 2. Inventory - Top 10 List.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (