Wednesday, 17 June 2020

Show report header(Row) for all pages in SSRS

Show report header(Row) for all pages in SSRS:

set the below properties to show the particular row in all pages:

Design:
1.Style Template : TableStypeTemplate


2.Tablix properties:

check box for Repeat header on each Page




3. selected header row property
Repeast with : Tablix1(Yourtable)




4. Advanced Mode row properties:
keep together : False
Keep with group : After
Repeat on new page : True




some times properties will not show then close the visual studio and reopen as admin

Tuesday, 14 April 2020

How can I get the Sales Tax /Sales Tax Totals or Getting actual amount without tax from ledgerjournaltrans table:

How can I get the Sales Tax /Sales Tax Totals:


Or

Getting actual amount without tax from ledgerjournaltrans table: 

ledgerJournalEngine.taxAmountJournal(_ledgerJournalTrans); // this will calculate the tax if you have ledgerjournaltrans line with you.


example for customer payment journal(LedgerJournalType::CustPayment) ;


LedgerJournalEngine ledgerJournalEngine = LedgerJournalEngine::construct(LedgerJournalType::CustPayment);

LedgerJournalTrans  _ledgerJournalTrans = LedgerJournalTrans::findRecId(5637290372,false);
        
TaxAmountJournal TaxAmountJournal = ledgerJournalEngine.taxAmountJournal(_ledgerJournalTrans);


getting GST calculations eith sales and purchase lines:


salesLine = SalesLine::find(custConfirmTrans.SalesId, custConfirmTrans.LineNum);

Tax::calcTaxAmount(salesLine.TaxGroup, salesLine.TaxItemGroup, Systemdateget(), salesLine.CurrencyCode, salesLine.LineAmount, TaxModuleType::Sales);