Excess stock BAQ

Yahoo Archive
1

Inventory Management > Reports > Slow Moving Stock

 

You can do Slow Moving and Excess, never done it though

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 23, 2015 8:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Excess stock BAQ

 

 

Thanks for the quick reply Ron. Unfortunately I don't think this forum allows 'pictures' could you email them to me at adrian@... please

2

Has anyone written an 'Excess Stock' BAQ they could share? Or suggest how to create? We need one that considers the last 12 months usage and highlights any stock in excess of that usage?

3
One of the Eagles on our Epicor Implementation team is soaring to great heights as he is developing special BAQ’s, etc. Although he is not an IT person, he is doing extremely well. We are a Make to Order Job Shop with 4 manufacturing facilities, so we wanted to make sure we weren’t purchasing / building excess stock. Our young Eagle wrote a Net Available report which takes into account everything On-Hand + On-order – Demand. Here are the screen shots of the BAQ setups.

[cid:image001.jpg@...6C5F0]

[cid:image005.jpg@...6C5F0]

[cid:image006.jpg@...6C5F0]


[cid:image007.jpg@...6C5F0]

Hope the screen shots come through and you find this helpful. We are still tweaking / enhancing. The EUG forum has been extremely helpful for us as we have just launched Epicor 9.05.702A a few months ago. We look forward to contributing to the EUG forum when we get a solid footing / understanding.

Ron



Ron Brown

Process Manager

Tank Connection

3609 N. 16th St.

Parsons, KS 67357

Office: 620-423-3010 ext. 158

Email: rbrown@...<mailto:rbrown@...>



[http://www.tankconnection.com/sig/tc.png%5d<http://www.tankconnection.com>



[http://www.tankconnection.com/sig/tcli.png%5d <https://www.linkedin.com/company/tank-connection-affiliate-group?trk=nav_account_sub_nav_company_admin> [http://www.tankconnection.com/sig/tcfb.png%5d <http://facebook.com/tankconnection> [http://www.tankconnection.com/sig/tctw.png%5d <http://twitter.com/TankConnection> [http://www.tankconnection.com/sig/tcyt.png%5d <http://youtube.com/user/TankConnection> [http://www.tankconnection.com/sig/tcgp.png%5d <https://plus.google.com/u/0/+TankConnectionParsons/posts>

________________________________

NOTICE: This email and any attachments are considered confidential and intended for the addressee only. If you have received this email in error, please notify the sender as soon as possible and delete this email. If you are not the intended addressee, any dissemination, distribution or copying of this message is strictly prohibited by law.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 23, 2015 9:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Excess stock BAQ



Has anyone written an 'Excess Stock' BAQ they could share? Or suggest how to create? We need one that considers the last 12 months usage and highlights any stock in excess of that usage?



[Non-text portions of this message have been removed]
4
Thanks for the quick reply Ron. Unfortunately I don't think this forum allows 'pictures' could you email them to me at adrian@... please