How to arrange the Table view of the Posted Purchase Invoices in Ascending order?

(0) Share

Report

Posted on by KaryaNavTech

225

How to arrange the Table view of the Posted Purchase Invoices in Ascending order. I have given the Source table view property like

SORTING(No.) ORDER(Ascending) but the problem is it is not filtering the Posted orders in ascending order of No. I tried by creating new keys like "Posting date " in Purch. Inv. Header and tried to filter it with that but still, it is not correct.Is there any other way to do it ?

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (1)

Report

RE: How to arrange the Table view of the Posted Purchase Invoices in Ascending order?

Ascendong by primary key is the default order, as previously suggested.

The code for changing the order on a secondary key is YourTable.SETCURRENTKEY(Field1,FieldN), where Field1..FieldN are the fields of your secondary key defined at table level.

To change the ascending order (and set it as descending), use YourTable.ASCENDING(false).
KaryaNavTech 225 on at

Like (0)

Report

RE: How to arrange the Table view of the Posted Purchase Invoices in Ascending order?

Thanks for the responce, Can we write a CAL code to sort the posted invoices in ascending order OnOpenPage trigger? If so please suggest code
Bodhi 554 on at

Like (1)

Report

RE: How to arrange the Table view of the Posted Purchase Invoices in Ascending order?

It's Ascending by default

Please check OnOpenPage trigger

If you click caption/header No., it will switch between Ascending and Descending