Skip to Content

Balance Sheet (HANA)

Hi,

I have noticed that the SQL and HANA version (SAP B1 9.3) has different Balance Sheet date parameters.
The SQL has only a "Date To" which I believe is correct since Balance Sheet should show the balance of all "real accounts" from the start of the company activity.
The HANA version has a "Date From" and this gets trick if one runs a monthly report example From April 1 to April 30 because it will show only the net amounts from April 1 to April30. The balances before April 1 will not be included in the calculation.

The date from and to is fine for Trial Balance since you have an option to include/exclude the opening balances but the Balance Sheet selection criteria does not have this option in the HANA version.

This makes the end-users think that they are seeing the correct balances but in reality the balance includes only the amounts for that date range. Amounts before the "Date From" are not calculated.

For the HANA version should the date from be put as empty?

balance-sheet.png (165.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 20 at 03:31 AM

    Hi,

    Are you comparing SQL and HANA for same localization?

    Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Nagarajan,

      Thanks for the heads up.
      I didn't realize the localization made a difference.
      The screenshot was Canadian (SQL) and Guatemala (HANA).
      I've compared SQL and HANA both using US localization and the balance sheet parameters are the same.

      The BS date parameters for US Localization in both HANA and SQL have the "Date To" only.

      Thanks

  • Posted on May 20 at 03:39 PM

    Hello,

    Balance Sheet From date is available in Localizations that closes the Balance Sheet when running Period End.

    Jesper

    Support Spotlight Series:

    https://blogs.sap.com/2018/01/17/support-spotlight-tips-from-sap-business-one-support/

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Jesper,

      Thank you for the reply.
      I tried looking at the link you've indicated but I seem not able to find it.
      There's quite a long list of entries there and I searched for keywords eg Balance Sheet, Date, period and period end but can't find it.

      Thank you.

      Eric

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.