Inventory WIP Reconciliation report not balancing

Yahoo Archive
1
We're at 9.05.605. We had problems with the Inv/Wip reconciliation report not balancing too. The unposted transactions did not match what went to the review journal - that was the clue that is was a bug in the inv/wip report. Epicor gave us a fix, but right now I've got 3 versions of IM70.r to swap in and out - if one of the reports will not balance. problem related to Labor and Invoice transactions.
If you don't think it's bug related,
you can export the detail to a spreadsheet to try to determine which transaction type does not have the debits and credits match.

We've had problems with PUR-UKN transactions not matching - because the GL control/account number was missing on the PO line (Epicor has a fix for that) If you can narrow it down to which transaction type does not balance, then maybe you can see if you are missing a GL control setup somewhere, or have Epicor help troubleshoot the problem.


>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Deirdre Sykes
> Sent: Tuesday, March 27, 2012 3:28 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: Inventory WIP Reconciliation report not balancing
>
>
2
We are on Epicor 9.05.606 and during one of our testing it was discovered that the inventory WIP reconciliation report did not balance. We were able to determine that an other type of PO was generated before the posting rules were imported. This caused the system not to know where to post the debit and only created the credit entry to AP clearing. We were told that we could post the one-sided entry from the review journal. We were unable to find in the review journal how to force the entry to the general ledger.

Any ideas???
3
In Company Configuration under Modules --> Finance--> General Ledger there is a checkbox that allows you to post unbalanced journal entries (under the Option section).
Not sure this is what you are looking for but it might help.

Sylvia


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Deirdre T
Sent: Monday, March 26, 2012 11:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Inventory WIP Reconciliation report not balancing



We are on Epicor 9.05.606 and during one of our testing it was discovered that the inventory WIP reconciliation report did not balance. We were able to determine that an other type of PO was generated before the posting rules were imported. This caused the system not to know where to post the debit and only created the credit entry to AP clearing. We were told that we could post the one-sided entry from the review journal. We were unable to find in the review journal how to force the entry to the general ledger.

Any ideas???



[Non-text portions of this message have been removed]
4
We tried that and the entry still went to the review journal.

Deirdre Sykes | Staff Accountant
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@...<mailto:dsykes@...> | Phone: 630.590.8130 | Fax: 630.325.8197


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sylvia Hunts
Sent: Monday, March 26, 2012 10:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inventory WIP Reconciliation report not balancing



In Company Configuration under Modules --> Finance--> General Ledger there is a checkbox that allows you to post unbalanced journal entries (under the Option section).
Not sure this is what you are looking for but it might help.

Sylvia

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Deirdre T
Sent: Monday, March 26, 2012 11:00 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Inventory WIP Reconciliation report not balancing

We are on Epicor 9.05.606 and during one of our testing it was discovered that the inventory WIP reconciliation report did not balance. We were able to determine that an other type of PO was generated before the posting rules were imported. This caused the system not to know where to post the debit and only created the credit entry to AP clearing. We were told that we could post the one-sided entry from the review journal. We were unable to find in the review journal how to force the entry to the general ledger.

Any ideas???

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


CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.


[Non-text portions of this message have been removed]
5
Epicor wrote a fix for me when our Inventory WIP-REC was out of balance. Old supplier mysteriously lost the debit side of the GL control after migrating to 9.04. See attached.

Ed Kowalski
Morton Manufacturing Co.
700 Liberty Drive
Libertyville, IL 60048
847-362-5400 x104
847-362-5434 fax



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

There is nothing attached.

Deirdre Sykes | Staff Accountant
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@...<mailto:dsykes@...> | Phone: 630.590.8130 | Fax: 630.325.8197


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kowalski, Ed J.
Sent: Tuesday, March 27, 2012 2:15 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Re: Inventory WIP Reconciliation report not balancing



Epicor wrote a fix for me when our Inventory WIP-REC was out of balance. Old supplier mysteriously lost the debit side of the GL control after migrating to 9.04. See attached.

Ed Kowalski
Morton Manufacturing Co.
700 Liberty Drive
Libertyville, IL 60048
847-362-5400 x104
847-362-5434 fax

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


CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.


[Non-text portions of this message have been removed]
7
We've also received to one time fix for the report not balancing. Fixed the
issue for us.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Deirdre Sykes
Sent: Tuesday, March 27, 2012 3:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Inventory WIP Reconciliation report not balancing





Ed,

There is nothing attached.

Deirdre Sykes | Staff Accountant
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@... <mailto:dsykes%40gsitech.com> <mailto:dsykes@...
<mailto:dsykes%40gsitech.com> > | Phone: 630.590.8130 | Fax: 630.325.8197

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Kowalski, Ed J.
Sent: Tuesday, March 27, 2012 2:15 PM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com> '
Subject: [Vantage] Re: Inventory WIP Reconciliation report not balancing

Epicor wrote a fix for me when our Inventory WIP-REC was out of balance. Old
supplier mysteriously lost the debit side of the GL control after migrating
to 9.04. See attached.

Ed Kowalski
Morton Manufacturing Co.
700 Liberty Drive
Libertyville, IL 60048
847-362-5400 x104
847-362-5434 fax

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

CONFIDENTIALITY: The information contained in this email message, including
any attachment(s), may be privileged and confidential and protected from
disclosure. The email is not intended for transmission to, or receipt by,
any unauthorized persons. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message
to the intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication or use of the information
contained herein is strictly prohibited. If you have received this
electronic mail transmission in error, please delete it from your system
without copying or disseminating, and notify the sender by Reply email, so
that our address record can be corrected.

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





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