SetCurrentKey

(0) Share

Report

Posted on by jsshivalik

3,099

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 have the same question (0)

All responses (8)

Answers (0)

subrata.bauri 1,144 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Look into the base report 1. Customer - Top 10 List or 2. Inventory - Top 10 List.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi

Could not get . secondly i have existing key on Transaction No only.

Thanks

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,959 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

SETASCENDING OR ASCENDING are the only 2 keywords available for this.

Stefano explained how to use either of them!!

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi Stefano

Isn't it possible without making any changes in the table

Thanks

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No