cancel
Showing results for 
Search instead for 
Did you mean: 

trying to create a flat table for general ledger

Former Member
0 Kudos

Hi im trying to create a slimier report to the general ledger report

In the general ledger report the accounts are grouped.

i'm trying to create the same table so that for each line i will see the account number and name

the start date should have the opening balance for the selected date

Will very much appreciate your help !

i'm using SAP BUSINESS ONE 8.82

Accepted Solutions (0)

Answers (1)

Answers (1)

zal_parchem2
Active Contributor
0 Kudos

Hello Itzik - check this SQL out from Neeut Dhami.

Look at the very bottom of this Wiki Page.

Neetu Dhami SQL

You might need to modify a bit, but does that seem like it might work for you???

Regards - Zal