ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> CONSOLIDATE INVENTORY TRANSACTIONS
http://www.istechforum.com/YaBB.pl?num=1257950540

Message started by carolg on 11/11/09 at 07:42:20

Title: CONSOLIDATE INVENTORY TRANSACTIONS
Post by carolg on 11/11/09 at 07:42:20

Two years ago I consolidated inventory transactions and it consolidated by year. And it labeled it Consolidate Inv Transactions. I did it again last night for the last couple of years and it is labeled as Monthly Consolidation. I do not want to see 36 monthly entries. I just want one per year. What did I do wrong?

Title: Re: CONSOLIDATE INVENTORY TRANSACTIONS
Post by Vman on 11/11/09 at 09:58:19

I believe that it has always done monthly consolidations (in EVO, at least). I looked at an item in my system, and I have monthly consolidation transactions from 2005.

Title: Re: CONSOLIDATE INVENTORY TRANSACTIONS
Post by carolg on 11/11/09 at 10:18:41

No - I am enclosing a copy of a part. It consolidated all of 2002 but only monthly therafter. Maybe I did it originally in DBA?

Date T Action Quantity UOH Change Order No Cost Customer/Vendor Location
-------- - -------- ------------ ------------ ------------ ------------ ------------------------------ ----------
12/31/02 A ADJUSTMT 248.00 248.00 188.0669 Consolidate Inv Transactions
12/31/02 W WO RECPT 3408.00 3656.00 0-0 17.3546 Consolidate Inv Transactions
12/31/02 S SHIPMENT 2962.00 694.00 0 28.0320 Consolidate Inv Transactions
12/31/02 A ADJUSTMT -414.00 280.00 6.5243 Consolidate Inv Transactions
12/31/02 W WO RECPT -346.00 -66.00 0-0 0.0000 Consolidate Inv Transactions
12/31/02 S SHIPMENT -66.00 0.00 0 26.9016 Consolidate Inv Transactions
01/31/03 W WO RECPT 244.00 244.00 0-0 207.5122 Monthly Consolidation
01/31/03 S SHIPMENT 254.00 -10.00 0 207.5142 Monthly Consolidation
01/31/03 S SHIPMENT -11.00 1.00 0 207.5456 Monthly Consolidation
02/28/03 W WO RECPT 192.00 193.00 0-0 207.1420 Monthly Consolidation
02/28/03 S SHIPMENT 192.00 1.00 0 207.1459 Monthly Consolidation
03/31/03 W WO RECPT 169.00 170.00 0-0 206.7826 Monthly Consolidation

Title: Re: CONSOLIDATE INVENTORY TRANSACTIONS
Post by Vman on 11/11/09 at 10:33:39

Could be, maybe Lynn could chime in on this.