Hi Anand This is possible through Dimension Statement. ( GL--> Transactions-->Dimension Statement.)
Select Transaction as Ledger. Main Fous Code Should be the Dimension (eg Department). Give secondary focus as Ledger Account. This will give a TB For all Departments. Select the particular Department if you want it for a particular department. Hope this will solve your problem. Thanks & Regards Renjith On 9/2/09, Anand Rathi <dyne...@yahoo.com> wrote: > Hi, > > I have a requirement where we need to create Dimension wise Financial > Statement which will mean that a balance Trial Balance will be required per > Dimension Value. > > Example - If we consider there ar 4 values in one of the Dimension ( say > Purpose), then periodically 4 Trial Balance will be required based on these > 4 values of the Dimension. > > Please let me know if this is possible or you have any idea what all issues > may come to have such a report. > > I can see one scenario where it can fail: > A Sales Order with 4 different lines having diffeent values of Dimension in > each of the lines. Once this sales Order get invoiced, Revenue is booked > based on Dimension but the Customer balance is created with summary of all > this four lines. > > Hence, i can forsee a balanced Trial balance per dimension may not come in > an output. > > Any thoughts?? > > Thanks in advance. > > Regards > A > > >
