This seems pretty sensible to me. The fact that the transaction failed is problematic, but I'm not sure how else any inventory system would store this kind of data.
If you want real point-in-time snapshots of your inventory data then you need to invest in or build a data warehouse to store this information. CorVu is an option (V8), or the EPM product (E9), or something you build in MSSQL 2005 if you have the expertise, or something else.
The point here is that Vantage is an ERP system, and as such its primary job is transaction execution. The PartTran-driven history is helpful and important for planning, but it doesn't replace a real data warehouse.
ERP systems try to be all things to all people, but they're not. My $0.02.
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
   Â
bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Friday, October 09, 2009 11:34 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Perpetual Inventory vs. G/L
The way vantage keeps track of inventory is completely crazy. You have an on
hand QTY kept somewhere and then qty on hand before and after each
transaction is calculated by taking the current qty and working backwards in
time. Sorry if this is confusing.
We ran into an issue where a qty on a part was adjusted and in the middle
had a server issue. So the current on hand got changed but the transaction
record was not made. This in turn completely threw off the rest of the
numbers on the transaction log for that part.
~Charlie
_____
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of
Thomas Rose
Sent: Friday, October 09, 2009 11:24 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Perpetual Inventory vs. G/L
I am in the same boat. However, although I do plan to get to the bottom of
this someday, my differences have not yet been so large that I can't just
write-off the difference. One tip - You need to run the inventory reports
that you are balancing to (stock status and work in process) exactly at
month end. Even though you can select dates for these reports, the balances
seem to be unreliable if run at another time. If I run an inventory detail
listing right now for September 30, the details will be different than the
report I ran first thing in the morning on October 1.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The World Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<
http://www.electric <
http://www.electricmirror.com>
mirror.com>
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Kirstin
Sent: Friday, October 09, 2009 8:03 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Perpetual Inventory vs. G/L
How do you balance your perpetual inventory to the G/L at month end? Which
reports/data do you use to do this?
We can get our non-conforming warehouses to balance, but our raw materials
and finished goods warehouses just won't play nice. Any insight would be
appreciated.
Thanks, Kirstin
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links