ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Costing Issue
http://www.istechforum.com/YaBB.pl?num=1151424285

Message started by Kelloggs on 06/27/06 at 08:04:45

Title: Costing Issue
Post by Kelloggs on 06/27/06 at 08:04:45

Some how Evo is not costing some line Items

Here is the Inventory Tran Report: Part N08097-001

Date T Action Quantity Order No Cost Customer/Vendor
-------- - -------- ------------ ------------ ------------ ------------------------------
06/06/06 W WO RECPT 5.00 2328-1 103.4320 MASTER FLO VALVE INC
06/14/06 S SHIPMENT 5.00 835 0.0000 MASTER FLO VALVE INC

Here the Sales Analysis Report: Inv 835
Invoice Item Number Quantity Price Disc% Net Price Extension Cost Extension Gross Margin GM% Cur
835 (06/14/06)
N08097-001 5.00 210.0000 0.00% 210.0000 1050.00 0.0000 0.00 1050.00 0.00%

This was a problem on DBA Classic. The problem continue on EVO.

Am I missing something here?

:(

Kelloggs

Title: Re: Costing Issue
Post by Lynn Pantic on 06/27/06 at 09:15:08

While the transaction dates indicate that the WO Receipt was done prior to the Shipment, use IN-O and look at the audit trail information to check the actual date and time the transactions were physically entered. If the S was done prior to the W (and then the W was backdated) then you would see what you are describing.

Title: Re: Costing Issue
Post by Kelloggs on 06/28/06 at 06:58:41

Here is the IN-O

tem No : N08097-001
Description : POSITIONER YOKE
:

Item No Date T Action Quantity Order No Cost Customer/Vendor Audit Info
--------------------------------------------------------------------------------------------------------- -------------------------
N08097-001 06/06/06 W WO RECPT 5.00 2328- 1 103.4320 MASTER FLO VALVE INC GORD 04:14:51 P06/06/06
N08097-001 06/14/06 S SHIPMENT 5.00 835 0.0000 MASTER FLO VALVE INC DORRIEL 02:52:10 P06/19/06

The shipments was done after the finish production.

Title: Re: Costing Issue
Post by Lynn Pantic on 06/28/06 at 07:21:07

Is it a type N part?

Title: Re: Costing Issue
Post by Kelloggs on 06/28/06 at 07:53:42

Type F

:)

Title: Re: Costing Issue
Post by Lynn Pantic on 06/28/06 at 12:16:51

What is the current UOH? Are you on Average costing or LIFO/FIFO? Any other transactions on the part number in and around the ones you listed?

Title: Re: Costing Issue
Post by Kelloggs on 06/29/06 at 10:31:14

What is the current UOH? = Zero, None, Null, Nada :P

Are you on Average costing or LIFO/FIFO? No idea, where do I find that info?

Any other transactions on the part number in and around the ones you listed?, No other transactions

Regards,

Kelloggs

Title: Re: Costing Issue
Post by cathyh on 06/29/06 at 12:43:38

Average or lifo/fifo is a setting in SD-H Inventory defaults.

Title: Re: Costing Issue
Post by Kelloggs on 06/30/06 at 05:54:05

Average

Regards,

Kelloggs

Title: Re: Costing Issue
Post by lmk223a on 07/06/06 at 10:03:02

Just a thought, but BEFORE posting the shipment invoice in SO-G, call up the prepost cost of good sold report. This report will alert you to any costing issues. Then you can answer NO for posting the invoice in SO-G, exit and fix the costing problem - in this case a forced average cost using IN-K since I am not sure why Average cost is not working properly.

Then call up the prepost COGS report again to verify the forced average cost method worked.