Consider the following scenario - I have 2 Business Units which are balancing dimensions, lets say A & B.

I pass a vendor invoice transaction for A and similarly for B

Expense Dr. 100 - Financial Dimension is Business Unit A
Vendor Cr. 90 - Financial Dimension is Business Unit A
TDS Payable Cr. 10 - Financial Dimension is Business Unit A

Entry is balanced and posted

Now if client wants Trial Balance for Business Unit A, they can run the Main Account + Business Unit combination and get the TB. While we dont require the TDS/GST liability and TDS/GST settlement at the Business Unit level, if you remove the amount of 10 by not assigning any dimension, how will the TB match? Client will never be able to get a TB at the Business Unit level as Expense Debit will be 100 and Vendor Credit will be 90 when TB is extracted for Business Unit A.

Similarly, for TDS/GST settlement, we dont require to report payment Business Unit wise, but if payment of TDS for amount 10 is not made from Business Unit A as in our above example, how do we get a proper Trial Balance for Business Unit A? Now imagine there can be more business units and more combinations of balancing dimensions and taxes form an important part of any data analysis.

Therefore, the business case is more from getting the correct Trial Balance and not from the point of view of reporting the TDS and GST Business Unit wise. This is a clear case of a design fault where the system should take default dimensions for settlement which it took at the time of invoice booking. There is no option of inputting any dimensions manually for TDS/GST liability or settlement.

We have the requirement is with two Dimensions [Business unit and Department] and two Dimension values [001,002 and 026,027].

With the financial Dimension setup in the ledger form two dimension values will not work and getting balancing error while doing the settlement.