Welcome, Guest. Please Login.
05/11/25 at 13:59:09
News:
Home Help Search Login


Pages: 1
Send Topic Print
view archived inventory (Read 1078 times)
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
view archived inventory
12/11/14 at 07:53:30
 
I looked through the documentation and didn't find, or maybe overlooked, what I was looking for.  How do you view Archived Inventory Transactions?
 
Thanks
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: view archived inventory
Reply #1 - 12/11/14 at 09:07:52
 
In reality Evo does not archive inventory transactions. It "Consolidate Inv Transactions".
So the transactions, as I understand, are remove and "consolidated" in one single transaction.
 
If you run IN-E  they will appear there as a total.
 
Quote:

SM-J-D  Consolidate Inventory Transactions

Purpose of Program

Use this program to selectively purge and consolidate transactions from the inventory transaction file to reduce the overall file size.  All inventory transactions of any type that occur throughout the system are captured in the inventory transaction file.  From this file are derived reports on usage, month end costing, lot control, and serial control.

Note:  The program will automatically exclude parts with Lot or Serial Control from the transactions consolidated to prevent the deletion of Lot and Serial Control History.


 
 embarrassed
 
Kelloggs
 
Back to top
 
 

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


I Love YaBB 2!

Posts: 107
Re: view archived inventory
Reply #2 - 12/11/14 at 09:24:21
 
Hum, I was hopiing there was a way to see it on the screen.  Oh well.  Thanks.
 
I was able to write a query using table INVATXN and it did pull in the old data that had been consolidated.
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: view archived inventory
Reply #3 - 12/11/14 at 09:38:08
 
There are several tables that have the inventory transaction.
One of them is the GL, if I am not mistaken.
That is not consolidate, unless you guys consolidated your GL as well.
 
If we are talking about material issue that can be query as well (It is on the work order tables)
 
Smiley
 
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: view archived inventory
Reply #4 - 12/11/14 at 14:00:20
 
Archiving Obsolete parts has an option to also archive the associated transactions.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print