30
Currently running SL 2011 FP1, in the Purchase Order Screen 04.250.00 the grid is sorted based on the Tstamp. Is there a way to change the sort to the LineRef.
Thanks for your help in Advance
Jesse Chambers
*This post is locked for comments
I have the same question (0)
Hi Jesse,
I'm wondering why you think this grid is sorted by the Tstamp?
Most SL screens that display data in a grid use a control called SAFGrid to display the grid on the standard screens. The SAFGrid is not customizable.
However, I ran a trace to see if it was apparent how the screen sorts the Purorddet records when the screen is loaded and a PO number is selected. I found this:
EXEC purorddet_ponbr '000082',-32768,32767
The statement is:
Select * from PurOrdDet where PONbr = @parm1
and LineNbr between @parm2beg and @parm2end
order by PONbr, LineNbr
So it seems that the stored procedure Purorddet_ponbr is sorting by the LineNbr. You mentioned that you want it to sort by LineRef. When you save a PO, the system numbers then according to how they are entered into the grid. So the LineRef appears to be the same order as the LineNbr. At least in my testing this appeared to be the case. You could try and customize the above stored procedure to sort the lines a different way and see what happens.
Let me know how else I can help.
Share
Report
All responses (
Answers (
