After Following

Not Able To Cancel The Invoice Due to Error 'ORA-20007: Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : jai_ap_tds_prepayemnts_pkg.process_tds_invoices :ORA-01400: cannot insert NULL into ("JA"."JAI_AP_TDS_REPOSITORY"."INVOICE_I ( Doc ID 2175887.1  )

The error is not coming.

How ever

It is not taking the threshold amount from 01-apr-2017 to 30-jun-2017 and treating the current invoice as new one and it is treated as threshold is not breached and hence TDS invoice and Supplier's CM is not generated.

In Pre-GST

In our business, we are having one TDS Authority with multiple Sites which holds Liability account for an each section (194c, 194j and so on).

Accounting will be as follows:

On supplier Invoice

Supplier Liability Cr

  to Charge A/c Dr

On Validation

Invoice Generated on TDS Authority for appropriate Site

Tds Authority Liability (Sectionwise i.e from Site) Cr

    to TDS Adj Account (Which defined in Tax codes) Dr

CM Generated on Supplier

TDS Adj Account (Which defined in Tax codes) Cr

    to Supplier Liability A/c Dr

Now how to achieve the above in the post GST Instance.

Kindly suggest.

Thanks