Dual fiscal year

[Former Member]

Hi all,

Please let me how can i handle dual fiscal year in SAP Business One.

For Example. Our company is in India following Fiscal Year From

April to March . Where as my parent company is following the Fiscal Year from January to December.

Please let me know how can i handle in SAP Business One.

regards

Suresh S

[Former Member · Accepted solution]

Hi Suresh

I think your concern is reporting to the head office using their fiscal year and not your own defined in your database? You can run the Trial Balance and Profit & Loss reports for a date range, with other words from a date to a date, that is not necessarily the fiscal year (the Balance Sheet however does not allow for this). The only problem with this is that there will be journals in April that make your income & expense accounts zero and will skew the results of these reports as they will start at zero in January at the head office. I am assuming that the head office will require only a trial balance or possibly a detailed General Ledger report. You could write a query on the OJDT/JDT1 tables and use GROUP BY on G/L accounts and select the date range to generate a trial balance for the period and forward this to the head office. Alternatively you could try XL Reporter, though you might have similar limitations there.

Will you report in Local Currency or System currency (Head Office currency)? Make sure to write the query to use the correct currency amount fields.

Kind regards

Peter Juby

[Former Member · Accepted solution]

Hi

Thanks for the solution. I have given you the Points.

But is it possible to take Trial Balance using query.

regards

Suresh S

[Former Member]

Hi Suresh

Yes, herewith a simple example.

SELECT T0.[Account], MAX(T1.[AcctName]), SUM(T0.[Debit]) AS [Local Debit], SUM(T0.[Credit]) AS [Local Credit], SUM(T0.[SYSDeb]) AS [System Debit], SUM(T0.[SYSCred]) AS [System Credit] FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode WHERE T0.[RefDate] > = '[%0]' and T0.[RefDate] <= '[%1]' GROUP BY T0.[Account] ORDER BY T0.[Account]

Bear in mind that the forum replaces the square brackets with an underline in the thread.

Kind regards

Peter Juby

[former_member1190345]

HI Suresh,

In your case there is a Parent Compnay and a a branch in India. You must have 2 different DataBases one each for the Parent Company and the Branch company. In the indian company please maintain the Periods from April To March while in your parent company mainatian the Periods from January to December . The is can be done while you are defining the periods for your companies.

Hope this helps.

Nagesh