Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#54890 - 08/10/21 04:35 AM Selecting items with optional field
manager
Member


Registered: 08/10/21
Posts: 1
Loc: United States
Working on report that is selecting items with optional field value CS using ICILOC, ICITEM, ICITEMO tables. I tried several formulas including if{ICITEMO.OPTFIELD}<>"CASE" then "1" else "0" or if{ICITEMO.OPTFIELD}="CASE" then "1" else "0" and they all display correct values. When I try to use select expert and select “1” or “0” formula stops working and all items are selected. Any tips?
Top
#54891 - 08/12/21 08:42 AM Re: Selecting items with optional field [Re: manager]
Ettienne
Member


Registered: 06/28/02
Posts: 3684
Loc: Orlando, Florida USA
Look at ICITEMO.VALUE
_________________________
Sage 300 ERP Certified Consultant

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: