Welcome, Guest. Please Login.
05/07/24 at 06:04:22
News:
Home Help Search Login


Pages: 1
Send Topic Print
GL account on PO is skewed after adding WO (Read 1369 times)
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
GL account on PO is skewed after adding WO
01/20/20 at 15:27:16
 
Anybody else experience this?
 
DBA :  A brand new PO is beting entered. AWO# in the PO line.   Because they are on DBA they cant add a GL account.  When you go into evo you will  not see the GL account that came from the item class because the GL account was perverted by the addition of the WO#.   i.e.  The GL account is no longer what was on the item class but changes to my WIP Inventory account.
 
EVO: A purchase order line has a GL account but not a WorkOrder number.    
We come back later and add a wo# and save the po and then go back into the Purchase Order to find that the GL is perverted (changed to my WIP Inventory account)
For some unknown reason adding a WO# after the fact perverts an existing GL account.    
I have discovered that if you are in EVO, after you add the WO# you can go backwards and "re-go-thru" the GL Account and that somehow keeps the GL account from getting perverted.
 
Any and all ideas appreciated.
Laura
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: GL account on PO is skewed after adding WO
Reply #1 - 01/22/20 at 20:22:54
 
If you are purchasing an item for a work order, the GL Posting needs to go to WIP.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: GL account on PO is skewed after adding WO
Reply #2 - 01/27/20 at 13:14:46
 
So how will the proper GL account eventually get credited?   How and When?
 
Back to top
 
« Last Edit: 01/27/20 at 15:01:09 by Laura Oliver »  

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: GL account on PO is skewed after adding WO
Reply #3 - 01/29/20 at 19:30:15
 
WIP is the proper account for something purchased for a work order.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: GL account on PO is skewed after adding WO
Reply #4 - 02/04/20 at 12:23:21
 
SM-C ... Could I just put the same expense account that I have on line 1 of column 1 in the WIP field?  
 
f i go to SM-C  I have the inventory/asset/expense account field filled in with a real GL account number.   No other fields are filled out in the first column, only the first line of the first column.  Nor do I ever touch the 2nd column of default accounts
 
I receive in a po  (whether it be for supplies or bought for a job).  We don't differentiate  
I expect the GL account from the PO line to go the GL-O.     I want it to be the expense account.  I do not want it to be a WIP account.  We don't use WIP.     Could I just put the same expense acount on line 1 of column 1 in the WIP field?    Maybe there is an extra step that the folks who use WIP do that i do not do that removes the WIP and puts back the expense account before it gets to the GL?
 
Sorry to be such a pain.
Thanks
Laura
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: GL account on PO is skewed after adding WO
Reply #5 - 02/05/20 at 13:23:50
 
Quote from Lynn_Pantic on 09/21/15 at 09:46:36:
The cost goes to WIP when the PO is received. it is not an expense, it is an increase in the WIP Asset value. It becomes part of the Finished Good value in Inventory (again, asset account) when Enter Finished Production is performed and becomes COGS expense when the item is shipped. Purchasing of raw materials, components and outside processing should never be an expense, it is an increase in asset value.

 
Will the purchase of raw material get out of the WIP Account and eventually get back into the COGS expense?  I think it has to, but I don't understand how?   We enter finished production but it doesn't effect our GL.  I think I have that turned off.  
Thanks
Laura
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
prophet
Full Member
***




Posts: 215
Re: GL account on PO is skewed after adding WO
Reply #6 - 02/05/20 at 18:11:58
 
Once you finish production on the WO what you should see is credit to WIP and a Debit to Finished Goods Inventory.
Back to top
 
 
  IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: GL account on PO is skewed after adding WO
Reply #7 - 02/06/20 at 09:58:19
 
Thank you!
Do you think that would still be true if I have AD-A post WO transactions set to No?
 
My AD-A looks like this
 
N    Post COG xactions
Y    Post  PO   xactions
N   Post inventory adjustmens
N   Post   WO xactions
 
Y   Permit use of item GL classes
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
prophet
Full Member
***




Posts: 215
Re: GL account on PO is skewed after adding WO
Reply #8 - 02/06/20 at 10:08:03
 
If you have that setting set to N then no GL transactions to and from WIP will happen.  
 
"Post WO transactions?
 
If this flag is set to Y, then all transactions in and out of WIP will create GL Transactions.  Materials Issued to Work Orders will debit WIP and credit Inventory.  Labor charged to Work Orders will debit WIP and credit the Absorbed Labor and Overhead accounts.  Finished Production will credit WIP and debit inventory and any variance posting will post between WIP and WIP Variance with the debit or credit determined by whether the variance is positive or negative."
Back to top
 
 
  IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: GL account on PO is skewed after adding WO
Reply #9 - 04/27/22 at 12:11:01
 
So if you are not posting WIP to GL then there is no fix.  
 
We do not post WO to the GL so I suppose the best thing for us to do is to keep going backwards when we see the that the WO has corrupted the GL account.  This is not too big of a deal even if save  the line and then have to immediately  go back into the PO line.   Or worse we totally forget to change the  corrupted GL account and then I fix it in GL-P
Thanks
laura
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1
Send Topic Print