What table would I use if I wanted to create a report to report off of Prior year's fiscal periods? I've looked at SYPRDFIL_SQL, but that looks like it only contains the current year? I'm looking at something where I could report that in period 0105, for example, company X had $Y sales. Or is there a field in the OEHDRHST where this might be stored?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Prior year system date periods
- Thread starter gc6294
- Start date
I believe the Syprdfil only contains the "current" fiscal years period dates. I created my own table with all prior years period date info.
If you post sales history, the data in the OESLSHST will summarized by period and year.
Perhaps this may help
If you post sales history, the data in the OESLSHST will summarized by period and year.
Perhaps this may help
crystalreporting
Instructor
When it comes to sales history reports of any kind I pretty much always use OEHDRHST and OELINHST. Provided no one's purged these tables they will give you every bit of detail about sales as they contain everything that pertained to the original order and subsequent invoice. Start by creating your detail line, then use grouping to create your summaries by date/month/item/customer or whatever else it is you need. If you do not need to see the detail, you can supress it and it will still be availabe as a drill-down from the summary level.
A well structured report using these tables can form the basis for many sales reports - by simply changing the grouping a sales by period report can quickly become a sales by customer report and so on. Also, by using conditional formulas in the details section, it is easy to create reports that compare sales between periods i.e. sales YTD and sales YTD prior year etc. There may be a little more work up front to design an accurate report using these tables, but the payoff in ongoing report development is worth it. Your reports are also easy to test as you can compare the results against individual invoices to ensue credits, discounts and other variables are being handled correctly.
These two tables are always the real sales as they are the actual detail. Getting accurate information from any of the other summarized sales history tables in Macola is dependent on people running the correct period end procedures at the correct time (and we all know how that goes). By using OEHDRHST and OELINHST you pretty much guarantee that the details you are reporting on are accurate and not subject to month-end or year end processes.
Peter Shirley
A well structured report using these tables can form the basis for many sales reports - by simply changing the grouping a sales by period report can quickly become a sales by customer report and so on. Also, by using conditional formulas in the details section, it is easy to create reports that compare sales between periods i.e. sales YTD and sales YTD prior year etc. There may be a little more work up front to design an accurate report using these tables, but the payoff in ongoing report development is worth it. Your reports are also easy to test as you can compare the results against individual invoices to ensue credits, discounts and other variables are being handled correctly.
These two tables are always the real sales as they are the actual detail. Getting accurate information from any of the other summarized sales history tables in Macola is dependent on people running the correct period end procedures at the correct time (and we all know how that goes). By using OEHDRHST and OELINHST you pretty much guarantee that the details you are reporting on are accurate and not subject to month-end or year end processes.
Peter Shirley
- Status
Similar threads
- Locked
- Question
- Locked
- Question