Using Your Dealer Management System/Reynolds and Reynolds/Inventory Report

Reynolds Era system does not have the ability to pull hybrid new-used reports. The Dealermade suggested report to extract inventory is:

Query
Typically you'll want to always have your query look like

The wildcard syntax for EraLink is kind of esoteric. Appending ] (wild to the right) or [ (wild to the left), will result in a wildcard. Match all stock numbers that begin with an L STOCK#-RIGHT        EQUAL                 L]                              OR

Status Codes
1: In-stock 9: On-Order

New inventory
SERIAL#;MILES;STOCK#;LIST PRICE;DAYS IN STOCK;MODEL NUMBER;COLOR/TRIM;EXTERIOR COLOR CODE;INTERIOR COLOR CODE;MFR PKG CODE;FACT ACCESSORY CODES;CODED COST;WHEEL BASE CODE;

Used inventory
SERIAL#;MILES;STOCK # - LEFT;LIST PRICE;MODEL NUMBER (10);COLOR/TRIM;COLOR CODE;EXTERIOR COLOR CODE;INTERIOR COLOR CODE;VEHICLE TRIM;DLR ACCESSORY CODE;CERTIFICATION NO.;CODED COST

Field definitions

 * CODED COST
 * Per Reynolds definition do not take anything less than X amount (preferred method for handling special price)
 * This can be thought of as special price, or internet price.


 * MEMO LN 1
 * This field is also often internet price. Though it can be either.


 * MEMO LN 2
 * This field is always a MEMO field.


 * TRIM (not available for new inventory)
 * You'll have to dedicate a user defined field in screen 4167 -- pulled as VU