ADP ENG statement

[mysticmedia]

If somebody would help me...I am having trouble getting an accurate eng statement for vehicle inventory. I want to automate to pull our inventory daily to use on our website... Can somebody please provide me with a statement, and the command in which to run it... I think we just need a .csv file that we can parse out to a mysql database... Thanks So much for any help you can give...

Jason

[Gerry Laughlin]

I kind of liked the following:
LIST CAR-INV WITH SOLD-DATE EQ "" AND WITH BALANCE GT "10000" AND WITH LOT NE "*" AND WITH STOCK-TYPE EQ "NEW" BODY COLOR BALANCE INT-COLOR INVOICE MAKE MODEL MODEL-NO MODEL-YEAR RETAIL SERIAL-NO. STATUS STOCK-NO. VEHID LOT ID-SUPP

The reasoning behind some of the choices are that if my New Car mgr did not want a car to show on the internet for one reason or another he would put an "*" in the lot field in Add Units so that this report would not pull it. I also like to have the balance part in there to eleiminate cars that look like they are still here. But keep in mind I am just a Parts Manager.
Gerry