Reynolds-Fu question: Inventory as of X date?

[Billfred]

My Reynolds-Fu is pretty strong, but this one had me a little stuck for an answer. Suppose I wanted to pull our inventory as of 12/31 today. Obviously pulling the current inventory wouldn't fly, nor would tacking on deals from 1/1 onward since both could commingle cars that arrived after the date.

Is there some elegant way of doing this in Query Builder or Report Generator, or am I in for a lot of Excel scrubbing?

 

[Billfred]

I'll update this post for those that follow:

After seeing this post here, Reynolds called me (!) and basically had the whole thing going in five minutes.

If you're in Report Generator in Accounting, the file is VEHHISTORY. You select as follows:

SOLD DATE = "" OR
SOLD DATE > (prompt for date) AND
RECEIVED DATE <= (same prompt as before).

Season your output to taste.

Mind: Blown. Thanks, Reynolds!

 

[Jeff Kershner]

That's great that they reached out to you. Thanks for posting the "how to" for others.