Generation has to run for everything but reports can be filtered for R only

The report filters are the key to getting useful stuff from the mrp.
 
using MR-H with Just B or M selected gives a nice picture of what you should be doing
 
J Dub
 
 

You should have all mfg items cleaned up 1st
 
I run the report to the screen for M types
copy it from the screen to excel
convert data to colums in excel
 
then I copy and paste each item back to dba IN-A
 
do a quick look at the situation for that item
 
make changes I need to make in IN-B Min Level, reorder amount ect if required.
 
rerun the mrp
 
make a mfg run
 
rerun the MRP
 
make sure M types are clean (no requirments)
 
run for B types
get the list into excel
same things clean up items using IN-A to review
IN-B to make changes (check levels, usage, standard packs, ect)
 
rerun the mrp
do a BUY run generating the PO's I need by week
usually  setting due date a week before I need them
 
when theres nothing left on the MR-H (B) report
 
Im Done
NO PAPER
Save your Brain
work from excel    cut and paste
Crtl C and shift Insert
 
j Dub

for me its very efficent
copy the printouts into excel
convert to collums  so the part number is in its own cell  
 
This gives you a nice scratch pad to work from and you dont need to retype part numbers like you would from a paper printout
 
use alt-tab between excel and DBA
use Ctrl C to copy  Shift Ins to Paste
hands dont leave the Keyboard
 
now you can copy and paste from the list back into DBA IN-A and IN-B to see whats up with each item why you need it, how many to make, or buy ect.  as my items parameters have been refined I do much less checking
 
I use the background color tool to mark the ones Ive checked as I go.
 
I make adjustments on items that require it.
 
rerun the mrp
 
when all is well I run workorders
rerun MRP
check items the system wants to buy the same as I check the items it wanted to make
make changes
rerun mrp
do a buy run  
generate PO's I try to schedual po's by due date
so I do po runs in 7-15 day increments and schedual things in a week or 2 before the w/o due date.
 
I save the spreadsheets by date for reference in case I need to review something (never Have needed them though)
 
J Dub

usually if something comes up on my mrp buy or make list I check why in IN-A
and then adjust of fix it in if-b if it needs that.
 
since I have the list in excel I just use cut and paste of the part numbers rather than use a printout on paper.
This saves lots of typing   and paper
 
the issue you have now is that your data is not initialized/complete for the MRP.
 
there are many ways to deal with this to make things happen quickly
 
lead times don’t have to be exact  so set them all to some reasonable setting. 1-2 weeks 4 weeks something like that.  if you have known long lead items then set those appropriately  but most items come in within a month
 
Of course you will need routings   I generated all mine in a spread sheet  and did an import to get started. In our old system we had labor/process info in the bom so I separated it out and use that as the basis for generating my routings.  if I had nothing I would either add them manually  copy and paste from another item or just add a generic routing to get started.
 
You can generate lead times for manufactured items once purchased items are done and you have some routings.
 
Re-order levels
you need to run some reports that can tell you usage rates (like how many you use in a year)  from these you can calculate how many to stock and when to reorder based on the number of inventory turns you want   I use 4-6 turns.
 
6 is replenishing every 2 months  and that seems to work for me.
 
If I use 1200 a year and I want 6 turns that’s 200 at a turn  so I buy 200 at a  time  if the lead time is a week then I set the reorder level to 1 weeks worth of usage 200/8.  So they arrive JIT.  You can also add some margin in there too JIC  (Just in Case)
 
You don’t want to do these 1 at a time though  that why you get all the data into a spreadsheet  or access database calculate the values and then use export import or something like Wintask to automate the data entry into DBA.
 
Sometimes I use access when I have to merge data from different data tables to get all the info I want into 1 table that I can then use wintask to do the data entry from.
 
I have a spreadsheet that I used to calculate stock levels based on usage, turns, ect  I could send it to you if you want to look at it.
 
how many items are you working with ?
 
J Dub
 

Charlene
 
I put it in your e-mail
 
 
J Dub

Quote from shadowcaster   on 11/02/06 at 08:14:03:

 
 
About 2000 here,