Share
Report
379Dear Experts,
We are facing an issue with TDS base amout calculation in D365 Business Central. Please find the scenario below:
| Particulars | Quantity | Unit Cost | Line Amount | GST % | GST Amount | TDS % | TDS Amount |
|---|---|---|---|---|---|---|---|
| Invoice Line 1 | 152.5 | 404 | 61,610.00 | 18 | 11,089.80 | 0.10 | 61.61 |
| Invoice Line 2 | 1,405 | 404.5 | 568,322.50 | 18 | 102,298.05 | 0.10 | 568.3225 |
| Invoice Line 3 | 80.5 | 404.5 | 32,562.25 | 18 | 5,861.205 | 0.10 | 32.56225 |
| Total | 662,494.75 | 119,249.055 | 662.49475 |
The payment details are as follows:
- Payment Amount: ₹723,000
- TDS Base Amount: ₹613,000
- TDS Rate: 0.10%
- TDS Amount: ₹613
Since the total invoice TDS Base Amount is ₹662,494.75 and the payment TDS Base Amount is ₹613,000, the remaining TDS Base Amount should be:
₹662,494.75 − ₹613,000 = ₹49,494.75
Accordingly, the remaining TDS amount should be:
₹49,494.75 × 0.10% = ₹49.49
However, after posting the purchase invoice, D365 Business Central is showing the remaining TDS Base Amount as approximately ₹32,562, and the remaining TDS Amount as ₹49.49.
We have also checked the Vendor Ledger Entry, where:
- Original Amount: ₹781,694.32
- Remaining Amount: ₹58,654.32
The TDS Base Amount of ₹32,562 appears to correspond to the third invoice line amount of ₹32,562.25, which makes us suspect that the TDS base is being allocated/calculated line-wise when the payment is applied before posting the purchase invoice.
Could you please review this scenario and confirm:
- Why is the remaining TDS Base Amount being calculated as ₹32,562 instead of ₹49,494.75?
- Is this standard behavior in D365 Business Central India Localization?
- If not, what is the correct solution/fix?
- Is there any setup or customization that needs to be checked for TDS calculation and payment application?
Please let us know if you require any additional details or screenshots for further investigation.
Thanks.
All responses (
Answers (
