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

From Wikibooks, open books for an open world
Jump to navigation Jump to search

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

Query[edit | edit source]

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

 FIELD                CONDITION             VALUE                         AND/OR
 SERIAL#              ''NOT EQUAL''             ""                              AND

*** as of Third Quarter of 2009 the CONDITION FIELD OPERANDS have been deprecated and are now the following
GREATER THAN IS NOW:  >
LESS THAN IS NOW:  <
GREATER THAN OR EQUAL TO IS NOW:  >=
LESS THAN OR EQUAL TO IS NOW:  <=
EQUAL TO IS NOW:  =
NOT EQUAL TO IS NOW:  #

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[edit | edit source]

1: In-stock 9: On-Order

New inventory[edit | edit source]

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[edit | edit source]

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[edit | edit source]

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

Footnotes[edit | edit source]

^ Current as of: 29 NOV 2007.