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

Votuc · 2011-06-06

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 · 2011-06-06

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 · 2011-06-06

Hi,

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

Votuc · 2011-06-12

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 · 2011-06-12

try this code

Votuc · 2011-06-12

mohana_cse06 wrote:

try this code

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

mohana_cse06 · 2011-06-13

welcome

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

Answers

Categories