Epicor 9 - help with GL

Yahoo Archive
1
We had to Verify GL Balances (General Ledger / General Ops) when we had a problem with our balances being off - had converted from 8.03. If you run that make sure everybody is out of the system. You don't want any GL transactions happening when it's running. Your database, number of transactions, and hardware all impact the time it takes to run. We have a large database on beefy hardware and it took us just over 2 hours, same process in our test environment took 8 hours.


[Non-text portions of this message have been removed]
2
We have the accountant here to close last quarter. I am trying to print out the Trial Balance. Not all my accounts are showing plus it is giving weird balances to accounts like sales and retained earnings. It looks like it is totaling things as far back as 2003! Has anyone had this issue? I check our totals by comparing the GL when we got our database back and it looked fine. Now I have this issue and I am puzzled. Any help would be greatly appreciated.

Sincerely,

Mary Horsey
Greene Rubber Company
HR/Finance Manager
20 Cross Street
Woburn MA 01801
mhorsey@...
781-497-1851 (p)
781-937-7881 (f)



[Non-text portions of this message have been removed]
3
Go into your COA and look to see if there is a button on top which says Balances need to be re-run.



________________________________
From: Mary Horsey <mhorsey@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, July 16, 2012 11:11 AM
Subject: [Vantage] Epicor 9 - help with GL


Â
We have the accountant here to close last quarter. I am trying to print out the Trial Balance. Not all my accounts are showing plus it is giving weird balances to accounts like sales and retained earnings. It looks like it is totaling things as far back as 2003! Has anyone had this issue? I check our totals by comparing the GL when we got our database back and it looked fine. Now I have this issue and I am puzzled. Any help would be greatly appreciated.

Sincerely,

Mary Horsey
Greene Rubber Company
HR/Finance Manager
20 Cross Street
Woburn MA 01801
mailto:mhorsey%40greenerubber.com
781-497-1851 (p)
781-937-7881 (f)

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




[Non-text portions of this message have been removed]
4
I do not see a button that says that.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Monday, July 16, 2012 11:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 - help with GL



Go into your COA and look to see if there is a button on top which says Balances need to be re-run.

________________________________
From: Mary Horsey <mhorsey@...<mailto:mhorsey%40greenerubber.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Monday, July 16, 2012 11:11 AM
Subject: [Vantage] Epicor 9 - help with GL


We have the accountant here to close last quarter. I am trying to print out the Trial Balance. Not all my accounts are showing plus it is giving weird balances to accounts like sales and retained earnings. It looks like it is totaling things as far back as 2003! Has anyone had this issue? I check our totals by comparing the GL when we got our database back and it looked fine. Now I have this issue and I am puzzled. Any help would be greatly appreciated.

Sincerely,

Mary Horsey
Greene Rubber Company
HR/Finance Manager
20 Cross Street
Woburn MA 01801
mailto:mhorsey%40greenerubber.com
781-497-1851 (p)
781-937-7881 (f)

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

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



[Non-text portions of this message have been removed]
5
go the verify balances under General Ledger - General Operations

Does it have update required showing? If so run this process. This check the balances are correct.

You can always run it even if it isn't marked Update Required - might be worth copying to test first and checking the result

--- In vantage@yahoogroups.com, Mary Horsey <mhorsey@...> wrote:
>
> We have the accountant here to close last quarter. I am trying to print out the Trial Balance. Not all my accounts are showing plus it is giving weird balances to accounts like sales and retained earnings. It looks like it is totaling things as far back as 2003! Has anyone had this issue? I check our totals by comparing the GL when we got our database back and it looked fine. Now I have this issue and I am puzzled. Any help would be greatly appreciated.
>
> Sincerely,
>
> Mary Horsey
> Greene Rubber Company
> HR/Finance Manager
> 20 Cross Street
> Woburn MA 01801
> mhorsey@...
> 781-497-1851 (p)
> 781-937-7881 (f)
>
>
>
> [Non-text portions of this message have been removed]
>
1 Like
6
If I go into Verify balances it says Update required. Would that be what you are referring to?


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Monday, July 16, 2012 11:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 - help with GL



Go into your COA and look to see if there is a button on top which says Balances need to be re-run.

________________________________
From: Mary Horsey <mhorsey@...<mailto:mhorsey%40greenerubber.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Monday, July 16, 2012 11:11 AM
Subject: [Vantage] Epicor 9 - help with GL


We have the accountant here to close last quarter. I am trying to print out the Trial Balance. Not all my accounts are showing plus it is giving weird balances to accounts like sales and retained earnings. It looks like it is totaling things as far back as 2003! Has anyone had this issue? I check our totals by comparing the GL when we got our database back and it looked fine. Now I have this issue and I am puzzled. Any help would be greatly appreciated.

Sincerely,

Mary Horsey
Greene Rubber Company
HR/Finance Manager
20 Cross Street
Woburn MA 01801
mailto:mhorsey%40greenerubber.com
781-497-1851 (p)
781-937-7881 (f)

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

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



[Non-text portions of this message have been removed]
7
OK, thanks. It does say update required so I am running that now.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of adrian.lauchlan
Sent: Monday, July 16, 2012 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 - help with GL



go the verify balances under General Ledger - General Operations

Does it have update required showing? If so run this process. This check the balances are correct.

You can always run it even if it isn't marked Update Required - might be worth copying to test first and checking the result

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Mary Horsey <mhorsey@...> wrote:
>
> We have the accountant here to close last quarter. I am trying to print out the Trial Balance. Not all my accounts are showing plus it is giving weird balances to accounts like sales and retained earnings. It looks like it is totaling things as far back as 2003! Has anyone had this issue? I check our totals by comparing the GL when we got our database back and it looked fine. Now I have this issue and I am puzzled. Any help would be greatly appreciated.
>
> Sincerely,
>
> Mary Horsey
> Greene Rubber Company
> HR/Finance Manager
> 20 Cross Street
> Woburn MA 01801
> mhorsey@...
> 781-497-1851 (p)
> 781-937-7881 (f)
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
8
Also, because you said some GL accounts are "missing", run the "Rebuild
Display GL Account" process after the update is done.

Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of adrian.lauchlan
Sent: Monday, July 16, 2012 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 - help with GL





go the verify balances under General Ledger - General Operations

Does it have update required showing? If so run this process. This check
the balances are correct.

You can always run it even if it isn't marked Update Required - might be
worth copying to test first and checking the result

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Mary
Horsey <mhorsey@...> wrote:
>
> We have the accountant here to close last quarter. I am trying to
print out the Trial Balance. Not all my accounts are showing plus it is
giving weird balances to accounts like sales and retained earnings. It
looks like it is totaling things as far back as 2003! Has anyone had
this issue? I check our totals by comparing the GL when we got our
database back and it looked fine. Now I have this issue and I am
puzzled. Any help would be greatly appreciated.
>
> Sincerely,
>
> Mary Horsey
> Greene Rubber Company
> HR/Finance Manager
> 20 Cross Street
> Woburn MA 01801
> mhorsey@...
> 781-497-1851 (p)
> 781-937-7881 (f)
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
1 Like
9
Thanks, I will do that Brian.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Roberts
Sent: Monday, July 16, 2012 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Epicor 9 - help with GL



Also, because you said some GL accounts are "missing", run the "Rebuild
Display GL Account" process after the update is done.

Brian.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of adrian.lauchlan
Sent: Monday, July 16, 2012 11:42 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Epicor 9 - help with GL

go the verify balances under General Ledger - General Operations

Does it have update required showing? If so run this process. This check
the balances are correct.

You can always run it even if it isn't marked Update Required - might be
worth copying to test first and checking the result

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Mary
Horsey <mhorsey@...> wrote:
>
> We have the accountant here to close last quarter. I am trying to
print out the Trial Balance. Not all my accounts are showing plus it is
giving weird balances to accounts like sales and retained earnings. It
looks like it is totaling things as far back as 2003! Has anyone had
this issue? I check our totals by comparing the GL when we got our
database back and it looked fine. Now I have this issue and I am
puzzled. Any help would be greatly appreciated.
>
> Sincerely,
>
> Mary Horsey
> Greene Rubber Company
> HR/Finance Manager
> 20 Cross Street
> Woburn MA 01801
> mhorsey@...
> 781-497-1851 (p)
> 781-937-7881 (f)
>
>
>
> [Non-text portions of this message have been removed]
>

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



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



________________________________
From: Mary Horsey <mhorsey@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, July 16, 2012 11:43 AM
Subject: RE: [Vantage] Epicor 9 - help with GL


Â
If I go into Verify balances it says Update required. Would that be what you are referring to?


From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Monday, July 16, 2012 11:32 AM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Epicor 9 - help with GL



Go into your COA and look to see if there is a button on top which says Balances need to be re-run.

________________________________
From: Mary Horsey <mailto:mhorsey%40greenerubber.com<mailto:mhorsey%40greenerubber.com>>
To: "mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>" <mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Monday, July 16, 2012 11:11 AM
Subject: [Vantage] Epicor 9 - help with GL


We have the accountant here to close last quarter. I am trying to print out the Trial Balance. Not all my accounts are showing plus it is giving weird balances to accounts like sales and retained earnings. It looks like it is totaling things as far back as 2003! Has anyone had this issue? I check our totals by comparing the GL when we got our database back and it looked fine. Now I have this issue and I am puzzled. Any help would be greatly appreciated.

Sincerely,

Mary Horsey
Greene Rubber Company
HR/Finance Manager
20 Cross Street
Woburn MA 01801
mailto:mhorsey%40greenerubber.com
781-497-1851 (p)
781-937-7881 (f)

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

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


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




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

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Monday, July 16, 2012 12:00 PM
To: Vantage User Group
Subject: Re: [Vantage] Epicor 9 - help with GL



Correct

________________________________
From: Mary Horsey <mhorsey@...<mailto:mhorsey%40greenerubber.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Monday, July 16, 2012 11:43 AM
Subject: RE: [Vantage] Epicor 9 - help with GL


If I go into Verify balances it says Update required. Would that be what you are referring to?

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Monday, July 16, 2012 11:32 AM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Epicor 9 - help with GL

Go into your COA and look to see if there is a button on top which says Balances need to be re-run.

________________________________
From: Mary Horsey <mailto:mhorsey%40greenerubber.com<mailto:mhorsey%40greenerubber.com>>
To: "mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>" <mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Monday, July 16, 2012 11:11 AM
Subject: [Vantage] Epicor 9 - help with GL

We have the accountant here to close last quarter. I am trying to print out the Trial Balance. Not all my accounts are showing plus it is giving weird balances to accounts like sales and retained earnings. It looks like it is totaling things as far back as 2003! Has anyone had this issue? I check our totals by comparing the GL when we got our database back and it looked fine. Now I have this issue and I am puzzled. Any help would be greatly appreciated.

Sincerely,

Mary Horsey
Greene Rubber Company
HR/Finance Manager
20 Cross Street
Woburn MA 01801
mailto:mhorsey%40greenerubber.com
781-497-1851 (p)
781-937-7881 (f)

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

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

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

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



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