Capturing COS/WIP and being out of balance

Yahoo Archive
1

Thanks for your responses….we will check those out.  I’ll let you know what happened as soon as we get a resolution.

 

The only thing I like about this (if there ever was a reason to like something so bad!) is it is delaying physical inventory.

 

Manasa

 

 

 

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Cathy
Sent: Monday, January 06, 2014 8:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Capturing COS/WIP and being out of balance

 

 

We had a problem where one of the GL accounts was inactive.  It printed on the WIP/Inventory Reconciliation report.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jlisser@...
Sent: Monday, January 06, 2014 7:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Capturing COS/WIP and being out of balance

 

 

We had a few issues in 60x releases (can't remember if it was 604 or 607).  A few things to check are:

1. sales kits and stage ship confirm.  We had to get a one-off, think it was doing something with the components to double them up even though we were using parent pricing. 

2. drop shipments, believe we needed a one-off for that too

3. AP debit memo in the same batch as AP invoices, but I believe that wouldn't have hit COS. 

 

Good luck!  It was rough going those first couple weeks out of balance for sure!

Jenn

2

We are on 9.05.607B

 

We ran our capture and for some reason our COS and Acct receivable account are out of balance by $49K.

 

We saw that we had some transactions in our review journal.  We did what we had to and it “looked” like everything was taken care of but it comes back like it was never reviewed.

 

Anyone ever had this issue?  If so, what did you do to fix it?

 

Manasa

 

 

 

 

 

 

 

 

3

My Controller sent this excerpt to better explain….

 

We are having a problem with the COS/WIP Capture process. We have been on Epicor 9.05.607B for over a year. We successfully captured up to 12/16. The Inventory/WIP Reconciliation Report for the 12/17 does not balance. It is off by 49K, which is off by the debit to the COGS accounts. We know it is not the posting rules, as it worked for the previous day and we have verified them. We also ran our posting rules. Our IT department ran a re-indexing of the files. We also looked for corrupted records and found none. We did try to just go ahead and run the COS/WIP Capture, thinking perhaps it was just a report error. (We did this in copy of the live database) Unfortunately the entry just went into the Review Journal. It is there with a green checkmark like there are no errors, but when the lines are exported to excel, there is a variance between the debits and the credits.

 

Any help anyone can send our way is greatly appreciated!

 

 

Manasa

 

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Manasa Reddy
Sent: Saturday, January 04, 2014 8:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Capturing COS/WIP and being out of balance

 

 

We are on 9.05.607B

 

We ran our capture and for some reason our COS and Acct receivable account are out of balance by $49K.

 

We saw that we had some transactions in our review journal.  We did what we had to and it “looked” like everything was taken care of but it comes back like it was never reviewed.

 

Anyone ever had this issue?  If so, what did you do to fix it?

 

Manasa

 

 

 

 

 

 

 

 

4
Sometimes this happens because there is a part class / product group (most likely prod group in this case as it is COGS) without a GL Control / GL Account associated with it. Was there a new part sold this time? In this case, as there is no GL Control, the system would not know which account to post the transaction to, which would result in not balancing. Perhaps you could show us the Review Journal error detail to help us clarify it for you.
5

Our consultant is finally helping us.  But just to answer your question, all part classes and product groups are accounted for….it is just very weird.

 

But thanks for trying!

 

MAnasa

 

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of rubensjunqueiramaia@...
Sent: Sunday, January 05, 2014 12:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Capturing COS/WIP and being out of balance

 

 

Sometimes this happens because there is a part class / product group (most likely prod group in this case as it is COGS) without a GL Control / GL Account associated with it. Was there a new part sold this time? In this case, as there is no GL Control, the system would not know which account to post the transaction to, which would result in not balancing. Perhaps you could show us the Review Journal error detail to help us clarify it for you.

6

Hi


We had a similar issue in Epicor and all related costs for Purchase Stock Parts without classes went to Balance Sheet in suspense account.

7

Did you try to run Inventory/WIP Reconciliation Report for transaction type PUR-UKN for that period?

If they don't balance then isolate missing receipts and re-open PO, find release and populate GL code in 'GL Information section' if missing, then close PO and delete Review Journal and re-capture COS.


Regards

Marcin

8

We had a few issues in 60x releases (can't remember if it was 604 or 607).  A few things to check are:

1. sales kits and stage ship confirm.  We had to get a one-off, think it was doing something with the components to double them up even though we were using parent pricing. 

2. drop shipments, believe we needed a one-off for that too

3. AP debit memo in the same batch as AP invoices, but I believe that wouldn't have hit COS. 

 

Good luck!  It was rough going those first couple weeks out of balance for sure!

Jenn

9

We had a problem where one of the GL accounts was inactive. It printed on the WIP/Inventory Reconciliation report.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jlisser@...
Sent: Monday, January 06, 2014 7:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Capturing COS/WIP and being out of balance

 

 

We had a few issues in 60x releases (can't remember if it was 604 or 607).  A few things to check are:

1. sales kits and stage ship confirm.  We had to get a one-off, think it was doing something with the components to double them up even though we were using parent pricing. 

2. drop shipments, believe we needed a one-off for that too

3. AP debit memo in the same batch as AP invoices, but I believe that wouldn't have hit COS. 

 

Good luck!  It was rough going those first couple weeks out of balance for sure!

Jenn