Is this possible for Select Expert?

Question

I have this in Select Expert and I need to also include a value that has no VendorNo 
 {AR_InvoiceHistoryHeader.InvoiceDate} = {?Date Range} and {AR_InvoiceHistoryDetail.VendorNo} like ["0000833", "001????", "002????", "003????"] and {@Total Sale} >= 0.01 and {AR_InvoiceHistoryDetail.ItemCode} like ["/DISC*"] I need to also include Items that start with / But these items have no VendorNumber so the second line omits these. I need to to also include /DISC* so I get the discounts comments. I tried OR but that returns orders with only /DISC and orders without ?DISC 
 Thanks for any help 
 Mark

Beevet · Accepted Answer

{AR_InvoiceHistoryHeader.InvoiceDate} = {?Date Range} and
{@Total Sale} >= 0.01 and
//Two opening Parentethes
(({AR_InvoiceHistoryDetail.VendorNo} like ["0000833", "001????", "002????", "003????"] and
{AR_InvoiceHistoryDetail.ItemCode} like ["/DISC*"]) OR //One Closing Parentethes
{AR_InvoiceHistoryDetail.ItemCode} like ["/*"]) //other closing parentethes

Sage 100

Is this possible for Select Expert?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING