RE: (no subject)

Michael,

We have been using KBC for about 10 years and I don't believe that
vanilla code will do any sort of inventory availability check. 

One idea to explore would be to:
Flag items such as the 433 as items that had other potential BOM
configurations.  Consider using one of the ITEMAS user fields for this.
Then create a new BOM extension file with all of the optional
parent/component records like:

Parent  component       qtypr   component       qtypr
433             4500XX  10
433             4500AA  6       45000BB 4
433             4500CC  8       4500DD  2
Etc.
You could put multiple components & qtypr in each record or create
separate single-level records and link them together with some sort of
common configuration code that you come up with (1,2,3, etc). Either
way, this extablishes alternate ways in which you can make the 433.

During the BOM explosion in MO release you could just invoke a small
program that would simply interrogate the ITEMAS user field to see if
this guy could have possible substitue configurations. If so, go and hit
your BOM extension file and check availability and create the MODATA
records based on the qty onhand logic you referenced. 

Don't forget to think through the MRP ramifications on this.  If your
planning system is tuned into planning for BOM option 1 and your new
little custom hook always overrides it and creates MOs with BOM option 2
you could hose yourself on the material side.

I love these types of challenges and this sounds like one that is very
solve-able with a minimal amount of code. Good luck.


Dale Walker
Gross-Given Mfg / Automatic Products Intnl.
dwalker@xxxxxxxxxxxxxxxxxxxxx




-----Original Message-----
From: August, Michael [mailto:maugust@xxxxxxxxxxxx] 
Sent: Wednesday, July 16, 2003 3:22 PM
To: 'mapics-l@xxxxxxxxxxxx'
Subject: (no subject)


Say I have Finished Good Part 433       

It's BOM calls for component 
Part 4500XX     10 Qty Per

Or it could use any combination of  
Part 4500AA 6 qty per and 4500BB 4 qty per 
Part 4500CC 8 qty per and 4500DD 2 qty per 
Part 4500AA 4 qty per and 4500DD 6 qty per 
Etc...

Does anyone know of a user exit during MO creation?  We need to check
the Item availability of these combinations and select the one where we
have the most on-hand to be released to the MO.

I thought of using alternate BOM's and have the planner check each combo
but that would be to much work.

Any ideas would KBC help in this situation?

Regards,
Michael August
Sr. Programmer/Analyst
Dialight Corp.






*******************************************************************
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or legally
privileged material.  Any review, retransmission, dissemination or other
use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited.

If you received this in error, please contact the sender and delete the
material from any computer.
*******************************************************************
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.