Skip to Content
avatar image
Former Member

FS items

Hi All,

We have a requirement for a customised report, where the client wants the GL accounts to split as per the FS items assigned to it.

EX: 1/Aug/2008 - 31/Aug/2010 - FS item A - GL acct 530*****

01/Sep/2010 - 31/Sep/9999 - FS item B - GL acct 530*****

When we give a search for the comparative period as 1/Aug/2008 - 31/Aug/2010 and

Reporting period as 01/Sep/2010 - 31/Sep/9999

The report should give us two lines with two FS items and respective balances.And in case of no balance it still has to display a line with FS items and Zero balance.

We have tried many test scenario after change of logic in the program to include start date. but it only throws up one line and takes the latest date, in this case 01/Sep/2010 - 31/Sep/9999 - FS item B .

Is there a possibility to have such a report at all, how do we understand the structure of "BAGY" - how the FS items and GL accts are linked ?

Appreciate any help on this.

Thanks,

Archana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 12, 2014 at 07:09 AM

    Hi,

    FSV (Financial statement version) has no validity date. If you have different assignment of G/L accounts to FS items through the period, you have to create two separate FSVs.

    Regards,

    Eli

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 12, 2014 at 07:57 AM

    Hi Archana,

    Financial items will not create with validity. Hence it is not possible to assign GL accounts based on validity. Instead you can create 2 separate financial statement versions and create a financial items with GL assignment as per your requirement.

    Regards,

    Mukthar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 12, 2014 at 11:07 AM

    Hi,

    You can try to design a report on Report Painter for two different FSVs with the Reporting & Comparison period variables in the input screen.

    In standard reports you can execute the reports with only one FSV

    Regards

    Divya S

    Add comment
    10|10000 characters needed characters exceeded