EMERGENCY!!! Fiscal Year Closing

I have just been told that my company did NOT close the fiscal year and have 
started recording sales for the new fiscal year.  I know that the data is 
date sensitive.  can I adjust the date and time on my machine to the last day 
of the FY and then close?  

My fiscal year is 12/1/2006 - 11/30/2007
Company failed to close fiscal year. Tells me 01/03/2008
Have customers who purchased after 12/1/2007

Will this only move the amounts upto the FY date to history or will all 
amounts (yearly summary, etc...) reflect 0.00? 

0
LIT (4)
1/3/2008 4:16:00 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
365 Views

Similar Articles

[PageSpeed] 0

From version 8 on the sales and payables series have had date sensitive 
closings so there shouldn't be any problem closing even though you've posted 
transactions in the new year.

"LIT" wrote:

> I have just been told that my company did NOT close the fiscal year and have 
> started recording sales for the new fiscal year.  I know that the data is 
> date sensitive.  can I adjust the date and time on my machine to the last day 
> of the FY and then close?  
> 
> My fiscal year is 12/1/2006 - 11/30/2007
> Company failed to close fiscal year. Tells me 01/03/2008
> Have customers who purchased after 12/1/2007
> 
> Will this only move the amounts upto the FY date to history or will all 
> amounts (yearly summary, etc...) reflect 0.00? 
> 
0
RRSBC (16)
1/3/2008 7:46:01 PM
Wrong answer, I had to recreate the the entries, luckily I made tables for 
the changes prior to closing.  After that it use an update query to restore 
the correct data.

"RR@SBC" wrote:

> From version 8 on the sales and payables series have had date sensitive 
> closings so there shouldn't be any problem closing even though you've posted 
> transactions in the new year.
> 
> "LIT" wrote:
> 
> > I have just been told that my company did NOT close the fiscal year and have 
> > started recording sales for the new fiscal year.  I know that the data is 
> > date sensitive.  can I adjust the date and time on my machine to the last day 
> > of the FY and then close?  
> > 
> > My fiscal year is 12/1/2006 - 11/30/2007
> > Company failed to close fiscal year. Tells me 01/03/2008
> > Have customers who purchased after 12/1/2007
> > 
> > Will this only move the amounts upto the FY date to history or will all 
> > amounts (yearly summary, etc...) reflect 0.00? 
> > 
0
LIT (4)
1/7/2008 2:44:01 PM
Reply:

Similar Artilces:

Page Breaks Problem ( Emergency , Gurus.. PleaseHelp)
Can any body help me immediately. Please understand the snario. I am setting the page breaks on my excel sheet. that i had generated b executing code from Visual Basic. When i first time generate the exce sheet the code used to set the page breaks executes right. but when second time execute the code. the code to set the page breaks, Fails. Below is given the code that i am using to set the page breaks. Plese help .. wrkSheet.HPageBreaks.Add Before:=Cells(Row, 1) wrkSheet.VPageBreaks.Add Before:=Cells(1, CmbMaxColumns+1) Follwing is the error that s show when i execute the code s...

Outlook 2003 Professional doesn't close.
Every time I close Outlook, I get the following message when I click on the icon in the task bar. "Outlook is not responding. If you are using an Exchange server e-mail account, you can cancel pending server requests by clicking the Outlook icon in the notifications area, and then clicking Cancel Server Request on the shortcut menu." Anyone have any idea what this is relating to? I'm on WinXP Pro, using Office 2002 pro. My ISP is running a Windows 2003 Server. Thanks. Common causes for Outlook remaining active is a PDA that is docked or Fax software, especially WinFax....

filter closed appointments from synchronization ? (CRM-Outlook-Client)
Hello CRM 4.0 Specialists, we have the following problem in our company: we have too less memory in our Exchange - only 25 MB per person. And CRM tries to put all appointments - even already closed - in Outlook. This definitivly kills our free space. Is there a possibility (even a dirty hack) to minimize this synchronization ? We only need the open appointments in Outlook. Any help would be great! Kind regards Matthias ...

Convert years:months to months
Hello- I am hoping to use Excel to convert data that inputted in a years:months format to just months. For example, I want to translate 5:3 to 63 months. I'm running into one hiccup: Excel views the inputted data as time and is translating it into 5:30 AM, making calculations challenging Does anyone have any tips? =HOUR(A1)*12+MINUTE(A1)/10 you may need to format the cell a General as Excel can be overhelpful and use a time format best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Jen" <jvarley@u.washington.edu> wrote in ...

IE CRM closes after login
Immediately after the login screen the browser dissapears. I have this problem on only 1 PC (windows XP & IE 6 SP1). After I completely reinstalled it, it worked for a while, but now it is doing it again. Please help! I cannot reinstall the everything on this PC every week.. We have seen browser problems when you have added tools into the browser like the google search bar etc make sure the browser is runnng with no addiitonal addins "Michael Szabo" <mihaisz@bondweb.com> wrote in message news:0b5301c3893c$32d94a10$a401280a@phx.gbl... > Immediately after the login ...

Closing another database with VBA
Hi, I’m having a problem with the code to do the following… 1- A user opens a file called Core. 2- Upon opening the splash screen (on the Form_Load event), it compares a version number it finds within the database to one that is in another database called Data. 3- If the versions are different, the Core file opens the Updater file. 4- The Updater file closes the Core file. 5- The Updater file copies the latest version of the Core file (located somewhere else) and replaces the first one with the latest version. 6- The Updater opens the newly copied Core file. 7- The Updater closes itself. ...

Mail downloads even when Outlook is closed
Hello, I had a weird experience that maybe someone can explain. Before I left for work two days ago I read my email and closed Outlook (I know I did--I double checked). At work later on I checked my email via webmail and the inbox was empty-- unusual. When I went home I opened Outlook and found many unread emails that had come in during the day, arriving well after I had closed Outlook and left home. How is it possible that Outlook can download mail even if it is closed? I was so sure that it must have been an error on my part that today I triple checked that I'd definitely closed Outloo...

Auto Close POS
Hello All, I would like to present a suggestion and pose a question of the same. We have two stores and in both locations we have found little use for NOT posting a z report at the end of each day (as in a blind close). That is to say, all of our cash reconciliation reporting is required to be closed daily and then the zz report to be run on the last day of the month. There is never to be any deviation from this. We have, in fact, been faced with the problem of our staff (cashiers) forgetting to post the z or zz report on time. And so my question (suggestion, if this has not been addr...

excel vba
is there a way to disable the close button on a userform such as password screen that would disable a person from being able to clos the userform by hitting the x button in the top right. I have it se up so that they have to enter a password to view the page, bu overlloked the fact that they can simply hit the close button. An ideas -- Message posted from http://www.ExcelForum.com Hi, Use the form's QueryClose Method Here is the (pasted) example from the Excel VBA Help file Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) 'Prevent user from closing ...

Users of a BU cannot close workflow activities
Hello there! I have a problem with all users from a specific BU. This BU is the parent of all the rest and has 5 users. Neither of them can Close Activities coming from workflow rules. I have granted them all privileges, even System Administrator and no luck... It is strange because they can see the button "Actions --> Close Task" and, when they press Complete, they get the following error : Error Details: You do not have sufficient permissions or access rights to perform this operation. Error Number: 0x80070005 Query String: /Activities/Task/edit.aspxid={4B1490CC-D821-49B1-9F6C...

Getting rid of: "The data file 'Personal Folders' was not closed properly. The file is being checked for problems."
I have been sharing my Outlook (2002) mail folders and settings between my laptop and my desktop computers by moving the entire outlook.pst back and forth. This has MOSTLY been working quite nicely. But ever since I started doing this, MOST (but not ALL) start-ups of Outlook have produced the following message: "The data file 'Personal Folders' was not closed properly. The file is being checked for problems." Then I have to wait (sometimes as long as 10 minutes) for Outlook to do whatever it is doing. Can anyone advise as to how to get rid of this irritating behavior? ...

Version 10
I need to understand how the additional fiscal periods for adjustments work in version 10. I found some KB articles on CustomerSource, but none pertain to version 10 and I can't find anything in the help files. Thanks. Follow the same rules as in 7, 8, and 9 for extra fiscal periods in GP10 -- Richard L. Whaley Author / Consultant / MVP Documentation for Software Users Get our Free Tips and Tricks Newsletter and check out our books at http://www.AccoladePublications.com "6538" wrote: > I need to understand how the additional fiscal periods for adjustments work ...

Creating a closed Phone activity in a single step
Hi, I have looked absolutely everywhere for a solution to this. As many of our processes are still outside of MS CRM much of our outbound sales/prospecting calling is driven by external processes. (example 1) our receptionist (who has no CRM access) gets a call from an existing customer interested in purchasing product from us. The account manager gets the message, looks up the record in CRM and immediately calls them. We need the sales person to record a phone activity to say they've 'touched' this account, however this isn't a to-do item, it is already closed. ...

how to code "close without saving"
How can I code a form to close without saving. do not want to even save the autonumber Any help here will be appreciated. Thanks in advance Dave In news:6BDC4402-6754-45DE-9A34-761EEE988292@microsoft.com, Dave <dave@accessdatapros> wrote: > How can I code a form to close without saving. do not want to even > save the autonumber > > Any help here will be appreciated. You can undo the form before closing it, to prevent the current record from being saved (assuming that it hasn't been saved already): Me.Undo DoCmd.Close acForm, Me.Name, acSaveNo (Note that ...

Multi Year GP Budget?
GP 10 & FRx 6.7. We are migrating to GP from MAS 500. In MAS, our budget data existed under one header (Current Budget). Each year's budget data was entered under this one Budget name (ID). In GP it appears that one Budget ID based on Fiscal Year can only contain data for one year. Is this correct? The whole point is for FRx column specifications to reference a single Budget ID regardless of the Base fiscal year you are reporting on. Can someone provide GP Budgeting answers? Thanks. You can only have one budget associated with a particular Budget ID. If you want ...

Diff between two dates formatted as years and months
I am trying to display an employee's length of service at a particular date using a simple formula to subtract one date from the other and format the result as y"y" m"m" so that I get eg. 2y 4m as the person's service. It is returning odd results eg. 0y 12m for diff between 1/1/04 and 1/1/05 and 1y 1m for diff between 31/12/03 and 1/1/05. Is there a more accurate method of doing this to ensure that I get the result I want? Thanks for all your help A complete explanation: http://www.cpearson.com/excel/datedif.htm -- Kind Regards, Niek Otten Microsoft ...

Closed Account
i changed status on one of my account to close, but when i click on banking, it still shows up but greyed out. is there anyways to remove it from the view? In microsoft.public.money, w0rm3y wrote: >i changed status on one of my account to close, but when i click on banking, >it still shows up but greyed out. is there anyways to remove it from the >view? From the account list, SortAccountListBy->HideClosedAccounts "Cal Learner-- MVP" wrote: > In microsoft.public.money, w0rm3y wrote: > > >i changed status on one of my account to close, but when i cli...

Formulas for birth year and age in user defined fields
I'm using outlook 2002. I want to create 2 user-defined fields in my contacts, but am having trouble figuring out how to do it: 1. Year of birth field, based on the value entered in the birthday field - I created a new user defined field, with the Type set as Formula, and the formula set as: Year ([Birthday]). The year is displayed, but formatted as a number (1,957) rather than a year (1957). How can I get the number to be displayed without the comma? 2. Age, based on difference between birthday and present date - Is there a simple formula to accomplish this? I haven't been ab...

Increasing Membership Expiration Date one year upon renewal
On a form called Members I have a field named ExpDate, as well as a button that opens a payment form. On the payment form, there are check boxes for new and renewal. as well as a button to close the payment form (and return to the Members form). How can I have the ExpDate on the Members form increase one year if the renewal check box is "true" on the payment form? Am I asking too much? If so, I'm willing to put a button on the Members form that would increase the ExpDate by a year. I did find "DateAdd( "yyyy", 1, ExpDate)" but couldn't make it work ...

Posting to a two year old, closed fiscal year
I need to post a G/L Entry to Fiscal Year 2005. Of course, I've already closed FY2005 and FY2006. According to TK 851093 and the GP Documentation, there is no way to post to a closed fiscal year that is more than one closed fiscal year ago. Has anyone found, devleoped, or used an "undocumented" procedure to accomplish posting to an older fiscal year. -- Thanks in advance, Tom Hamill Business Systems Analyst Athenaheatlh, Inc. Tom, The only way to do this is to contact Microsoft Professional Services. Then can open 2006 back up, thus making 2005 the last historical y...

which evet will fire when the client closes its connection with Socket server?
Hi, I created a Stream socket server derived from CSocket and some clients r connected to it.Which event is triggered when the Client closes its connection with server? or How do i know there is no connection between server and client? Reny ...

Closing Money w/o updating
When I was using Managing Your Money, it was possible to close the application without saving the data I just entered. This was useful if I made some mistake that was just too bothersome to undo. Is there any way to do that in Money? I'm using Premium 2005. I suppose I could restore from the previous backup, but that seemed like a lot of work, from my initial reading of it. Money is effectively a database and databases apply changes immediately; the only way to handle your problem is to always ensure that you backed up the last time you exited Money. You can then restore that if...

Converting dates to fiscal quarters
Is there a way to easily convert a date to a fiscal quarter Eg 1/1/03 converted to Q1-2003, 12/7/98 to Q4-199 Thanks in advance for your respons One way with the date in A1 ="Q"&INT((MONTH(A1)+2)/3)&" - "&TEXT(YEAR(A1),"@") -- Regards, Peo Sjoblom "James" <anonymous@discussions.microsoft.com> wrote in message news:9F45345C-B1DB-4353-8292-A216A88121A3@microsoft.com... > Is there a way to easily convert a date to a fiscal quarter? > Eg 1/1/03 converted to Q1-2003, 12/7/98 to Q4-1998 > > Thanks in advance for your res...

Min Max Close
Can someone tell me how to change RMS so that the Min, Max and Close buttons appear. thanks, This is a multi-part message in MIME format. ------=_NextPart_000_05F9_01C77143.D2BE41A0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Chris, Ctrl + F6 Screen | Transaction screen tab | Window button on bottom = right | check Show resizable border --=20 Jeff=20 Check Point Software =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3...

Fiscal Six-Month Periods
I have a database with a bunch of dates in it. I'd like to create a new calculated field that designates the associated date in a six-month period through a query. The periods go from April 1st to September 30th (1st half of our fiscal year) and then from October 1st to March 31st (2nd half of our fiscal year). So, a date in OBLG_DATE of 6/1/09 would be designated in the new field SFY_SIX as something like 2009S1. A date of 11/13/10 would be designated as something like 2010S2. Thanks for your help to this quite novice user in advance. This expression should calculat...