X hits on this document

566 views

0 shares

0 downloads

0 comments

79 / 96

Flexible Solutions, Inc. – GP Reports Viewer

79

3.

Once the GPRV00142 table has been added to the report, a condition must be added that uses the four parameters created above. This is necessary in order for the report to print the correct statements for the current user. In Crystal Reports this is accomplished by adding a record selection formula. The minimum required selection formula is shown below:

{?USERID} = {GPRV00142.USERID} and { ? S T A T E M E N T I D } = { G P R V 0 0 1 4 2 . G P R V _ S T A T E M E N T I D and if Trim({?CUSTNMBR}) = "" then }

if {?PRINTALL} = true then {GPRV00142.GPRVSelected} = 1 else {GPRV00142.GPRVSelected} = 1 and {GPRV00142.Valid} = 0 else {?CUSTNMBR} = {GPRV00142.CUSTNMBR}

In SQL Server Reporting Services you will need to modify your dataset to use the four newly created parameters and some additional required code by adding a WHERE clause: WHERE (GPRV00142.USERID = @USERID) AND (GPRV00142.GPRV_StatementID = @STATEMENTID) AND (GPRV00142.GPRVSelected = 1) AND ((RTRIM(@CUSTNMBR) = ’’ AND @PRINTALL = 1) OR (RTRIM(@CUSTNMBR) = ‘’ AND @PRINTALL = 0 AND GPRV00142.Valid = 0) OR (@CUSTNMBR = GPRV00142.CUSTNMBR))

PRINTING CUSTOMER STATEMENTS

The GP Reports Viewer Statements window is used to select the customers that you would like to print statements for and also to determine whether to preview, print and/or email the customer statements. There are several ways to get to the GP Reports Viewer Statements window:

From the main Dynamics GP menu:

Reports >> Print Customer Statements

From the Sales Routines menu:

GP >> Tools >> Routines >> Sales >> Print Customer Statements

If you have chosen to replace the Dynamics GP Print Receivables Statements window with GP Reports Viewer:

GP >> Tools >> Routines >> Sales >> Statements

Document info
Document views566
Page views566
Page last viewedSun Jan 22 18:38:08 UTC 2017
Pages96
Paragraphs1592
Words22003

Comments