Epicor 904.507A issues after upgrade

Yahoo Archive
1
Regarding Item 3,

Below is the script that I used to fix this issue. We've had a support call open with Epicor for weeks, and had to fix this ourselves as Epicor support is still lost.

I hope you aren't still dealing with this, but I will post this here for future searchers.

Basically, several receipt detail lines had null received dates, or null arrived dates. This replaces the null date with the date from the header, and all seems to be well.

Adam

----BEGIN SQL SCRIPT----
SELECT DISTINCT VendorNum, PackSlip, ReceiptDate
INTO #tmpPackSlipDates
FROM RcvHead

UPDATE rd
SET rd.ReceiptDate = td.ReceiptDate,
rd.ArrivedDate = td.ReceiptDate
FROM RcvDtl rd
inner join #tmpPackSlipDates td
ON rd.VendorNum = td.VendorNum
AND rd.PackSlip = td.PackSlip
WHERE rd.ReceiptDate is null OR rd.ArrivedDate is null
----END SQL SCRIPT----



--- In vantage@yahoogroups.com, Paul Lipham <pml@...> wrote:
>
> We upgraded January 29th weekend from Vantage 6.1 to Epicor 904.507A and are having some major issues. I just wanted to see if anyone had any answers. Epicor support is working with us, but it's taking forever.
>
>
> 1.) All of our un-invoiced receipts that were in 6.1 and upgraded to E904 will not let us pull them into a AP invoice when adding a receipt line to the AP invoice. The PO looks good, the Receipt looks good and shows that the lines are not invoiced. But the AP side can't pull in the received lines. If I delete and re-enter a receipt then it seems to pull over fine.
>
> 2.) Our General Ledger opening balances are off. Not on all accounts, but lots of them. We have run the GL Verify balances as instructed by Epicor support, and it ran for 28 hours, but fixed little if anything.
>
> 3.) We have some strange things showing up in time phased inquiry. All related to a PO receipt and the exception is "inspection" however nothing is in inspection.
>
> Any help would be appreciated!!
>
>
> Paul Lipham
> Information Technology Manager
> Alabama Specialty Products, Inc.
> 152 Metal Samples Road
> Munford, AL 36268
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
We are using vantage 6.0 and we issued a finished assembly to a job, we created a pull qty and issued the assy, we used no operations or material under the job. We now need to reject the material but I see no way to reject the material from the job using the available rejection options (reject as operation, material, sub-con, other). Any suggestions? Thanks in advance.


Paul Smith
Inventory Management




________________________________


The information contained in this message is intended solely for the individual it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the content of this information is strictly prohibited. If you received this message in error, please delete it from any computer and notify the sender. If you suspect that this message may have been altered, please notify the sender.


[Non-text portions of this message have been removed]
3
Wouldn't the "assembly" be considered material to the job and should be
rejected as material?



Are you looking in the quality module to reject?









Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul Smith
Sent: Monday, February 07, 2011 3:36 PM
To: Vantage (vantage@yahoogroups.com)
Subject: [Vantage] Pull Quantity and Rejections






We are using vantage 6.0 and we issued a finished assembly to a job, we
created a pull qty and issued the assy, we used no operations or
material under the job. We now need to reject the material but I see no
way to reject the material from the job using the available rejection
options (reject as operation, material, sub-con, other). Any
suggestions? Thanks in advance.

Paul Smith
Inventory Management

________________________________

The information contained in this message is intended solely for the
individual it is specifically and originally addressed. This message and
its contents may contain confidential or privileged information. If you
are not the intended recipient, you are hereby notified that any
disclosure or distribution, or taking any action in reliance on the
content of this information is strictly prohibited. If you received this
message in error, please delete it from any computer and notify the
sender. If you suspect that this message may have been altered, please
notify the sender.

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





[Non-text portions of this message have been removed]
4
When rejected as material vantage is asking for and assembly number and seq number. It was issued as an assembly so I have no assembly number.... I was thinking that we will need to add operations under the assembly log into the operations, then we can reject the pull qty using reject from operations. Any other thoughts?




________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Monday, February 07, 2011 5:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Pull Quantity and Rejections



Wouldn't the "assembly" be considered material to the job and should be
rejected as material?

Are you looking in the quality module to reject?

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Paul Smith
Sent: Monday, February 07, 2011 3:36 PM
To: Vantage (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Pull Quantity and Rejections

We are using vantage 6.0 and we issued a finished assembly to a job, we
created a pull qty and issued the assy, we used no operations or
material under the job. We now need to reject the material but I see no
way to reject the material from the job using the available rejection
options (reject as operation, material, sub-con, other). Any
suggestions? Thanks in advance.

Paul Smith
Inventory Management

________________________________

The information contained in this message is intended solely for the
individual it is specifically and originally addressed. This message and
its contents may contain confidential or privileged information. If you
are not the intended recipient, you are hereby notified that any
disclosure or distribution, or taking any action in reliance on the
content of this information is strictly prohibited. If you received this
message in error, please delete it from any computer and notify the
sender. If you suspect that this message may have been altered, please
notify the sender.

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

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





________________________________


The information contained in this message is intended solely for the individual it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the content of this information is strictly prohibited. If you received this message in error, please delete it from any computer and notify the sender. If you suspect that this message may have been altered, please notify the sender.


[Non-text portions of this message have been removed]
5
Unfortunately no other thoughts at the moment...







Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul Smith
Sent: Tuesday, February 08, 2011 6:26 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Pull Quantity and Rejections





When rejected as material vantage is asking for and assembly number and
seq number. It was issued as an assembly so I have no assembly
number.... I was thinking that we will need to add operations under the
assembly log into the operations, then we can reject the pull qty using
reject from operations. Any other thoughts?

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Monday, February 07, 2011 5:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Pull Quantity and Rejections

Wouldn't the "assembly" be considered material to the job and should be
rejected as material?

Are you looking in the quality module to reject?

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Paul Smith
Sent: Monday, February 07, 2011 3:36 PM
To: Vantage (vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Pull Quantity and Rejections

We are using vantage 6.0 and we issued a finished assembly to a job, we
created a pull qty and issued the assy, we used no operations or
material under the job. We now need to reject the material but I see no
way to reject the material from the job using the available rejection
options (reject as operation, material, sub-con, other). Any
suggestions? Thanks in advance.

Paul Smith
Inventory Management

________________________________

The information contained in this message is intended solely for the
individual it is specifically and originally addressed. This message and
its contents may contain confidential or privileged information. If you
are not the intended recipient, you are hereby notified that any
disclosure or distribution, or taking any action in reliance on the
content of this information is strictly prohibited. If you received this
message in error, please delete it from any computer and notify the
sender. If you suspect that this message may have been altered, please
notify the sender.

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

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

________________________________

The information contained in this message is intended solely for the
individual it is specifically and originally addressed. This message and
its contents may contain confidential or privileged information. If you
are not the intended recipient, you are hereby notified that any
disclosure or distribution, or taking any action in reliance on the
content of this information is strictly prohibited. If you received this
message in error, please delete it from any computer and notify the
sender. If you suspect that this message may have been altered, please
notify the sender.

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





[Non-text portions of this message have been removed]
6
We upgraded January 29th weekend from Vantage 6.1 to Epicor 904.507A and are having some major issues. I just wanted to see if anyone had any answers. Epicor support is working with us, but it's taking forever.


1.) All of our un-invoiced receipts that were in 6.1 and upgraded to E904 will not let us pull them into a AP invoice when adding a receipt line to the AP invoice. The PO looks good, the Receipt looks good and shows that the lines are not invoiced. But the AP side can't pull in the received lines. If I delete and re-enter a receipt then it seems to pull over fine.

2.) Our General Ledger opening balances are off. Not on all accounts, but lots of them. We have run the GL Verify balances as instructed by Epicor support, and it ran for 28 hours, but fixed little if anything.

3.) We have some strange things showing up in time phased inquiry. All related to a PO receipt and the exception is "inspection" however nothing is in inspection.

Any help would be appreciated!!


Paul Lipham
Information Technology Manager
Alabama Specialty Products, Inc.
152 Metal Samples Road
Munford, AL 36268




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

All of these sound like problems we had when we converted from 5.1 to 9.05.601.


1. One user never entered the PO number at the header level. We had to go back and populate the PO field with custom code and we had to uncheck the received all check box and recheck it. Then they seemed to work. You might try just unchecking and re-checking the receive all box

2. Can't understand the 28 hrs. We ran verify balances and it finished in a few minutes and we had 14 years of transactions. Call back and get someone else on the phone. My past experience is that the GL group is pretty sharp.

3. We had same issue. We got a fix program from support. See call 5185390MPS
Good luck......

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Paul Lipham
Sent: Tuesday, February 08, 2011 11:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 904.507A issues after upgrade



We upgraded January 29th weekend from Vantage 6.1 to Epicor 904.507A and are having some major issues. I just wanted to see if anyone had any answers. Epicor support is working with us, but it's taking forever.

1.) All of our un-invoiced receipts that were in 6.1 and upgraded to E904 will not let us pull them into a AP invoice when adding a receipt line to the AP invoice. The PO looks good, the Receipt looks good and shows that the lines are not invoiced. But the AP side can't pull in the received lines. If I delete and re-enter a receipt then it seems to pull over fine.

2.) Our General Ledger opening balances are off. Not on all accounts, but lots of them. We have run the GL Verify balances as instructed by Epicor support, and it ran for 28 hours, but fixed little if anything.

3.) We have some strange things showing up in time phased inquiry. All related to a PO receipt and the exception is "inspection" however nothing is in inspection.

Any help would be appreciated!!

Paul Lipham
Information Technology Manager
Alabama Specialty Products, Inc.
152 Metal Samples Road
Munford, AL 36268

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



---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
8
In response to #2, make sure you verify balances. Also, I don't know your specifics such as setup of fiscal periods and years or your cutover criteria, however, there is a "new feature" in Epicor titled "transfer opening balances to next year". When our year rolled in January we couldn't figure out why our balances were off. We transferred balances and everything now matches up.

Hope this helps.

Jen
--- In vantage@yahoogroups.com, Keith Mailloux <keith.mailloux@...> wrote:
>
> Paul,
>
> All of these sound like problems we had when we converted from 5.1 to 9.05.601.
>
>
> 1. One user never entered the PO number at the header level. We had to go back and populate the PO field with custom code and we had to uncheck the received all check box and recheck it. Then they seemed to work. You might try just unchecking and re-checking the receive all box
>
> 2. Can't understand the 28 hrs. We ran verify balances and it finished in a few minutes and we had 14 years of transactions. Call back and get someone else on the phone. My past experience is that the GL group is pretty sharp.
>
> 3. We had same issue. We got a fix program from support. See call 5185390MPS
> Good luck......
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Paul Lipham
> Sent: Tuesday, February 08, 2011 11:44 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Epicor 904.507A issues after upgrade
>
>
>
> We upgraded January 29th weekend from Vantage 6.1 to Epicor 904.507A and are having some major issues. I just wanted to see if anyone had any answers. Epicor support is working with us, but it's taking forever.
>
> 1.) All of our un-invoiced receipts that were in 6.1 and upgraded to E904 will not let us pull them into a AP invoice when adding a receipt line to the AP invoice. The PO looks good, the Receipt looks good and shows that the lines are not invoiced. But the AP side can't pull in the received lines. If I delete and re-enter a receipt then it seems to pull over fine.
>
> 2.) Our General Ledger opening balances are off. Not on all accounts, but lots of them. We have run the GL Verify balances as instructed by Epicor support, and it ran for 28 hours, but fixed little if anything.
>
> 3.) We have some strange things showing up in time phased inquiry. All related to a PO receipt and the exception is "inspection" however nothing is in inspection.
>
> Any help would be appreciated!!
>
> Paul Lipham
> Information Technology Manager
> Alabama Specialty Products, Inc.
> 152 Metal Samples Road
> Munford, AL 36268
>
> [Non-text portions of this message have been removed]
>
>
>
> ---------------------------------
> This e-mail and any attachments may contain confidential and
> privileged information. If you are not the intended recipient,
> please notify the sender immediately by return e-mail, delete this
> e-mail and destroy any copies. Any dissemination or use of this
> information by a person other than the intended recipient is
> unauthorized and may be illegal.
>
> [Non-text portions of this message have been removed]
>
9
Thank you Keith and Jen! Your information help me out a lot. I just now had time to get back to the board. It's been a busy three weeks.

Paul

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jen
Sent: Tuesday, February 08, 2011 4:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 904.507A issues after upgrade



In response to #2, make sure you verify balances. Also, I don't know your specifics such as setup of fiscal periods and years or your cutover criteria, however, there is a "new feature" in Epicor titled "transfer opening balances to next year". When our year rolled in January we couldn't figure out why our balances were off. We transferred balances and everything now matches up.

Hope this helps.

Jen
--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Keith Mailloux <keith.mailloux@...> wrote:
>
> Paul,
>
> All of these sound like problems we had when we converted from 5.1 to 9.05.601.
>
>
> 1. One user never entered the PO number at the header level. We had to go back and populate the PO field with custom code and we had to uncheck the received all check box and recheck it. Then they seemed to work. You might try just unchecking and re-checking the receive all box
>
> 2. Can't understand the 28 hrs. We ran verify balances and it finished in a few minutes and we had 14 years of transactions. Call back and get someone else on the phone. My past experience is that the GL group is pretty sharp.
>
> 3. We had same issue. We got a fix program from support. See call 5185390MPS
> Good luck......
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Paul Lipham
> Sent: Tuesday, February 08, 2011 11:44 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Epicor 904.507A issues after upgrade
>
>
>
> We upgraded January 29th weekend from Vantage 6.1 to Epicor 904.507A and are having some major issues. I just wanted to see if anyone had any answers. Epicor support is working with us, but it's taking forever.
>
> 1.) All of our un-invoiced receipts that were in 6.1 and upgraded to E904 will not let us pull them into a AP invoice when adding a receipt line to the AP invoice. The PO looks good, the Receipt looks good and shows that the lines are not invoiced. But the AP side can't pull in the received lines. If I delete and re-enter a receipt then it seems to pull over fine.
>
> 2.) Our General Ledger opening balances are off. Not on all accounts, but lots of them. We have run the GL Verify balances as instructed by Epicor support, and it ran for 28 hours, but fixed little if anything.
>
> 3.) We have some strange things showing up in time phased inquiry. All related to a PO receipt and the exception is "inspection" however nothing is in inspection.
>
> Any help would be appreciated!!
>
> Paul Lipham
> Information Technology Manager
> Alabama Specialty Products, Inc.
> 152 Metal Samples Road
> Munford, AL 36268
>
> [Non-text portions of this message have been removed]
>
>
>
> ---------------------------------
> This e-mail and any attachments may contain confidential and
> privileged information. If you are not the intended recipient,
> please notify the sender immediately by return e-mail, delete this
> e-mail and destroy any copies. Any dissemination or use of this
> information by a person other than the intended recipient is
> unauthorized and may be illegal.
>
> [Non-text portions of this message have been removed]
>



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