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


Pages: 1
Send Topic Print
Incorrect costs backed out to workorde (Read 600 times)
pcorey
Browser
*


I love YaBB 1G -
SP1!

Posts: 4
Incorrect costs backed out to workorde
10/20/04 at 09:16:38
 
Hi,
 
We are using FIFO inventory costing,  we issued a part to
a work order at a cost of $61.91.  The part was also
received into inventory on the same day and previously was  
out of stock.  The part had to be backed out of the work
order so we did a negative material issue in WO-G.
 
It backed out the part quantity but not the cost.  To correct
the problem we went into WO-G and backed out the transaction using the DSP Material transaction. This backed
out the cost, however, the average cost went from $61.91
to $30.95.    WO-G does not allow you to get to the cost
line, is there a setting in the system menu that allows
the user to edit the cost in WO-G?
 
Thanks.
 
Pat
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Incorrect costs backed out to workorde
Reply #1 - 10/20/04 at 10:31:35
 
No there isn't. The problem occured because you did a negative quantity issue rather than just backing out the issue the 1st time. DBA then averaged the cost for the transactions for the second time (61.91/2=30.955).
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: Incorrect costs backed out to workorde
Reply #2 - 10/21/04 at 13:32:52
 
Sometimes you can't back out the first issue-for instance when it is in another accounting period, or when only a partial is being returned to stock.  I suppose one could get around this by changing the value of the part in inventory.  But it seems like the system should handle the negative quantity more appropriately.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Incorrect costs backed out to workorde
Reply #3 - 10/21/04 at 13:47:48
 
Karen,
 
DBA should do all kinds of things more appropriately.....doesn't mean it does....Smiley
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Incorrect costs backed out to workorde
Reply #4 - 10/22/04 at 04:56:55
 
One may back out a transaction from a prior accounting period in the Work Order module, as long as one edits the general ledger posting date to the current accounting period by using GL-P.
 
One can also change the average cost in IN-K when DBA determines an inaccurate amount (such as in this case of creating a negative work order issue).  After you enter the proper average cost in IN-K, you must also run System Manager UT-K-G to recalculate book value for the part number.  This sets DBA back on the straight and narrow path.  You may also want to check the LIFO/FIFO buckets in IN-L-H to ensure the proper costs are reflected here as well.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Incorrect costs backed out to workorde
Reply #5 - 10/22/04 at 07:43:00
 
As lmk points out, it is really easy.... Roll Eyes
The 10-step process for doing things in DBA....LOL! Grin
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Pages: 1
Send Topic Print