Skip to Content

TDS Section wise report for Indian Localization

Dear Experts,

I am working on a query to get the section wise report. the query is as given below.

SELECT T0.DocEntry, T0.DocDate, T0.DocNum 'DocumentNo', T0.CardCode, T0.CardName, T1.[AcctCode], T3.[AcctName], T0.DocTotal 'Total', T1.[TaxCode], T1.[WtLiable], T6.[Location] 'Location Name', T0.VatSum, T2.TaxbleAmnt, T2.WTAmnt, T2.Rate, T4.WTName, T5.code 'Section' FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN PCH5 T2 ON T0.[DocEntry] = T2.[AbsEntry] INNER JOIN OACT T3 ON T0.[CtlAccount] = T3.[AcctCode] INNER JOIN OWHT T4 ON T2.[WTCode] = T4.[WTCode] INNER JOIN OSEC T5 ON T4.[Section] = T5.[AbsId] INNER JOIN OLCT T6 ON T1.LocCode = T6.Code where T0.DocDate between [%0] and [%1]

the issue that i am getting here is that the "AccName" that i want is of the GL ACC that is used in the Purchase for items "Rent for Warehouse". but what is am getting in output is for the customers i.e. "Trade Creditors"

requesting you to plz help.

let me know if you need more information.

thanks and regards,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 10, 2018 at 09:09 AM



    i want two query like this format

    i m using TDS automatic in 9.2 Pl 8 and also deduct tds on ap invoice and down payment invoice

    if any one have any query for this please let me know

    Add comment
    10|10000 characters needed characters exceeded