Welcome to software24x7
Be part of the community and join us today!
0 friends . 0 photos
Determine GP Lines Per Day
The queries identify the number of unique transactions and the number of lines in the table. Dividing one by the other will reveal the average lines per transaction.
This query reveals the Number of General Ledger Journal Entries on a given day and the number of overall lines.
DECLARE @Date as DATETIME
SET @Date = '04/12/2017'
select sum(a.Journal_Entries) GL_Transactions from (
select count(c.GL_Transactions) Journal_Entries from (Select COUNT(jrnentry) GL_Transactions FROM GL20000 where TRXDATE = @Date group by JRNENTRY) c
select count(c.GL_Transactions) Journal_Entries from (Select COUNT(jrnentry) GL_Transactions FROM GL30000 where TRXDATE = @Date group by JRNENTRY) c ) a
/*GL Transaction Lines*/
select SUM(a.GL_Trx_Lines) GL_Trx_Lines from (
Select count(JRNENTRY) GL_Trx_Lines FROM GL20000 where TRXDATE = @Date group by TRXDATE
Select count(JRNENTRY) GL_Trx_Lines FROM GL30000 where TRXDATE = @Date group by TRXDATE) a
on August 26 at 4:09
Login or register to post your comment
Login to your account
Forgot your password?
Forgot your username?
Create an account
Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.
Please enter the email address associated with your User account. Your username will be emailed to the email address on file.