How to show bank account Information in Process report method in SSRS Report

(0) Share

Report

Posted on by PK mishra

115

I try to develop " Customized SALES TAX Invoice Report " of SSRS RDP Report .

in this , i need Join to CustinvoiceLine with BankDetails Table(something) ,

so , my question is , what is the exact code , to retrive bank account Information ,Related to custInvoiceLine table in the process report method ..

my current process report code is below

select * from custInvoiceTable  where custInvoiceTable.OrderAccount == custAccount
     && custInvoiceTable.InvoiceDate >= _FromDate && custInvoiceTable.InvoiceDate <= _Todate
        join custInvoiceLine
        where custInvoiceLine.ServiceAccountingCodeTable_IN == ServiceAccountingCodeTable_IN.RecId
        join ServiceAccountingCodeTable_IN 
       ;
         {
             
                TaxInvoiceTmp.InvoiceId            =      custInvoiceTable.InvoiceId;
                TaxInvoiceTmp.Name                 =      custInvoiceTable.Name;
                TaxInvoiceTmp.InvoiceDate          =      custInvoiceTable.InvoiceDate ;
               TaxInvoiceTmp.GSTIN               =      taxinfo.GSTIN ;
                 TaxInvoiceTmp.PanNo               =      TaxInformationCustTable_IN::findByCustTable( RAMA_TaxInvoiceTmp.InvoiceId ).PANNumber;
                 TaxInvoiceTmp.SAC                 =      ServiceAccountingCodeTable_IN.SAC ;
                 TaxInvoiceTmp.SacDescription      =      ServiceAccountingCodeTable_IN.Description ;
                //  TaxInvoiceTmp.BankName             =    
                //  TaxInvoiceTmp.BankAcNo             =  
                 // TaxInvoiceTmp.BankBranch           = 
                 // TaxInvoiceTmp.RTGS   
                 TaxInvoiceTmp.insert() ;
                 
        }

I have the same question (0)

All responses (7)

Answers (1)

Martin Dráb 237,904 Most Valuable Professional on at

Like (0)

Report
Let me start by formatting your code, so it's easier to read:

select custInvoiceTable where custInvoiceTable.OrderAccount == custAccount && custInvoiceTable.InvoiceDate >= _fromDate && custInvoiceTable.InvoiceDate <= _todate join custInvoiceLine join serviceAccountingCodeTable_IN where serviceAccountingCodeTable_IN.RecId = custInvoiceLine.ServiceAccountingCodeTable_IN; taxInvoiceTmp.InvoiceId = custInvoiceTable.InvoiceId; taxInvoiceTmp.Name = custInvoiceTable.Name; taxInvoiceTmp.InvoiceDate = custInvoiceTable.InvoiceDate ; taxInvoiceTmp.GSTIN = taxInfo.GSTIN ; taxInvoiceTmp.PanNo = TaxInformationCustTable_IN::findByCustTable(RAMA_taxInvoiceTmp.InvoiceId).PANNumber; taxInvoiceTmp.SAC = serviceAccountingCodeTable_IN.SAC ; taxInvoiceTmp.SacDescription = serviceAccountingCodeTable_IN.Description; taxInvoiceTmp.insert();

Now there is an obvious bug - you joined custInvoiceLine to custInvoiceTable but you forgot to specify any join condition.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Praveen,

so, my question is, what is the exact code, to retrive bank account Information, Related to custInvoiceLine table in the process report method ..

Debug your code, are there any errors or other problems? Please share with us, thank you.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,904 Most Valuable Professional on at

Like (0)

Report

Does the information really exist on lines at all? Isn't the bank account defined on the header only, in CustInvoiceTable.CustBankAccountId?

Was this reply helpful? Yes No
PK mishra 115 on at

Like (0)

Report

There is No any Error ,

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Praveen,

Have you considered taking the report based on CustInvoiceJour/CustInvoiceTrans to get the information of all posted invoices.

See the thread:

community.dynamics.com/.../getting-physical-customer-information

Was this reply helpful? Yes No
PK mishra 115 on at

Like (0)

Report

Yes

Will....

Was this reply helpful? Yes No
Verified answer

PK mishra 115 on at

Like (1)

Report

I got solution from below code , thanks

select * from CompanyBankAccountTableData where CompanyBankAccountTableData.AccountID==CompanyInfo::find().Bank;

{

TaxInvoiceTmp.BankAcNo = CompanyBankAccountTableData.AccountNum;

TaxInvoiceTmp.BankBranch = CompanyBankAccountTableData.TEC_BankBranch;

TaxInvoiceTmp.RTGS = CompanyBankAccountTableData.TEC_IFSC;

TaxInvoiceTmp.BankName = CompanyBankAccountTableData.Name;

TaxInvoiceTmp.Bank_Swift = CompanyBankAccountTableData.SWIFTNo;

}

Was this reply helpful? Yes No