Skip to Content

TDS Section wise report for Indian Localization

Mar 02, 2017 at 03:46 AM


avatar image

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,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Aman jain Jan 10 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

1.png (23.6 kB)
2.png (15.8 kB)
10 |10000 characters needed characters left characters exceeded