First pass db upgrade from 8.03 to 9 - Financials (GL) accounts

Yahoo Archive
1

Thanks for all the help William.  I ran the “verify account balances” and it “looks” like that might have fixed us up.  Just don’t know why Epicor wouldn’t have told us to do that…

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 16, 2015 8:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

Also ensure that your GL is posting COS and WIP in summary (if you want it) vice the default of detailed for E9.

 

We did not catch this till the first month was posted after going live.

 

 

William R. King
IT Analyst
Topura America Fastener, Inc.
1070 Monterey Court - Bowling Green, KY  42101
Voice: 270-901-1579

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 4:29 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

They should have verified the GL matches  - I would put it back on them

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 3:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 






Calvin, we had Epicor do the upgrade, wouldn’t they have known to do that?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

Mike -

For a starting point...

If there was no transaction in the periods that were upgraded you would not see the financial entry. Make sure that conversion 10080 was run for more than the current year. This utility would convert financials from prior periods. Upon completion I would run the verify balances on the GL to reset and make sure the numbers are correct.

Thank you in advance,
Calvin Dekker
[CB]<http://www.codabears.com/>
630-672-7688 x1484

[Untitled-1] <https://www.facebook.com/CodaBearsInc> [Untitled-2] <http://www.linkedin.com/company/codabears-inc> [Untitled-3] <https://twitter.com/CodaBearsInc> [G+] <http://google.com/+CodaBearsIncRoselle>
[cid:5F7B4A7C-3EB2-41BA-9D90-EB6A55AA1138]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

We recently had our first pass upgrade from 8.03 to 9 and found there were numerous accounts that did not come over and lots of accounts whose balances were way off? Anyone have this issue or know what might have caused it?

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...<mailto:MAbell@...>

[Non-text portions of this message have been removed]

 






2

We recently had our first pass upgrade from 8.03 to 9 and found there were numerous accounts that did not come over and lots of accounts whose balances were way off?  Anyone have this issue or know what might have caused it?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 

3
Mike -

For a starting point...

If there was no transaction in the periods that were upgraded you would not see the financial entry. Make sure that conversion 10080 was run for more than the current year. This utility would convert financials from prior periods. Upon completion I would run the verify balances on the GL to reset and make sure the numbers are correct.

Thank you in advance,
Calvin Dekker
[CB]<http://www.codabears.com/>
630-672-7688 x1484

[Untitled-1] <https://www.facebook.com/CodaBearsInc> [Untitled-2] <http://www.linkedin.com/company/codabears-inc> [Untitled-3] <https://twitter.com/CodaBearsInc> [G+] <http://google.com/+CodaBearsIncRoselle>
[cid:5F7B4A7C-3EB2-41BA-9D90-EB6A55AA1138]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up


We recently had our first pass upgrade from 8.03 to 9 and found there were numerous accounts that did not come over and lots of accounts whose balances were way off? Anyone have this issue or know what might have caused it?

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...<mailto:MAbell@...>




[Non-text portions of this message have been removed]
4

We paid Epicor to convert Symix data to V8 back in 2006. When we used the DUU to upgrade to 9, the opening balances from 2006 did not get populated in the 9.04.500 database. I have to dump those 450 records into the db every time we test migrate.

If using the DUU, run conversion 10080 at the 9.04 level – do not run at 9.05.702 unless you want to spend DAYS doing it

Once you get to 9.05.702, run the Verify Balance program and then check your GL

 

We found we will make some one sided entries in E10 to offset some ‘funny’ stuff that exists in our V8 data, but after that it matches up.

 

Good luck – Bernie.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 




We recently had our first pass upgrade from 8.03 to 9 and found there were numerous accounts that did not come over and lots of accounts whose balances were way off?  Anyone have this issue or know what might have caused it?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 




5

Bernie, we had Epicor do our first pass upgrade, we didn’t do it on our own. Any idea on what I need to do?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:25 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

We paid Epicor to convert Symix data to V8 back in 2006. When we used the DUU to upgrade to 9, the opening balances from 2006 did not get populated in the 9.04.500 database. I have to dump those 450 records into the db every time we test migrate.

If using the DUU, run conversion 10080 at the 9.04 level – do not run at 9.05.702 unless you want to spend DAYS doing it

Once you get to 9.05.702, run the Verify Balance program and then check your GL

 

We found we will make some one sided entries in E10 to offset some ‘funny’ stuff that exists in our V8 data, but after that it matches up.

 

Good luck – Bernie.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 





We recently had our first pass upgrade from 8.03 to 9 and found there were numerous accounts that did not come over and lots of accounts whose balances were way off?  Anyone have this issue or know what might have caused it?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 





6

Calvin, we had Epicor do the upgrade, wouldn’t they have known to do that?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

Mike -

For a starting point...

If there was no transaction in the periods that were upgraded you would not see the financial entry. Make sure that conversion 10080 was run for more than the current year. This utility would convert financials from prior periods. Upon completion I would run the verify balances on the GL to reset and make sure the numbers are correct.

Thank you in advance,
Calvin Dekker
[CB]<http://www.codabears.com/>
630-672-7688 x1484

[Untitled-1] <https://www.facebook.com/CodaBearsInc> [Untitled-2] <http://www.linkedin.com/company/codabears-inc> [Untitled-3] <https://twitter.com/CodaBearsInc> [G+] <http://google.com/+CodaBearsIncRoselle>
[cid:5F7B4A7C-3EB2-41BA-9D90-EB6A55AA1138]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

We recently had our first pass upgrade from 8.03 to 9 and found there were numerous accounts that did not come over and lots of accounts whose balances were way off? Anyone have this issue or know what might have caused it?

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...<mailto:MAbell@...>

[Non-text portions of this message have been removed]

7
Epicor did our upgrade for us from Vantage 5.2 Epicor 9.05. Upon our first pass we had a few GL issues also. The tech that did our data conversion was responsive at advising us how to handle the issues, as well as tech support.Â

These were my notes Regarding the GLÂ (had to do these each pass)

1) We had found GL errors during our first pass and rec'd a fix program that we had to run after each pass. This was unique to our company.
2) Run the "Verify GL Balances" for each company
3) We also had a GL issue with just one of our companies. The fix for this was for our controller to a journal entry and then run the "transfer balances" for each year 2000-current. (sorry I don't have the details the controller handled it)




8

Our problems are major.  It actually looks like it never resets any of the account balances after each year was closed since 1998.  It just keeps adding them up year after year…

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 3:54 PM
To: Vantage List
Subject: Re: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

Epicor did our upgrade for us from Vantage 5.2  Epicor 9.05. Upon our first pass we had a few GL issues also.  The tech that did our data conversion was responsive at advising us how to handle the issues, as well as tech support. 

 

These were my notes Regarding the GL (had to do these each pass)

 

1) We had found GL errors during our first pass and rec'd a fix program that we had to run after each pass.  This was unique to our company.

2) Run the "Verify GL Balances" for each company

3) We also had a GL issue with just one of our companies.  The fix for this was for our controller to a journal entry and then run the "transfer balances" for each year 2000-current. (sorry I don't have the details the controller handled it)

 

 

 

 

9

They should have verified the GL matches  - I would put it back on them

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 3:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 




Calvin, we had Epicor do the upgrade, wouldn’t they have known to do that?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

Mike -

For a starting point...

If there was no transaction in the periods that were upgraded you would not see the financial entry. Make sure that conversion 10080 was run for more than the current year. This utility would convert financials from prior periods. Upon completion I would run the verify balances on the GL to reset and make sure the numbers are correct.

Thank you in advance,
Calvin Dekker
[CB]<http://www.codabears.com/>
630-672-7688 x1484

[Untitled-1] <https://www.facebook.com/CodaBearsInc> [Untitled-2] <http://www.linkedin.com/company/codabears-inc> [Untitled-3] <https://twitter.com/CodaBearsInc> [G+] <http://google.com/+CodaBearsIncRoselle>
[cid:5F7B4A7C-3EB2-41BA-9D90-EB6A55AA1138]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

We recently had our first pass upgrade from 8.03 to 9 and found there were numerous accounts that did not come over and lots of accounts whose balances were way off? Anyone have this issue or know what might have caused it?

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...<mailto:MAbell@...>

[Non-text portions of this message have been removed]

 




10

Also ensure that your GL is posting COS and WIP in summary (if you want it) vice the default of detailed for E9.

 

We did not catch this till the first month was posted after going live.

 

 

William R. King
IT Analyst
Topura America Fastener, Inc.
1070 Monterey Court - Bowling Green, KY  42101
Voice: 270-901-1579

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 4:29 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

They should have verified the GL matches  - I would put it back on them

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 3:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 





Calvin, we had Epicor do the upgrade, wouldn’t they have known to do that?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

 

 

Mike -

For a starting point...

If there was no transaction in the periods that were upgraded you would not see the financial entry. Make sure that conversion 10080 was run for more than the current year. This utility would convert financials from prior periods. Upon completion I would run the verify balances on the GL to reset and make sure the numbers are correct.

Thank you in advance,
Calvin Dekker
[CB]<http://www.codabears.com/>
630-672-7688 x1484

[Untitled-1] <https://www.facebook.com/CodaBearsInc> [Untitled-2] <http://www.linkedin.com/company/codabears-inc> [Untitled-3] <https://twitter.com/CodaBearsInc> [G+] <http://google.com/+CodaBearsIncRoselle>
[cid:5F7B4A7C-3EB2-41BA-9D90-EB6A55AA1138]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 15, 2015 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] First pass db upgrade from 8.03 to 9 - Financials (GL) accounts screwed up

We recently had our first pass upgrade from 8.03 to 9 and found there were numerous accounts that did not come over and lots of accounts whose balances were way off? Anyone have this issue or know what might have caused it?

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...<mailto:MAbell@...>

[Non-text portions of this message have been removed]