how to skip those record where debit credit is equal
in vend account statement
please send me code
*This post is locked for comments
how to skip those record where debit credit is equal
in vend account statement
please send me code
*This post is locked for comments
how solve it
Cannot select a record in Vendors (VendTable). Name: 0.
The SQL database has issued an error.
Definately In X++ if you want to bring only unique vouche numbers, you have to group by as under
vendTransDataSource.orderMode(OrderMode::GroupBy);
vendTransDataSource.addGroupByField(fieldNum(VendTrans, Voucher));
if we use sql select statement if two voucher have same no then skip this voucher
is possible in x++
so, how debit and credit can be equal at same time? if information is being saved in one column.
come out of FINANCE World
this logically, if information is being saved in a single column, is that any concept of TWO Values??? No
value will be one only
is it possible to have two values(Real Number Type) in a single celll of excel? No
same is the case. so how we can think to compare two values of a single cell.
Please reconsider your requirement to know what is the real requirement
yes I read Part One ,
debit , credit is in one field of VendTrans
amount Cur
how to skip those record
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.
after use this code did not any change
how is it possible
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) ));
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)
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
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156