We had an issue where the Sales figure of Profit and Loss report generated from the management reporter was not matched with the trial balance and we found out that a transaction was missing in the management reporter P&L report.

Going in deep, we reviewed the voucher of the transaction which was missing and found out the difference in the value of the "Project" financial dimension on sales order header as well as sales order line with the voucher.

We also validated the length of the field to try to give us a reason, but longer lengths of financial dimensions exist with the full financial dimension values.

The financial dimension value got truncated in transaction voucher and not get picked in the financial report.

We need a tool to validate the values for financial Dimension values in order financial reports showing correct data.