RE: Automating Purchase Between Companies

If you have controlled warehouses, you can you use locations instead of the
user field in item balance to designate ownership of inventory.  When we
"ship" using offline shipping, we receive into the same location, just
different warehouse#.  But you could just ship to a different location (just
a different suffix? kept in a cross reference table) in the same warehouse
based on customer# .  We can really get creative with this.

We are one company but have 4 groups, each has its own warehouse and on
hand, etc.  In COM, the groups have their own companies that these orders
are created under.  The external customer orders that drive all of this are
in company 01.  We set the customer master to not create an invoice.  COM
creates all the same records in the DD, DH files, etc. just does not send
any data to IFM.  (We are not going to "pay" each other)  Just a way to
schedule and meet due dates, and take ownership of the inventory (if you
want safety stock, you get to keep it in your groups' warehouse)etc.  We
also have a trigger on IVNTXN that puts a reason code on the record that
accounting has a rule for so receipts never get sent to IFM either.

Ann

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
Behalf Of Ritsema, Doug B Sent: Friday, October 08, 2004 11:22 AM
To: 'MAPICS ERP System Discussion'
Subject: RE: Automating Purchase Between Companies

We are also running two companies in one environments (actually 4 but two
are only using GL).

If you are purchasing product from the other company, how are you defining
the ownership of the inventory?  As far as I know there is no company flag
in item master or item balance.  We ended up using a user field in item
balance, just wondering what others have done.

Doug

-----Original Message-----
From: Ann Neal
Sent: Friday, October 08, 2004 10:50 AM
To: MAPICS ERP System Discussion
Subject: RE: Automating Purchase Between Companies

Marc,

We put a trigger on POITEM that calls a program that loads all the data into
the COM offline load (we only put one item per PO on intergroup orders),
then calls offline load to update.  We created one table that
crossreferences vendor# to Customer/company#/warehouse for use in the
program.  We also automated the shipping of these orders with a user exit
during stock pick and the MAPICS offline shipping program.  After offline
shipping we populate the TRDATA file and do the RPs (or check if it is an
Inspect On Receipt item and do the appropriate trans) during the job stream.
We looked at ISL, but there is still much key entry for manifests, etc. and
the setup and upkeep of the ISL files.  (beside the $$ to purchase).

Alternately we use the same base program at night (to do the same process
but in batch (so orders with multiple lines all go to 1 COM order) since we
run SCM (Thruput) at night.

Ann
LeTourneau, Inc.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
On Behalf Of Marc.Rohde@xxxxxxxxxxxxxxxxx
Sent: Thursday, October 07, 2004 9:55 PM
To: MAPICS ERP System Discussion
Subject: Automating Purchase Between Companies

   We are running Mapics 5.5 with two companies in one environment, =n fact
   we are migrating the second in at this time.  The two sister c=mpanies
   purchase product from each other by cutting PO's and having a cust=mer
   service person enter the order into each company.
    </DI=>
   To ensure proper accountability for the orders we would like to cont=nue
   having the POs and COs between companies.  The question is, is th=re any
   way to automate the transfer of POs to each company short of EDI?<B=>
   Marc Rohde
   IT Manager
   Pentair Water Treatment\Plymouth P=oducts, Inc. & Everpure