UFN_PDACCOUNTSYSTEM_ALLOWGLDISTRIBUTIONS

Determines if the supplied accounting system allows the use of GL distributions.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@PDACCOUNTSYSTEMID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_PDACCOUNTSYSTEM_ALLOWGLDISTRIBUTIONS
            (
                @PDACCOUNTSYSTEMID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin

                -- If @PDACCOUNTSYSTEMID is null then we will fall back on the default account system to get the setting.

                select @PDACCOUNTSYSTEMID=isnull(@PDACCOUNTSYSTEMID, ID) from dbo.pdaccountsystem where ISDEFAULT = 1

                declare @ALLOWGLDISTRIBUTIONS bit
                select 
                    @ALLOWGLDISTRIBUTIONS = ALLOWGLDISTRIBUTIONS
                from dbo.PDACCOUNTSYSTEM 
                where PDACCOUNTSYSTEM.ID = @PDACCOUNTSYSTEMID

                return @ALLOWGLDISTRIBUTIONS
            end