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() ;
                 
        }

All responses (7)

Answers (1)

Verified answer

PK mishra 115 on at

Like (1)

Report

RE: How to show bank account Information in Process report method in SSRS 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;

}
PK mishra 115 on at

Like (0)

Report

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

Yes

Will....
WillWU 22,357 on at

Like (0)

Report

RE: How to show bank account Information in Process report method in SSRS 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
PK mishra 115 on at

Like (0)

Report

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

There is No any Error ,
Suggested answer

Martin Dráb 234,178 Most Valuable Professional on at

Like (0)

Report

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

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

Like (0)

Report

RE: How to show bank account Information in Process report method in SSRS 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.
Martin Dráb 234,178 Most Valuable Professional on at

Like (0)

Report
RE: How to show bank account Information in Process report method in SSRS 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.