Share
ReportHi
How to setfilter records which Have Document Type 0 or 1 in Vendor Ledger Entry
Thanks
*This post is locked for comments
You’re offline. This is a read only version of the page.
3,061
Hi
How to setfilter records which Have Document Type 0 or 1 in Vendor Ledger Entry
Thanks
*This post is locked for comments
We don't know what are the document types that you want to filter, but the solution is what we have provided in this post. I'll retry to explain:
If you want to filter for the FIRST and SECOND option values and the option values for Document Type are, BLANK,Payment,Invoice you can write:
VendorLedgerEntry.SETFILTER(“Document Type”,’%1|%2’,VendorLedgerEntry.”Document Type”::" ",VendorLedgerEntry.”Document Type”::Payment);
Hi
I don't want to pass Integer . In Option String it is written
,Payment,Invoice
At 0 there is nothing . Payment = 1 , Invoice = 2
Thanks
Check the option String and pass the integer value
The first option value you have in Document Type field options (I don’t remember now what value is). Check the OptionString property of this field.
Hi
What should be written if 0 to be considered
Yes you can write the option name. Mine was only a sample.
Hi
It is giving me message 'A variable was expected'
VLE.SETFILTER("Document Type",'%1|%2',"VLE"."Document Type"::0,"VLE"."Document Type"::1);
Instead of numeric can't we write like 'Payment' etc. What is to be written for 0
Thanks
VendorLedgerEntry.SETFILTER(“Document Type”,’%1|%2’,VendorLedgerEntry.”Document Type”::0,VendorLedgerEntry.”Document Type”::1);
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
