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?