Skip to Content
0
Former Member
Aug 15, 2010 at 10:51 AM

GL Account Offset

41 Views

Dear All.

I have a requirement to show the GL Account offsets for the GL in question i.e.

User enter on variable screen.

1. GL number

2. Posting Date

3. Company code.

The report should show all the offset entries which is happen against this GL in all the documents.

for example.

on variable screen.

GL Account 1000300, 01.08.2010 - 15.08.2010 , 4000

the normal output which come from the GL Line item DSO is

100300 ABC Acount 70,000

but user want the out put like this

100300 ABC Account 70,000

100095 XYZ Desc -40,000

100095 XYZ Desc -30,000

that is all the offset entries made for that GL in the document should come, this can be achieved if we not select the GL account in variable and run the report cause if we select GL account the document restrict the output only for the GL account in filter.

if some body have face this situation please let me know how to handle this.

best regards,