Hello, I have 2 journal entries with the same gl #. One has a date of 8/31 and the other date is 9/1. when I run the Balance sheet report in frx, nothing shows up for 8/31 but they both show up for 9/30. Is there any way to correct this? We need the one entry to show in august. thanks for any input.
*This post is locked for comments
Hi Aaron,
In fact, running reconcile on the open year corrected the issue. Added bonus, this reconcile literally takes a split second (I ran it twice thinking I hadn't run it the first time, as there was nothing in the process monitor queue).
Have a great day,
Maria.
Thank you Baku.
My apologies, I'm not a finance person and used the wrong terminology.
We do in fact have a single journal entry, with dates of Aug 31 for the trx, to be reversed Sept 1st.
The detailed T/B shows 1st part on Aug 31st, reversal on Sept 1st.
If I run the summary T/B to Aug 31st, it does not include the first part of the journal entry (ie. the totals on the summary and detail do not match, and are off by the amount of the journal entry).
If I run the summary T/B for Sept 1st (same for the detail), all appears good. My reports match, and the totals are as expected.
Anyone seen this before?
Thank you,
Maria.
Hi Maria,
If you post your original journal entry as reversing both will have same journal no. So the first entry will be on Aug and its reversed on Sep. Please refer the following post detailing reversing journal.
Hi Deborah , and All,
Weird. Weird. Weird.
I think we have this exact same problem (same dates / different year) - - a journal entry with date of 8/31/2015 and reversal on 9/01/2015 is showing up in September in both FRx and in the Summary T/B. However - - it's showing up correctly in the Detailed T/B.
This is the sort of trx we post every month without difficulty.
I just ran checklinks to see if anything might change - - no difference.
Can it be there's a bug? Or can anyone suggest something to check?
We're still using GP10.
Thank you,
Maria.
If the entry was posted on 9/17, FRX would show it as a 9/17 transaction as it goes by the posting date.
Deborah,
FRx ties transactions by date to fiscal periods based based on Dynamics GP Fiscal Period Setup.
Typically, FRx problems have several possible resolutions.
Here is a comprehensive checklist of potential resolutions and what to do when and if they fail.
Printing a year-end financial statement in FRx which is pulling the data from the wrong period in Great Plains.
If you have renamed the *.G32 files in the SYSDATA folder,
Created a new Catalog ID,
Renamed all the *.tmp files on the workstation and
Compacted the FRx database.
You have recalculated the Fiscal Periods and
reconciled the years in Dynamics.
When you print the report in FRx, it is still printing data for the wrong period.
Does frx go by the transaction date or the posting date. I see both of the entries were posted on 9/17. could this be why we are not seeing an entry in august?
Share
Report
All responses (
Answers (
10
