ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Incorrect costs backed out to workorde
http://www.istechforum.com/YaBB.pl?num=1098292598

Message started by pcorey on 10/20/04 at 09:16:38

Title: Incorrect costs backed out to workorde
Post by pcorey on 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

Title: Re: Incorrect costs backed out to workorde
Post by aricon on 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).

Title: Re: Incorrect costs backed out to workorde
Post by Karen Mason on 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.

Title: Re: Incorrect costs backed out to workorde
Post by aricon on 10/21/04 at 13:47:48

Karen,

DBA should do all kinds of things more appropriately.....doesn't mean it does....:)

Title: Re: Incorrect costs backed out to workorde
Post by lmk223a on 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.

Title: Re: Incorrect costs backed out to workorde
Post by aricon on 10/22/04 at 07:43:00

As lmk points out, it is really easy.... ::)
The 10-step process for doing things in DBA....LOL! ;D