FS items

[Former Member]

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

[divya_klsv]

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

[former_member198650]

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

[iklovski]

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