How to get HSN Code based on project proposal in Taxinformation tab HSN or SAC code

Finance and Operations/AX Developer Forum
1

Hi All,

I am unable get all HSN or SAC code based on Project proposal tax information.
Below is the code I have written to get the data. I am able to get data for some of the proposals but not for all. Kindly guide me.

Thankyou all in advance.

select * from tAXTRANS_IN 
                where tAXTRANS_IN.InvoiceId == ProjProposalJour.ProjInvoiceId;
 
            select * from sERVICEACCOUNTINGCODETABLE_IN 
                where sERVICEACCOUNTINGCODETABLE_IN.RecId == tAXTRANS_IN.ServiceAccountingCodeTable;
            thk_TmpRevenuePJMTbl.SAC = sERVICEACCOUNTINGCODETABLE_IN.SAC;
 
            if(thk_TmpRevenuePJMTbl.SAC == "")
            {
                select * from hSNCodeTable_IN
                    where hSNCodeTable_IN.RecId == tAXTRANS_IN.HSNCodeTable;
                thk_TmpRevenuePJMTbl.HSNCode = any2int64(hSNCodeTable_IN.Code);
            }