Journal Transaction FIN05420 - Brought Forward

Emanuele Croci

Dear support,

our customers are not satisfied about the Journal Transaction FIN05420, because it always visualized the Brought Forward (also for Profit And Loss accounts).
It's works differently from standard SAP B1 General Ledger report (see attached file).
Does it exist a coresuite report that works as the standard General Ledger report of SAP B1?
We need a report as Journal Transaction FIN05420, but it should have an opening balance including only the transaction from the start of period and the start date.

At least we need a flag similar to the "Opening Balance from start of Fiscal Year".
Please, can someone help us?
Best regards
Emanuele

Emanuele Croci

Please, can someone give me a feedback?

It' very important for us, otherwise we should think to develop a new report.

Is it possible to have the basic query of FIN05420 report?
Best regards
Emanuele

Friederike Mundt

Hi [color=#282828][font=helvetica, arial, sans-serif]Emanuel,[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]At the moment there is no report to display the postings with [/font][/color][color=#282828][font=helvetica, arial, sans-serif]"Opening Balance from start of Fiscal Year". I know it is possible in SAP but the initial idea of coresuite reports was to have only parameters which are required in most companies. So far no customer requested this function.[/font][/color]

[font="helvetica, arial, sans-serif"][color="#282828"]Since at the moment we have not planned to adjust the report in this way and it seems urgent for you I would you open a support ticket at coresystems and we provide you with the datasource to adjust the report. Otherwise I can create a development request. My guess for the schedule would be end of this year.[/color][/font]
[font="helvetica, arial, sans-serif"][color="#282828"]Regards,[/color][/font]

[color=#282828][font=helvetica, arial, sans-serif]Friederike[/font][/color]

Emanuele Croci

Dear [color=#282828][font=helvetica, arial, sans-serif]Friederike,[/font][/color]

[color=#282828][font=helvetica,arial,sans-serif]please, can you [/font][/color][font=helvetica, arial, sans-serif][color=#282828]create a development request?[/color][/font] In this way, we hope to have this new report for the end of this year.
[font=helvetica,arial,sans-serif][color=#282828]Now, we have to understand [/color][/font]if we can create a new user-query to create a datasource for our report.
If we should open a request to the support, we have to pay this activity, but we don't want to spend money for the moment.
Best regards
Emanuele

Emanuele Croci

Dear Friederike,

in the next version of FIN05420 report, we need you add this sql statements in the basic query:
...

SELECT .....

... INTO #BroughtForward

...

FROM ....

...

WHERE

ISNULL(T0.RefDate,'1900-01-01 00:00:00.000') < @FromDate

[color=#ff0000] and YEAR(@FromDate) = YEAR(ISNULL(T0.RefDate,'1900-01-01 00:00:00.000'))[/color]

...

...


In this way, the BF_Debit and BF_Credit fields are populated only considering the transaction since the [color=#282828][font=helvetica, arial, sans-serif]start of Fiscal Year[/font][/color] and before the FromDate.
Best regards
Emanuele

Emanuele Croci

Dear Friederike,

can the development team provide the original query/datasource they use in the FIN05420 report?

Otherwise can they provide the first part of the query, where they declare and set the input parameters?
In the log file generated running the report, I see this declaration part:
...

DECLARE @IgnoreAdj AS VARCHAR(1) SET @IgnoreAdj='N'

DECLARE @AddVoucher AS VARCHAR(1) SET @AddVoucher='N'

DECLARE @FromDate AS DATETIME SET @FromDate = '20120114'

DECLARE @ToDate AS DATETIME SET @ToDate = '20121231'

DECLARE @TransType AS VARCHAR(1) SET @TransType='Y'

DECLARE @JournalType AS VARCHAR(1) SET @JournalType= 'N'

DECLARE @Journal AS VARCHAR(1) SET @Journal= 'Y'

...


where the SET statement already show the values of the parameters, not the input parameters, i.e. [%IgnoreAdj], [%AddVoucher], etc...
I need the declaration part of all input parameters and variables.
Please, can you help me?


Best regards
Emanuele

Friederike Mundt

Hi Emanuele,
Please send an email to support@coresystems.ch to open a support ticket. Then we can send you the datasource through this ticket.
Kind Regards,

Friederike

Emanuele Croci

Thank you Friederike.
Is this datasource free? Or we have to pay money?
Best regards
Emanuele

Friederike Mundt

HI Emanuele,
We provide the datasource for free but provide no guarantee. That means if you need help to adjust it or to fix errors later on, we need to charge you for our service.
Hope that answers you question.

Cheers,

Friederike

Emanuele Croci

Thank you very much for your help, Friederike.