Welcome, Guest. Please Login.
05/16/25 at 15:24:39
News:
Home Help Search Login


Pages: 1
Send Topic Print
Costing Issue (Read 892 times)
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Costing Issue
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?  
 
 Sad
 
Kelloggs
 
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Costing Issue
Reply #1 - 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.
Back to top
 
 

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


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Costing Issue
Reply #2 - 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.
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Costing Issue
Reply #3 - 06/28/06 at 07:21:07
 
Is it a type N part?
Back to top
 
 

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


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Costing Issue
Reply #4 - 06/28/06 at 07:53:42
 
Type F
 
 Smiley
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Costing Issue
Reply #5 - 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?
Back to top
 
 

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


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Costing Issue
Reply #6 - 06/29/06 at 10:31:14
 
What is the current UOH?  = Zero, None, Null, Nada  Tongue
 
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
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Costing Issue
Reply #7 - 06/29/06 at 12:43:38
 
Average or lifo/fifo is a setting in SD-H Inventory defaults.
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
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Costing Issue
Reply #8 - 06/30/06 at 05:54:05
 
Average
 
Regards,
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Costing Issue
Reply #9 - 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.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Pages: 1
Send Topic Print