Next, Previous, First, Last Record buttons on Sales Order

Votuc

I found a great blog on how to code the First, Next, Previous, and Last navigation buttons in the RTC here:
http://midynav.blogspot.com/2009/09/first-previous-next-and-last-buttons_03.html


The problem is when I put these into the Sales Order Page it brings up ALL listings in the Sales header on the Sales order Page (all quotes too).

How can I change this code to filter on sales orders only? I need a WHERE "Document Type" = Order

//NEXT Button
RESET;
SETFILTER("No.",'>%1',"No.");
IF NOT FINDFIRST THEN BEGIN
  SETRANGE("No.",xRec."No.");
  IF FINDFIRST THEN;
END;

mohana_cse06

Votuc wrote:

The problem is when I put these into the Sales Order Page it brings up ALL listings in the Sales header on the Sales order Page (all quotes too).
How can I change this code to filter on sales orders only? I need a WHERE "Document Type" = Order

I didnt get tbis point.
Are you getting these icons in Quote pages or When you click next, Quotes are also showing in Order?
BTW, in which page you have modified?

thmartin

Hi,

I think in your case you might want to remove the RESET;
Or do a SETRANGE on the Document Type.

Votuc

thmartin wrote:

Hi,

I think in your case you might want to remove the RESET;
Or do a SETRANGE on the Document Type.

removing the RESET worked for the "NEXT" button. Now I have another problem.

For the "FIRST" and "LAST" buttons I need to somehow filter on only sales orders

//First Button
RESET;
IF FINDFIRST THEN
  SETRANGE("No.","No.");

RESET;
IF FINDLAST THEN
  SETRANGE("No.","No.");

I am confused on how to do the SETRANGE to accomplish this. Would appreciate some examples. [-o<

mohana_cse06

try this code

Votuc

mohana_cse06 wrote:

try this code

That works PERFECTLY! Thank you!! \:D/

mohana_cse06

welcome