beginning balance report

[BrotherOmar]

I'd like to create a SQL query to grab the beginning balances of our P&L accts. Any idea what table & column i should grab?

Thanks

----
Tell 'em Omar back!

 

[childofnight]

I'm no SQL expert by any means, but this seems to do the trick:

SELECT *
FROM GL20000 INNER JOIN
GL00100 ON GL20000.ACTINDX = GL00100.ACTINDX AND GL20000.SOURCDOC = 'BBF' AND GL00100.PSTNGTYP = '0'

Although I think that GP business logic is that you wouldn't have opening balances on your P + L accounts ?(i.e: this would not return any results - if you change the last expression to PSTNGTYP = '1' then you will get the balance sheet transactions returned) Do you really have beginning balances on your profit and loss accounts?

Luke

 

[BrotherOmar]

Luke,

there may be an account which didn't get zero'ed out so i want a report to verify that all accts did indeed have a zero beginning balance.

thanks for the tip.

----
Tell 'em Omar back!