
Hi, does anyone know which table in GP has the beginning or ending balance info for a particular account? Thanks for your help!
*This post is locked for comments
I have the same question (0)Hello,
It depends on what you are looking for. A few tables to consider using are
GL00105 - Account Index
GL10110 - Account Current Summary
GL10111 - Account History Summary
Period 0 would be beginning balances
You would have to sum 0-12 for ending balance
This is summary data, so you may want to run a reconcile to ensure this data is up to date based on transactions (gl20000 and gl30000).
Thanks
Ryan