You asked for any ideas.........this is really ugly, but.......
The only way I can think of to "clean" POSTED data is to enter reversing
entries for ALL those invoices. Credit memos and debit memos respectively.
Then re-enter those invoices.
Then there is the issue of all those invoices that have already been
paid....... void the checks? Seems to me, the sweeping General Ledger
entries are the best way to deal with posted data. This year will be
memorable one way or another. Did support have any brainstorms for you?
Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0
-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Wednesday, January 08, 2003 6:11 PM
To: vantage@yahoogroups.com
Subject: Re:RE: [Vantage] Fiscal Year Change Problem - MAYDAY MAYDAY
Purged GL history for 2002 and tried to edit Fiscal periods. No go. Still
seeing the invoices that have the incorrect fiscal year and period
referenced.
Any other ideas? Anyone?
Mike Lowe
Connor
____________________Reply Separator____________________
Subject: RE: [Vantage] Fiscal Year Change Problem - MAYDAY MAYDAY
Author: <vantage@yahoogroups.com>
Date: 1/8/2003 12:33 PM
We haven't done this exact thing, but we just finished converting to a
Calendar year from a fiscal. It Doesn't sound too bad, but we had to reuse
some old fiscal periods which involved purging some GL data. I would assume
you could run some GL reports from your Singapore office and then purge out
the GL data for the two months, no big deal really, and then ditch the last
two periods for 2002, change your fiscal year to be 10 months and put in
2003. then enter your begging balances reflecting the information from your
GL reporting. ???
Paul L.
-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Wednesday, January 08, 2003 12:19 PM
To: vantage@yahoogroups.com
Cc: Socalvantage@yahoogroups.com
Subject: [Vantage] Fiscal Year Change Problem - MAYDAY MAYDAY
Hi All,
In 2002 we changed our fiscal year from a calendar year to a year ending
10/31/02. No problem, we just changed the number of periods in Fiscal
Period
maintenance from 12 to 10. Then, created 2003 with the correct 12 periods.
Worked great.
Except...
We forgot to make this change in our Singapore division. So, we have been
posting merrily along for November and December under the old fiscal period
structure. Since we've posted we can't go back and change...you know the
drill.
Long story short, we need Singapore to be able to match the corporate fiscal
year.
Has anyone else committed this blunder? If so, how was the problem
resolved?
Any ideas?
Mike Lowe
Connor Manufacturing Services
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
----------
Received: from alv-web1.alvaka.net [207.213.32.80] by la-smtpg.connorms.com
(ccMail Link to SMTP R8.31.00.5)
; Wed, 08 Jan 2003 10:35:25 -0800
Return-Path:
<sentto-20369-36888-1042051414-MLowe=connorms.com@...>
Received: from n33.grp.scd.yahoo.com ([66.218.66.101])
by alv-web1.alvaka.net (NAVGW 2.5.1.12) with SMTP id M2003010810455312916
for <MLowe@...>; Wed, 08 Jan 2003 10:45:53 -0800
X-eGroups-Return:
sentto-20369-36888-1042051414-MLowe=connorms.com@...
Received: from [66.218.67.196] by n33.grp.scd.yahoo.com with NNFMP; 08 Jan
2003 18:43:35 -0000
X-Sender: pml@...
X-Apparently-To: vantage@yahoogroups.com
Received: (EGP: mail-8_2_3_0); 8 Jan 2003 18:43:34 -0000
Received: (qmail 10209 invoked from network); 8 Jan 2003 18:43:33 -0000
Received: from unknown (66.218.66.218)
by m3.grp.scd.yahoo.com with QMQP; 8 Jan 2003 18:43:33 -0000
Received: from unknown (HELO alspi.com) (208.215.160.143)
by mta3.grp.scd.yahoo.com with SMTP; 8 Jan 2003 18:43:33 -0000
To: <vantage@yahoogroups.com>
Message-ID: <004701c2b744$8201a440$df5cf8d0@...>
In-Reply-To: <0301081042.AA1042049962@...>
From: "Paul Lipham" <pml@...>
X-Yahoo-Profile: aspi36268
MIME-Version: 1.0
Mailing-List: list vantage@yahoogroups.com; contact
vantage-owner@yahoogroups.com
Delivered-To: mailing list vantage@yahoogroups.com
Precedence: bulk
List-Unsubscribe: <mailto:vantage-unsubscribe@yahoogroups.com>
Date: Wed, 8 Jan 2003 12:33:57 -0600
Subject: RE: [Vantage] Fiscal Year Change Problem - MAYDAY MAYDAY
Reply-To: vantage@yahoogroups.com
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]
The only way I can think of to "clean" POSTED data is to enter reversing
entries for ALL those invoices. Credit memos and debit memos respectively.
Then re-enter those invoices.
Then there is the issue of all those invoices that have already been
paid....... void the checks? Seems to me, the sweeping General Ledger
entries are the best way to deal with posted data. This year will be
memorable one way or another. Did support have any brainstorms for you?
Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0
-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Wednesday, January 08, 2003 6:11 PM
To: vantage@yahoogroups.com
Subject: Re:RE: [Vantage] Fiscal Year Change Problem - MAYDAY MAYDAY
Purged GL history for 2002 and tried to edit Fiscal periods. No go. Still
seeing the invoices that have the incorrect fiscal year and period
referenced.
Any other ideas? Anyone?
Mike Lowe
Connor
____________________Reply Separator____________________
Subject: RE: [Vantage] Fiscal Year Change Problem - MAYDAY MAYDAY
Author: <vantage@yahoogroups.com>
Date: 1/8/2003 12:33 PM
We haven't done this exact thing, but we just finished converting to a
Calendar year from a fiscal. It Doesn't sound too bad, but we had to reuse
some old fiscal periods which involved purging some GL data. I would assume
you could run some GL reports from your Singapore office and then purge out
the GL data for the two months, no big deal really, and then ditch the last
two periods for 2002, change your fiscal year to be 10 months and put in
2003. then enter your begging balances reflecting the information from your
GL reporting. ???
Paul L.
-----Original Message-----
From: Mike Lowe [mailto:MLowe@...]
Sent: Wednesday, January 08, 2003 12:19 PM
To: vantage@yahoogroups.com
Cc: Socalvantage@yahoogroups.com
Subject: [Vantage] Fiscal Year Change Problem - MAYDAY MAYDAY
Hi All,
In 2002 we changed our fiscal year from a calendar year to a year ending
10/31/02. No problem, we just changed the number of periods in Fiscal
Period
maintenance from 12 to 10. Then, created 2003 with the correct 12 periods.
Worked great.
Except...
We forgot to make this change in our Singapore division. So, we have been
posting merrily along for November and December under the old fiscal period
structure. Since we've posted we can't go back and change...you know the
drill.
Long story short, we need Singapore to be able to match the corporate fiscal
year.
Has anyone else committed this blunder? If so, how was the problem
resolved?
Any ideas?
Mike Lowe
Connor Manufacturing Services
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
----------
Received: from alv-web1.alvaka.net [207.213.32.80] by la-smtpg.connorms.com
(ccMail Link to SMTP R8.31.00.5)
; Wed, 08 Jan 2003 10:35:25 -0800
Return-Path:
<sentto-20369-36888-1042051414-MLowe=connorms.com@...>
Received: from n33.grp.scd.yahoo.com ([66.218.66.101])
by alv-web1.alvaka.net (NAVGW 2.5.1.12) with SMTP id M2003010810455312916
for <MLowe@...>; Wed, 08 Jan 2003 10:45:53 -0800
X-eGroups-Return:
sentto-20369-36888-1042051414-MLowe=connorms.com@...
Received: from [66.218.67.196] by n33.grp.scd.yahoo.com with NNFMP; 08 Jan
2003 18:43:35 -0000
X-Sender: pml@...
X-Apparently-To: vantage@yahoogroups.com
Received: (EGP: mail-8_2_3_0); 8 Jan 2003 18:43:34 -0000
Received: (qmail 10209 invoked from network); 8 Jan 2003 18:43:33 -0000
Received: from unknown (66.218.66.218)
by m3.grp.scd.yahoo.com with QMQP; 8 Jan 2003 18:43:33 -0000
Received: from unknown (HELO alspi.com) (208.215.160.143)
by mta3.grp.scd.yahoo.com with SMTP; 8 Jan 2003 18:43:33 -0000
To: <vantage@yahoogroups.com>
Message-ID: <004701c2b744$8201a440$df5cf8d0@...>
In-Reply-To: <0301081042.AA1042049962@...>
From: "Paul Lipham" <pml@...>
X-Yahoo-Profile: aspi36268
MIME-Version: 1.0
Mailing-List: list vantage@yahoogroups.com; contact
vantage-owner@yahoogroups.com
Delivered-To: mailing list vantage@yahoogroups.com
Precedence: bulk
List-Unsubscribe: <mailto:vantage-unsubscribe@yahoogroups.com>
Date: Wed, 8 Jan 2003 12:33:57 -0600
Subject: RE: [Vantage] Fiscal Year Change Problem - MAYDAY MAYDAY
Reply-To: vantage@yahoogroups.com
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]