We have about 6 sales whses, but also do not use the DRP module...
We too stock some of our product where we can ship next day, and also started to develop excess inventory when the economy took a turn for the worse. We then quickly adjusted forecasts and min balances [like crazy ~mostly forecast] to get MRP to drive down some of the excess down...
Thx again Al!
Best Regards,
DeeDee Virgei
Project Leader
Nelson Stud Welding, Inc.
-----Original Message-----
From: bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx] On Behalf Of Al
Sent: Friday, August 21, 2009 2:26 PM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Setting up an Inventory Discrepancies Whse
Years ago we had factories in different cities, used facility for each, because MRP does not recognize lead time of one warehouse replenishing needs of another. DRP is great for having orders of one facility needing resupply from another, handling the inventory transfers through purchase orders and customer orders, without the pay yourself accounting. We had to drop DRP, so we can pass security audit, after Infor dropped it from our SSA license.
The distribution facilities started because my employer outsourced some work to Mexico, and other places that have longer lead times, than if we make it ourselves. We passed the savings onto our customers, only doing this when the customers approved both the outsourcing (many of our customers are unionized), and the longer lead times.
Our factory is in a free trade zone. We receive the foreign made parts, inspect them, do repairs when necessary, ship to customers, pay no import export costs.
This means the official costs and official prices are less in the distribution facility, and the lead times are different.
There are customers that need it manufactured the day before they call us to order more. We manufacture and deliver almost yesterday. We have a just-in-time-service ... it really takes a week to manufacture, and 2 months lead time on raw materials, but we can deliver same day from safety stock, then build to replenish. This worked great in old economy and repetitive parts. Now we have an excess inventory problem.
-
Al Mac
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of DeeDee Virgei
Sent: Friday, August 21, 2009 12:58 PM
To: BPCS ERP System
Subject: Re: [BPCS-L] Setting up an Inventory Discrepancies Whse
Thx Al!!
Actually your setup sounds most like ours, i.e., with the distribution facility... We try to keep our frozen cost (the one we use for G/L) the same across both facilities; where we roll it in global and copy it to both facilities (we never roll frozen in any of the facilities)... And I believe we would only be doing transfers and cycle count transactions out of this new whse; I'll verify...
Thanks again Al, your input is always valuable.
Best Regards,
DeeDee Virgei
Project Leader
Nelson Stud Welding, Inc.
-----Original Message-----
From: bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx] On Behalf Of Al
Sent: Friday, August 21, 2009 12:21 PM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Setting up an Inventory Discrepancies Whse
Be careful in how you transfer inventory across facilities.
We have facilities that do manufacturing that have cost buckets for labor, overhead, material content, other stuff.
We have facilities that are distribution only, they receive inventory from outside vendors, non-BPCS divisions of same conglomerate, send that product to our customers, some of this is drop-ship. These items are supposed to have material content cost only.
Sometimes delivery to distribution facility is delayed, so we manufacture enough of that part to meet schedule. If we transfer item from manufacturing facility to distribution facility, where the customer order is located, using "T" transfer transaction, all cost buckets in the "from"
facility get copied to the "to" facility, where the "to" facility did not previously have labor & overhead buckets. This messes up cost in "to"
facility.
Moral: If you have different cost structures for same item#s in different facilities, do not use "T" transaction to get inventory across them.
The reason codes also show up in General Ledger, if you send transactions detail, not summary. We use Journals that are like the transaction codes ... for example "U" receiving to "UP" journal, which tells General Ledger what vendor, item, PO. Same principle "B" shipping to "SH" journal whose data to GL includes customer. We have a modified GL report that adds name of vendor, customer of transactions there.
The auditors love seeing in the GL how much $ we spending on which vendor for what reason, and cash flow by customer.
We could also do reason codes, most of ours are for adjustments, but we already have lists of inventory transactions by type and reason code. In addition to lots of reason codes, we've added transaction effects to make it easier to track returns, samples, inter-company, corrections to physical inventory, other scenarios.
-
Al Mac
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of DeeDee Virgei
Sent: Friday, August 21, 2009 8:49 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Setting up an Inventory Discrepancies Whse
Thx Art!!
This is exactly what I was looking for, i.e., knowing that others have setup such warehouses.
And you bring up a great point about the cost, which I forgot to take into consideration ~someone at my company suggested putting this whse in a new facility, but we would then have to cost that facility. Right now I have two facilities, one that includes all Mfg (MRP) whses and another that includes all other whses. We copy our cost into these facilities nightly...
Having my two facilities setup this way has a similar impact to using the non-netable and non-allocatable flags...
I'm curious if you have more than one facility under BPCS? If you have a quick moment to answer...
The reason codes are also a good point. I don't take advantage of those, like we should...
Thank you again.
Best Regards,
DeeDee Virgei
Project Leader
Nelson Stud Welding, Inc.
-----Original Message-----
From: bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx] On Behalf Of Arthur Shaffer
Sent: Thursday, August 20, 2009 6:23 PM
To: BPCS ERP System
Subject: Re: [BPCS-L] Setting up an Inventory Discrepancies Whse
DeeDee
I have set up an accounting warehouse when I had the issue that the accounting would not allow planning to make inventory adjustments before they would evaluate it and approve it.
I also used the reason code to identify the cause of the adjustment (Cycle Count, missing from shop order pull, found from shop shop pull, etc.) This warehouse was non-netable and non-allocatable but in the same facility as the lost/found inventory warehouse so the cost was not effected.
Art Shaffer, CPIM
----- Original Message ----
From: DeeDee Virgei <DeeDee.Virgei@xxxxxxxxxxxxxx>
To: bpcs-l@xxxxxxxxxxxx
Sent: Thursday, August 20, 2009 1:49:05 PM
Subject: [BPCS-L] Setting up an Inventory Discrepancies Whse
Hi All,
I am looking for some BPCS setting suggestions related to MRP and Inventory...
We currently have a quality whse setup for material returns or other inventory needing further inspection. This whse is in our MRP facility and usually does not contain much.
The issue I run into is that occasionally our folks transfer inventory balances into this whse when finding huge inventory discrepancies during cycle counting; where the questionable inventory may remain in this whse until accounting can further research. This sometimes causes big MRP issues...
I think we should setup a separate warehouse, not under the MRP facility, for huge inventory discrepancies that need further research.
I would only give our accounting folks access to this whse.
My question; have any of you setup a whse like this? I'm trying to find out if setting up an inventory discrepancy whse is normal or am I breaking some big inventory rule...
Any input would be greatly appreciated.
Thx!
Best Regards,
DeeDee Virgei
Project Leader
Nelson Stud Welding, Inc.
--
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email:
BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.
Delivered-To: deedee.virgei@xxxxxxxxxxxxxx
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.
Delivered-To: macwheel99@xxxxxxxxxx
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.
Delivered-To: deedee.virgei@xxxxxxxxxxxxxx
midrange.com
