USP_REPORT_SALESBYPAYMENTMETHOD

Parameters

Parameter Parameter Type Mode Description
@FROMDATE datetime IN
@TODATE datetime IN
@CURRENTAPPUSERID uniqueidentifier IN
@SELECTEDAPPUSERID uniqueidentifier IN

Definition

Copy

create procedure dbo.USP_REPORT_SALESBYPAYMENTMETHOD
(
    @FROMDATE datetime = null,
    @TODATE datetime = null,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @SELECTEDAPPUSERID uniqueidentifier = null
)
as
    set nocount on;

    declare @REPORTUSER uniqueidentifier = null;

    if @SELECTEDAPPUSERID is null
        set @REPORTUSER = @CURRENTAPPUSERID;
    else
        set @REPORTUSER = @SELECTEDAPPUSERID;

    exec dbo.USP_SALESBYPAYMENTMETHODREPORTDATA @FROMDATE, @TODATE, @REPORTUSER;

    return 0;