Welcome, Guest. Please Login.
05/05/24 at 16:04:36
News:
Home Help Search Login


Pages: 1
Send Topic Print
Report: Allocations exceeding Quant. Avail.? (Read 919 times)
John Bierrie
Browser
*




Posts: 41
Report: Allocations exceeding Quant. Avail.?
01/15/04 at 10:56:21
 
Ok...  I know I have seen this someplace, or done it (in the past) some way, but my memory is not working today.
 
Can I, and then how can I, get a report, list, what-have-you, out of the system which will tell me ALL the material that I have allocated with orders, that exceed what I have available (QOH + On Purchase Order, etc.)??
 
I know it will "*" those items on a BOM list per finished part, but we want to be able to pull up, daily, a list of all raw material that needs to be ordered, based on finished product orders...etc..........
 
Thanks
 
Back to top
 
 

John H. Bierrie
W.I.C.C. Ltd.
Email WWW   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: Report: Allocations exceeding Quant. Avail.?
Reply #1 - 01/15/04 at 11:03:47
 
USe the MRP  MR-F
 
print the order action MR-H report for action types M and B to eliminate all the delay expidite messages
 
you have a nice make / buy report
 
run just B for Buy
 
JW
Back to top
 
 
WWW   IP Logged
John Bierrie
Browser
*




Posts: 41
Re: Report: Allocations exceeding Quant. Avail.?
Reply #2 - 01/15/04 at 11:29:54
 
Any time DBA comes back and tells me "this is going to take several hours to run and will take up system resources", or something to that effect, I do not think I want to say "yes" to it...Smiley
 
We are looking at the MR-H, as we speak.
 
Thanks...
Back to top
 
 

John H. Bierrie
W.I.C.C. Ltd.
Email WWW   IP Logged
John Bierrie
Browser
*




Posts: 41
Re: Report: Allocations exceeding Quant. Avail.?
Reply #3 - 01/15/04 at 11:33:39
 
Follow up...
 
MR-H
 
Example:
 
6388 on hand
1367 Allocated
5021 Available
 
Reorder Lvl: 500
Min. Ord. Qty: 1000
Std Pack: 1000
 
The MR-H report tells us we need to order 1000 parts???  Am I missing something??
Back to top
 
 

John H. Bierrie
W.I.C.C. Ltd.
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Report: Allocations exceeding Quant. Avail.?
Reply #4 - 01/15/04 at 11:46:28
 
You need to re-run MR-F to get accurate data.  You might also want to look at IN-D
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: Report: Allocations exceeding Quant. Avail.?
Reply #5 - 01/15/04 at 13:18:48
 
I run the mrp  MR-F many times a day when we are busy
 
Don't worry about the time. it wont take that long unless you have a really slow computer.
 
IN-D is OK but wont let you see dependent items
 
MRP will look ahead and dig deep to find everything you will need for multi level boms.
 
Dont be afraid of it. Its DBA's best feature. It catches lots of  the mistakes made day to day.  like not issueing a w/o for a sales order.  Or not issueing w/o for low level items that dont show up under IN-D.
 
JW
Back to top
 
 
WWW   IP Logged
Pages: 1
Send Topic Print