Welcome, Guest. Please Login.
06/07/25 at 04:10:07
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
Balance Sheet Imbalance (Read 2588 times)
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #15 - 07/02/08 at 14:53:41
 
They both say WIP Variance I sware!  Smiley
 
But you were right!  I changed 50125 to E since the range falls under COGS (Expense) and now the financials are right.  Woohoo!  Thank you so much for your help!  
 
But now I have another separate issue.  Sad  This morning our recieving guy received 25 parts and realized he was supposed to recieve 23 instead.  So he recieved -25 and than 23.  Now the GL-O (posting) is off the $ amount of the 25.  Shouldn't this of washed?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #16 - 07/03/08 at 07:49:21
 
I'm glad your financials are finally balanced!  As for the 11320 account, check your item class codes and see if this is the account used for WIP.  If it is then you just need to change the account name.  If it isn't then I am curious about what is posting to this account.
AS for the PO receipt, are you looking at GL-O by a certain date or all dates? If by a certain date, did he use the same dates for all the receipts?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #17 - 07/03/08 at 08:08:03
 
For the PO thing, I don't even type in a date yet when it tells me it is out of balance.  When you click on GL-O it processes all the batches before it brings you to the screen where you would type in the date you want to post for.  Well it tells me an out of balance error message.  I type Y or N to get into the GL-O screen.  Y allows me to access GL-O without seeing the out of balance and N allows me to see the out of balance.  So I am unable to post until I figure out why it got out of balance.  I know the transaction that caused it but I don't know why.  And, yes he processed all receivings and unreceivings as 07/01/08  
 
Even when I look in AP-C the way he received and unreceived looks correct.
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #18 - 07/03/08 at 11:17:07
 
It sounds like your transaction is correct in The Purchase Order record, have you checked inventory?
 
It is probably just the GL transactions that are wrong-- this happens to us too once in a while when there is some kind of record locking error.
 
You need to click on the "out of balance" report at the bottom of the GL-O screen to see which transactions are out of balance, and then use GL-P to edit the entries.  You can find them by doing a look-up for account and then the date to find the ones that need correcting.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #19 - 07/07/08 at 08:21:58
 
I fixed the transaction through GL-P.  Thank you very much.  You are helping me learn EVO!  
 
Jamie
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #20 - 07/07/08 at 08:29:16
 
Glad to hear you got that fixed, Jamie.  
I get soooo much help from this forum-- it is a pleasure to give some back!    Cheesy
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #21 - 07/07/08 at 14:18:19
 
So, now I am trying to figure out why we have two WIP Variances.  We have an Asset WIP Variance and an Expense WIP Variance.  They are both tied to Work Orders via Sales Orders.  The Expense WIP Variance is strictly when we are closing the Work Orders.  Whereas, the Asset Variance, is closing Work Orders, Receipt from Work Orders, and Material Issues to WIP.  I researched this info through Detailed Trial Balance.  
 
What do you think?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #22 - 07/07/08 at 15:52:35
 
I suspect your Asset WIP "Variance" is not a variance, but the actual materials and labor collected while the work is in process.  As you collect costs, they are debited to this WIP asset and when you finish production they go from the WIP asset to the Finished Goods Assets.  
 
If you close the work order when you finish it, all the costs for that work order are taken out of WIP (credited) and put in (debited) to whichever FG account you are using for that item.  
 
If you leave the work order open and collect more costs after you have finished it, those costs are expensed to the WIP variance  Expense account when you close it.  Or, if you finish production at standard cost instead of actual, the difference is posted here when you close the work order.
 
Double check your class codes for your manufactured parts and see if the account you are calling Asset WIP Variance is used as the WIP account.  If it is, I would rename that account to WIP or Work In Process, and take out the confusing "Variance".
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #23 - 07/08/08 at 08:40:03
 
And how would I check the class codes?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #24 - 07/08/08 at 10:27:30
 
System Manager, SM-C, Enter Item Classes.  Click the <Item Class GL's> button at the bottom of the screen, highlight a class code that is used by a manufactured item, and click <enter>.  The class code GL accounts will be displayed (and can be edited here).  You want to look at WIP Inventory Asset.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #25 - 07/08/08 at 15:31:17
 
Okay, thanks.  Let me see what I can figure out through your instruction and I will get back to you with more questions I am sure.
Back to top
 
 

Jamie
Email   IP Logged
Pages: 1 2 
Send Topic Print