Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Posted: 19 May 2008 at 4:31am
You will need to go into the formula editor in the Select Expert to manage this kind of criteria (if my understanding of your requirements is correct).
NOT (sysdate = "11/20/2007" AND trantype = "adj-cst")
That will specifically select every record that is not an "adj-cst" transaction on 11/20/2007. If you need additional criteria, then simply join it to this line with AND.
Joined: 14 May 2008
Online Status: Offline
Posts: 18
Posted: 19 May 2008 at 5:56am
Yeah, Lugh is right.
I've had to do quite a bit of formula editing in the Select Expert. Also, note that you should use parentheses to group distinct statements in the formula editor for the select expert, keep in mind that it is a boolean expression.
Joined: 10 Mar 2008
Location: United States
Online Status: Offline
Posts: 6
Posted: 19 May 2008 at 11:18am
Bill - I have working in three different overall (plant floor to front office) softwares. Vantage is by far the poorest quality in service to the customer and the way it integrates the financials - as an end user and the IT manager - I do not recommend this software. Please take a look at Visual Manufacturing. I worked in this software for four years as the Controller - I truly miss it!!!!!!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
