TDS Section wise report for Indian Localization

595 Views Last edit Sep 04, 2017 at 07:54 AM 3 rev

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,

Ravi.