Announcements
how to skip those record where debit credit is equal
in vend account statement
please send me code
*This post is locked for comments
kindly provide two things
1) path of vendor account statement
2) define word 'SKIP' ; does that means do not disply on report or what?
Thanks Sohaib Cheema your Response
yes do not display on report
AP>Report>Transaction>Vendor>Account Statement
DP class Name VendAccountStatementIntDP
AOT\Classes\VendAccountStatementIntDP\processReport
Add a range here with expression as
where debit != creadit
you can dd range on query with syntex as demonstatted here in two examples
Example1
Example2
I am not understanding how to add rage kindly give me range code
how to add range because two field amountCur, amountDeb in vendTrans table
Read again my previous reply, read Example refered previously.
Do little work on that by reading and then come here if you face any isuue, by showing what yolu have done till now
if (withoutSettlement )
{
query.dataSourceTable(tableNum(LedgerJournalTrans), 1).addRange(fieldNum(LedgerJournalTrans, AmountCurCredit)
,fieldNum(LedgerJournalTrans, AmountCurDebit)).value(queryvalue(credit!=debit));
}
I am using this
when i execute report then error occurred
(Query object not initialized.
Stack trace
(S)\Classes\VendAccountStatementIntDP\processReport - line 44
(S)\Classes\SrsReportRunRdpPreProcessStrategy\execute - line 27
(S)\Classes\SrsReportRunRdpPreProcessStrategyTempDB\execute - line 6
(S)\Classes\SrsReportRunRdpPreProcessService\executeWithContract - line 82
(S)\Classes\SrsReportRunRdpPreProcessService)
well, though i dont have time, i have spent few minutes and found two points reagrding your issue
1) There is nothing called debit credit in the Table which is being used behind the report. The origion of data for this report is actually VendTrans and in table VendTrand only field which does matter is AmountCur
Might be you are able to see AmountCur on report as Debit and Credit columns but in fact the information is saved in single column known as AmountCur
Now your requirement is to skip those rows where debit is equal to credit. You will never find such rows because amount is saved in single column
2) if you have any customized columns for debit/credit you can code for range in follwing path
\Classes\VendAccountStatementIntDP\initVendTransQuery
and you code should be something as follwing
queryBuildRange = vendTransDataSource.addRange(fieldNum(VendTrans,AmountCur)); queryBuildRange.value(strFmt('((%1 != %2))', fieldStr(VendTrans, AmountCur), queryValue(100) ));
after use this code did not any change
how is it possible
seems you did not read, part-1 of reply and i cannot hear anything from your side, how you are managing 2 columns for debit and credit, so helping you, without knwoing, is not feasible.
Hopefully, if you can provide us details, we can help you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
