Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

beginning balance report

Status
Not open for further replies.

BrotherOmar

Technical User
Feb 2, 2006
42
US
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!
 
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
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top