ISTech Support Forum - Inventory Trans. lookup from Inv Iquiry Screen

Welcome, Guest. Please Login.

	11/01/24 at 19:21:58 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Suggestions for Updates

‹ Previous topic | Next topic ›

Pages: 1 2

Inventory Trans. lookup from Inv Iquiry Screen (Read 2606 times)

Mike_Vader Ex Member	Inventory Trans. lookup from Inv Iquiry Screen 09/02/03 at 12:30:54 I would really like to see access to the inventory transactions from the Inquiry screen. Many times it is necessary to review the settings and situation of a particular item and if something looks wrong... to look up the transactions. Mike 8)
Back to top	IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #1 - 09/13/03 at 18:17:44 Sounds reasonable, I will see what I can do.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Bill Lee Browser Posts: 8 Gender:	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #2 - 09/18/03 at 10:26:07 We had this feature in our previous system (BPCS from SSA on an IBM AS/400) and we used it constantly. We really missed it when we converted to DBA. Bill Lee
Back to top	Bill Lee Motor Guard Corporation IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5681

Re: Inventory Trans. lookup from Inv Iquiry Screen
Reply #3 - 10/10/03 at 11:00:01

I am planning to add 2 buttons to the IN-A screen - Usage and Transactions. The transactions button would display transactions of the item, starting with the most recent.

The USAGE button is a bit trickier, I need some feedback. First, I would consider "Usage" to be a transaction that consumed an item - a Shipment, Issue to Work Order or Purchase direct for Work Order. What about Adjustments? Negative only or all?

Second, do we want to display monthly usage? How far back? I have one custoemr who wants 5 numbers - monthly average usage based on last 3 months, last 6 months, last 9 months and last 12 months plus annual total based on last 12 months. Another likes each of the last 12 months listed separately. Any other suggestions?

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

Mike_Vader

Ex Member

Re: Inventory Trans. lookup from Inv Iquiry Screen
Reply #4 - 10/10/03 at 12:17:04

I wouldn't want to include the adjustments at all in the usage. The main reason I would look at usage is to get run rate and to see if a problem exists in the consumption from work orders.

Monthly usage would be extremely useful. If it displayed the last three months usage ie Past 30, Past 60 and Past 90 - that would be very useful.

Coming from the electronics industry - nothing stays the same from 1 quarter to the next monthly trakcing would be the only way for us to build a runrate that s meaningful.

Sounds great - I am very enthusiastic about this solution!!

IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #5 - 10/14/03 at 04:34:57 I would not want adjustments in in Usage either. I think that 3, 6 & 12 months would suit us fine. I'm a little confused about the "annual total based on last 12 months" though. Maybe I'd want it if I knew what it was....
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #6 - 10/14/03 at 06:00:51 The annual total would be the total usage for the year (as opposed to a monthly figure)
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Mike_Vader Ex Member	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #7 - 10/14/03 at 07:53:33 Annual usage would be useful as well. Would that be something that you could synchronize for a starting date or would it be Today-365 days?
Back to top	IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #8 - 10/14/03 at 08:05:14 I plan for the monthly totals to be for completed calendar months up through the month immediately prior to the current one, so the easiest annual number would be the total of 12 calendar months through the end of last month. Unless somebody has a good reason not to use that approach.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Mike_Vader Ex Member	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #9 - 10/14/03 at 09:37:01 That sounds great Lynn. So we would be able to look at each of the last 12 months independently and the aggregate total?
Back to top	IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male

Re: Inventory Trans. lookup from Inv Iquiry Screen
Reply #10 - 10/14/03 at 12:09:51

Lynn,
This would be great! Cheesy

We implemented this same usage info in our old system we maintained the software on.

You would make a couple of people here happier Grin

I agree that adjustments should not be included.

Having said that, What would be the proper way to relieve inventory of an item that is used for something that does not have a work order associated with it. For example, if we needed some components to build a prototype. Currently, we adjust these out on the "White Sheet". I would rather do something else.

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

tcook Member Posts: 71 Gender:	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #11 - 10/22/03 at 04:45:11 Monthly usage going back 1 year would be very helpful for us. This would make alot of people very happy! The adjusments would be good to see, maybe a separate button? Tara Cook APA, Inc.
Back to top	Tara Cook APA, Inc. EVO-ERP2005.1(40 users) w/IS Tech update 12/21/08 Windows 2003 Pervasive V9.0 IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #12 - 10/27/03 at 13:47:34 The 10/31 update will include 2 new buttons on the IN-A screen - one for Transactions and one for Usage.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #13 - 10/27/03 at 17:35:01 And best of luck to all those who download an update on halloween.....
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Inventory Trans. lookup from Inv Iquiry Screen Reply #14 - 10/27/03 at 18:18:28 LOL, Lorne, I will do my best to be sure it is not bewitched.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Pages: 1 2

ISTech Support Forum › Evo-ERP and DBA Classic › Suggestions for Updates

‹ Previous topic | Next topic ›