fix: better gls for purchases with tax witholding

[vorasmit]

Scenario

• Purchase Invoice is of Rs 50000 + GST
• TDS is deducted of Rs 500
• Amount payable to supplier is Rs 49500 + GST

Issue

Accounting for payable to supplier was done for Rs 49500 + GST This could raise concerns by the supplier because the invoice is of Rs 50000 + GST

Fix

• Separate GL for TDS with appropriate remarks
• Separate Reporting in General Ledger

General Ledger Report After Fix

General Ledger Print with Remarks

Frappe Internal Reference: https://support.frappe.io/helpdesk/tickets/20049

---

Possible extension of this fix needed for Sales Invoice and Payment Entry.

[mohsinalimat]

Same issue in Sales Invoice and Payment Entry.

https://support.frappe.io/helpdesk/my-tickets/20239

[stale[bot]]

This pull request has been automatically marked as inactive because it has not had recent activity. It will be closed within 3 days if no further activity occurs, but it only takes a comment to keep a contribution alive :) Also, even if it is closed, you can always reopen the PR when you're ready. Thank you for contributing.

[mohsinalimat]

@vorasmit @deepeshgarg007 @ruthra-kumar Any updates regarding this PR? We have same issue in Sales Invoice and Payment Entry.

[vorasmit]

@mohsinalimat,

This solution is only for cases where a company is responsible for deducting TDS/TCS in Purchase/Sales Invoice.

This will not work where TDS is deducted from the companies Invoice by customer. Refer: https://support.frappe.io/helpdesk/tickets/20034

[mohsinalimat]

Same issue in Sales Invoice and Payment Entry.

https://support.frappe.io/helpdesk/my-tickets/20239

@vorasmit Then what is the solution for this?

[vorasmit]

In addition to changes in this PR for Payment Entry, following additional changes may be required:

In Payment Entry => In references table, we'll have to allow deductions against each invoice somehow.

This is complex as it may need to be handled at multiple places, including Advances table in Sales Invoice or Payment Reconciliation.

[sjain17]

When this will be merged into Version-15?

[vorasmit]

Similar implementation was not required in Sales Invoice and Payment Entry.

For Sales Invoice, if TCS is charged, it goes as a part of Sales Invoice to customer and he can match with the total amount of Invoice.

For Payment Entry, print format is comprehensive, and gives breakup of TDS.

Hence existing implementation for Purchase Invoice looks sufficient.