We’re attempting to run a General Ledger report with the below criteria. For some reason, the data returned is for 2016 fiscal period 1 (or fiscal period 2, when selected). There are no errors and no other issues with the system (as far as we can tell). Anyone have any ideas why the system isn’t returning information for the correct year?
Fiscal Year: 2017
Starting Fiscal Period: 1 (or 2)
Ending Fiscal Period: 1 (or 2)
Grouping: Detail Account
Report Style: Standard - SSRS
Schedule: Now
Archive Period: 0 Days
If you run it for FP 1 of FY 2016, does it give you what you expect? And that is identical to what running it for FP 1 FY 2017 gives you?
Double check any of the settings on the window. Try removing defaults. I’ve seen a value placed on a Filter tab get saved when a user did the “Save Defaults”. Then every time they ran in the future that value on the filters tab was already there.
Running FP1 of FY 2016 provides expected data. We get the same 2016 output if we select FP 1 of FY 2016 or FP 1 of 2017. There are no selections on the filters tab. The Filter Summary on the Selection tab is as follows:
Additional Books:
Additional Segments:
Was there a change to the Fiscal calendar (like switching from July 1 through June 30, to Jan 1 through Dec 31) ?
Take a look at the Fiscal Calendar setup. You should be able to see the dates that each FP spanned. Maybe the dates for FP1 of FY 2017 were accidentally changed to 1/1/2016 - 1/31/2016. Edit: Assuming FP1 is Jan 1 - Jan 31
There was no change to the Fiscal Calendar set up; it is 1/1-12/31 for all years. For some reason, fiscal period 1 for 2017 is set to 1/1/2017-2/4/2017 in the Fiscal Calendar set up. Could this be the problem? If so, do you know how I can change it (the field appears to be locked)?
I don’t think that date issue is the problem you’re seeing.
Does your company align Fiscal Periods with Calendar months (FP 1= 1/1…1/31, FP 2 = 2/1…2/28, etc…)? Or possible use a weird 5-4-4 setup where a FP 1 is 5 weeks (which 1/1…2/4 is), then FP2 and 3 are each 4 weeks, etc…
That would explain the odd end date of 2/4/2017 for FP1. But wouldn’t explain the 2016 numbers being reported.
Here’s the order of things I’d do to track this down.
Run the report using the default (i.e Epicor supplied) Report Style. Make sure the Style is using the original RDL and RDD. This confirms that a customized report or RDD isn’t messing things up.
Check to see if it is across all GL accts or just select ones.
Make a BAQ to see if you get the same results outside of the reporting system.
edit:
one more thing. Does the header of the report show the correct FY (the value you entered on the form)?
The company appears to use calendar months for all other years. It isn’t clear to me why FP 1 for 2017 ends on 2/4/2017.
The report style is Standard - SSRS. There are no other options from the drop-down list.
I believe the issue affects all GL accounts as I tested a number of different accounts with the same result.
The header of the report shows the correct FY. The exact name is ‘DETAILED POSTINGS FOR FISCAL YEAR 2017 Period 1 -1.’
Would you happen to have a link to a tutorial that has instructions to create a BAQ? Outside of links to the Epicor support portal (to which I do not have access), I haven’t been able to find documentation online.
If you’ve never a BAQ before, this might not be the one to learn on. The data you’ll need might come from several different tables (and it might conveniently be in just one)
There are probably sever YouTube videos on making one. You could start there. The basic steps are:
Make sure your user can create BAQ’s (its a setting in User Maintenance)
Launch the BAQ (Business Activity Query) program
Make a new blank BAQ (File → New)
Give it an name and description
Add a table(you’ll probably want to use Seamless Summer Option )
Add table Criteria to limit the records returned.
a. GLJrnDtl.JEDate >= 1/1/2017
b. AND GLJrnDtl.JEDate >= 1/31/2017 (might need to change that to your 2/4 date)
c. AND GLJrnDtl.GLAccount = ‘1234|56|78’ (replcae that with a GL account to query. And you must use the pipe character | to separate them. Its above the enter key on my keyboard )
Add the fields to display: GLAccount, JEDate, CreditAmount, Debit Amount
Preview the results.
This video looks fairly basic. Slightly more complicated than your need. just the first 40 seconds shows making one an where in the UI you do the things I mentioned above BAQ Changes in Epicor 10 1 - YouTube.
Thank you very much for the information. I created and tested a BAQ, and it returned the correct data. I was up against a time crunch, so I decided to run a SQL query against the [Erp].[GLJrnDtl] table and export the data to an Excel file. I appreciate all of the help.