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: 3687
Loc: Orlando, Florida USA
Look at ICITEMO.VALUE
_________________________
Sage 300 Certifiable Consultant

Top
#55176 - 04/24/22 06:57 AM Re: Selecting items with optional field [Re: Ettienne]
idasanka
Member


Registered: 04/24/22
Posts: 116
Loc: us
What a great idea! my friend told me they had a very memorable stay here. https://customclosetsdesignboise.com
Top
#55177 - 04/24/22 06:57 AM Re: Selecting items with optional field [Re: Ettienne]
idasanka
Member


Registered: 04/24/22
Posts: 116
Loc: us
You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. https://customclosetsdesignbuffalony.com
Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: