I'm trying to create a report that uses the OE Sales Summary table in GridView. One of the fields I'm using in this report its called 'Inv Date'. I have tried different combinations of using dates, but unless I turn off the filter I create, I don't get any hits.
When I look at the field properties for that field, it says TYPE = DATE and LENGTH = 3 (among other things). How can a date field only use 3 characters? When I run this report with the filter turned off, the Inv date field shows the date in this format:
"07-Feb-08".
Am I missing something? How do I fit a date like that into three characters?
Andre
{Inv Date} = Date(2008,01,12)
Would return all records for 12-Jan-08
The "internal" date format in Adagio is YMD in 3 bytes.
Y = 108 => 2008, M and D are 1 to 12 and 1 to # of Days in Month
Hi Michael:
I'm pretty sure I tried that. Maybe my problem is not with the date. I'll try again and may even try to post my first screenshot. Thanks for the quick response!
Andre
Here is the filter I created. Pretty straight forward, I think. I have used a similar date filter in other reports.
AND(
{Inv Date} >= QUERYDATE("Enter Start Date:", TODAY()),
{Inv Date} <= QUERYDATE("Enter End Date:", TODAY())
)
I just created a similar report using the *OE Ord Detail w Head table instead of the OE Sales Summary table, reused the same date filter - and it works just fine. Even if I turn of the date filter in the first report, only transaction for this month appear to be listed. There is nothing listed that happend prior to February. Is there something special about the OE Sales Summary table in that it only looks at the current month?
Posted by: Retired_Guy
Re: Inv Date field in GridView - 02/08/08 08:49 PM
Maybe it only has data for the current month?
Try loading the View with the filter turned off and sort on the Inv Date field to see what values it contains.
That's exactly what seems to be happening: The OE Sales Summary table only contains data for the current month. Is this the way it is intended to work? Why would the Sales Summary table only contain data for the current month?
Posted by: Retired_Guy
Re: Inv Date field in GridView - 02/11/08 06:18 PM
Hello Andre,
Because someone printed the report and purged the data.
Sorry.
Adagio SalesAnalysis will pick up any history that exists in Adagio OrderEntry (or Softline Invoice History).
Thanks, Andrew! That makes complete sense. Now that we're using Adagio OE, we should be able to retain data for much longer since data would be moved to the OE History table(s) before eventually purging, right?
Posted by: Retired_Guy
Re: Inv Date field in GridView - 02/11/08 09:55 PM
Yes.
You set the length of time to keep the data in history in the OrderEntry company profile. As long as the data is there, it can be moved to SalesAnalysis (where it's easier and faster to report on).