|
|
||||||
|
#1
03-11-08, 06:50 PM
|
|
|
|
|
We posted GL entries to period 12/07 for an account. This year is now closed
and marked historical. When I run a GL Detail Inquiry on this account and enter a date range of 12/01/07 to current these entries are NOT included. If I run the GL History Detail Inquiry the entries posted to 12/07 appear. So the entries were posted however they are not part of the regular Detail Inquiry. As a result my ending balance for the account is incorrect because it's missing the 12/07 entries. Why is this happening? How can I correct? |
|
|
|
#2
03-11-08, 07:18 PM
|
|
|
|
|
Danelle:
IN GP, when you close a year, that year's data becomes Historical. That is why you have to use the Historical Detail inquiry to see it. Frank Hamelly MCP-GP, MCT East Coast Dynamics www.eastcoast-dynamics.com |
|
#3
03-11-08, 07:42 PM
|
|
|
|
|
Danelle,
I typically recommend using the Account Transactions SmartList to get to this type of report. You can bring in all the information the Detail (or historical) Inquiry shows plus more....and you can cross years in SmartList with no problem. |
|
#4
03-11-08, 08:41 PM
|
|
|
|
|
I think I need to clarify my problem a bit...I don't think this is a
reporting issue... E.g. the History Summary Inquiry shows a P12/2007 Period Balance of $6927.08 but the Summary Inquiry shows a P1/2008 Beginning Balance of 10,607.33. Why would the ending balance of 2007 not roll over forward to the opening balance of 2008. How can we correct? "Victoria [MVP]" wrote: [..] |
|
#5
03-17-08, 01:43 AM
|
|
|
|
|
The first thing I would do is run Reconcile on your financial series to see
if maybe the summary is wrong. Check your Detail Inquiry and History Detail instead of the summary. If you do have a situation where you posted a transaction to history and it didn't roll forward, look up the journal entry number in the Journal Entry Inquiry, and see if it's there in the open year. The audit trail code should start out GLTHS. Look up the entry posted to the history year (should be the same JE number) detail inquiry and make sure they have the same GLTHS audit trail code. Also check to see if you can roll forward retained earnings. Check also to make sure the account is set to the correct account type (BS or PL) Let me know what you find. "Danelle Sloboda" wrote: [..] |
|
|
| Similar Threads | |
| Match Prior Billing Period Closing Balance to New Billing Period O As described above. I would like a query to test if the balance carries forward correctly. I have the following fields to match on: Account Number Period Open Date Period... |
|
| prior period financials how does one create a financial statement for a prior period. ie Jan or Feb or March? thanks |
|
| customer period summary inquiry Quick question, I have the enviable task of tying an inherited crystal report with customer summary information back to the customer period summary inquiry window. But, I... |
|
| Application/Inquiry Reversal should allow me to specify period When reversing a payment the system will automatically post to current period. This is a problem because it will not affect the Aged AR report...so a check reversed or... |
|
| CCM log inquiry - failed to see activity snippet of log included I clicked on a workstation to install the client. I checked the CCM log for 50 minutes, and it did not record any attempt to contatc the client. Why might that be: here... |
|
|
All times are GMT. The time now is 12:47 PM. | Privacy Policy
|
Prior period entries not included in inquiry