Thanks, Andrew!

I assume there is no 'Inv Total LY-YTD field' in one of the tables?

Sorry, no - but that's because LY-YTD changes every day. You have to calculate it doing your own summary (which is probably why ReportMaster was using a Read Back file. The formular for Last Year-YTD Invoices, if using the OrderEntry History file would be:



Then you'd need to summarize the view with this column totalled.

Does this help?

Hi Andrew:

the description of the FISCALSTART() function says the start of the fiscal year gets defined on the GridView Default screen. Where is that? I've looked everywhere. I can't find that setting. Thx!

Makes sense. Thanks. We use the fiscal year instead of calendar year, so I'll have to adapt the formula a little bit. One thing I have come across while trying to do that is that last year's fiscal year started on July 1, 2006, which was two years ago when using the YEAR() function - since we're now in 2008.
That's why I was hoping I could use the FISCALSTART() function, but I have been unable to find where to specify the beginning of the fiscal year.

From the Edit menu, pick Defaults. Or press Shift-F2 on the keyboard. You specify the day and month (not year) that the Fiscal Year begins with.

Duh! Thanks much!;-)

Andre

How does one define a PERIOD - as in PTD? My numbers for YTD and PTD appear to be identical. Thx!

Hi Andrew:

Can you please explain to me what the OE Header table contains versus the OE Hist Header table? I don't use ACCPAC, so I don't really know how this all works. I'm just trying to recreate these Reportmaster reports for our sales team, so please forgive my ignorance.
I assume that OE information, at some point, gets moved from OE to OE History. Correct? Where would I find out when that happens?

I just tried to use the OE Hist HEader table with Cust, Terms and put only three fields into that report: Cust#, Inv Total YTD annd Inv Total LY. I didn't get anything back in GridView, which makes me think there's nothing i that OE Hist table.
The SR table appears to be huge... more than 700000 entries. Takes forever to query. Would that be my only hope to catch last (fiscal) year's sales?

Thx,

Andre

I'm about to give up. I have tried for three days now to piece together this report. No matter what I try - somehow either the numbers aren't right or all I'm getting back for my LY calculated columns is 0.00... Would it be possible to hire Softrak to create this report for us? If so, how much would it cost?

Cheers,

Andre

Adagio GridView is meant to provide fairly straight forward reports from single tables or from tables that can be hooked together as "composite" tables. GridView does not replace all the capability of Report Master, in particular when ReadBack tables are used!

Seems likely that GridView is not the tool for this report. Perhaps what you need is a Custom Report from Sales Analysis.