Welcome, Guest. Please Login.
05/12/25 at 16:33:29
News:
Home Help Search Login


Pages: 1
Send Topic Print
INVENTORY VALUE VS GL (Read 632 times)
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
INVENTORY VALUE VS GL
02/12/10 at 09:09:32
 
I have been noticing something very odd.  When I run inventory value report for today's date and compare it to the GL for today's date they match.  When I do a look backwards say 2/1/10 and compare both for the same date, the two they are extremely different.  I've noticed that before and I just can't figure it out.  How would that correct itself?  I already made sure to post everything.  Is it possible something is not filtering correctly when I look at a past date?  Which information do I trust?  We have a huge amount of inventory so going thru them one is out of the question.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
cdecker
Full Member
***




Posts: 117
Gender: female
Re: INVENTORY VALUE VS GL
Reply #1 - 02/12/10 at 09:32:18
 
We notice the same thing here.  I will be interesed to know what the EVO people say about this and which report they say to trust
Back to top
 
 

Cheri Decker
Awareness Technology, Inc
Evo Version 2015.2; Build 7/2/15 Pervasive 10.12/Win2008/Client-server
43 Full/5 DC Users
GOLD Support
Member Since 2002
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: INVENTORY VALUE VS GL
Reply #2 - 02/12/10 at 11:38:01
 
Do you use average costing?  I have seen differences, although not extreme, because the average cost has changed and although the value report for a past date calculated the number on hand at that date, the cost that is used is the average cost today which may be different.
 
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
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Re: INVENTORY VALUE VS GL
Reply #3 - 02/12/10 at 13:10:28
 
I use average costing.  My differences seem to be extreme lately- last 3-6 months.  But again if I do month end vale at month end, its within reason.  The differnece shows up in raw inventory not finished goods.  
 
When I compare the average costs between say today and 2/1/10.  They are the same which I guess makes sense since they are using today's average cost.  I did not keep a print out of 2/1/10 actually ran on 2/1/10 to compare.
 
Did something change in updates maybe?  Because I know there were many times in the past (say last year) that I did not look at month end inventory at actual month end but later into the next month and didn't have big differences.  There has always been some difference just not hug like now. However I will note that our inventory levels this year have increased a great deal compared to last year.
 
Hmmmmm.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
Pages: 1
Send Topic Print