Skip to Content
avatar image
Former Member

WBS Wise GL Report

Hi,

I am looking for any report which should display WBS wise GL Balances.

FBL3N report is showing the results but not as per the required format.

I have checked Report Painter (FGI1, FSI1) but found no luck.

Can anyone please guide me how to achieve the needful ?

Regards.

Zain Bashir

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 22, 2015 at 07:00 AM

    Hi

    You can look at using CJI3 and than summarizing based on cost element. This should give you WBS element wise GL wise balances which you are looking for

    Regards

    Sanil Bhandari

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      I am not sure what is the business case for using WBS Elements with Balance sheet accounts, except for capital procurrement. You can create such balance sheet Accounts (recon type - Asset/material) with cost element category 90 and check them in CJI3. This works only in new gl enviornment.

      If that does not work for you, than write a report painter report

      Regards

      Sanil Bhandari

  • Oct 22, 2015 at 10:06 AM

    ...and what's exactly wrong with FBL3N? šŸ˜Š

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 01:00 PM

    Hi Bashir,

    First select the WBS element in the layout . and select the column ,WBS elementĀ  and click on subtotal button. you will get WBS wise balances.

    Thanking you

    Vengaiah

    Add comment
    10|10000 characters needed characters exceeded

  • May 17, 2016 at 01:24 PM

    You can adjust the field status for Balance sheet GL codes to make WBS Optional entry or Required as needed and then WBS will be available for input.  

    Add comment
    10|10000 characters needed characters exceeded