Trial Balance Report Issue in SAP Business One

[satinath_biswas54]

Dear SAP Team,

Our customer is having issue in generating the Trail Balance Report for GL Account. The company transaction is started from the Date: 30-10-2023. However, when customer want to generate the trial balance report for financial year 01-04-2023 to 31-03-2024 they are expecting to get the OB (Opening Balance) column as blank or 0 for all the ledgers, however SAP is showing some values for all the ledgers. Need to resolve the issue.

Customer is using: SAP Business One 10.0 (10.00.180) FP 2111 (64-bit) [SQL Version]

For more information, please find the attached screen grabs.

[SonTran]

Hi,

You can use Transaction Journal Report to detect transactions that are created before 31/03/2023. Then we can discuss further how to solve your concern.

Hope this helps,

Son Tran

[satinath_biswas54]

Hi Mr. @SonTran,

Please find the attachment 

[satinath_biswas54]

Hi Mr. @SonTran , I have checked the Transaction Journal Report as you have suggested and could not found any entry in it.

[SonTran]

Please, choose All Transactions in Original Journal and run again

[satinath_biswas54]

Hi,

I have checked with all transaction option also it's showing same blank response.

[SonTran]

Now try to run again Transaction Journal Report with following parameters to see:

1. Date range: 01/04/2023 - 31/03/2024
2. Original Journal: Opening Balance or Inventory Opening Balance

[satinath_biswas54]

Hi @SonTran ,

The data is showing now as shown below in the attachment - all transactions are related to 30-10-2024

[SonTran]

Yes, here is the root cause. As these entries are mark as Opening Balance, whenever user run report for this fiscal year, system will take and summarize them as Opening Balance.

[msundararaja_perumal]

Dear @satinath_biswas54 ,

As workaround, uncheck the opening balance in the selection criteria, then it will show up as debit or credit balances.

As there are different methods to upload opening balances, based on that OB column might show up the values.

Thank You.

[satinath_biswas54]

Hi @msundararaja_perumal,

I have checked the work around solution already but as per customer's expectation the wrong value should not show in the OB column.

Thanks & Regards,
Satinath

[msundararaja_perumal]

Please share how the opening balances were loaded for BP,Stock and GL, thank you.

[satinath_biswas54]

Hi @msundararaja_perumal 

The Opening balance of Business Partners are imported as Individual Invoice in Service A/R Invoice and A/P Invoice, Opening Balance of Items are imported through Inventory Opening Balance Entry, Opening Balance of Ledgers are imported from the G/L Account Opening balance menu from Administration module and for all the transactions posting date was 30-10-2023.

[msundararaja_perumal]

So you customer claims, BP opening balances values are incorrect in TB, am I right?

[satinath_biswas54]

@msundararaja_perumal  Yes Right