E9: How do you handle consignment material?

Yahoo Archive
1

Our customer has a portal in which they tell us what should be available to them.  There are two plants that can build the products.

 

We take those numbers and insert to EPICOR as Forecast.  That is how we build the products.

 

We created a shared warehouse.  Plant 1 will build to FG WH then xfer the parts to TCONS WH (Shared).  Plant 2 will build to T-FG and xfer to TCONS WH as well.  TCONS WH is used to represent what we “SENT” to the customer.  Note I said SENT and not SHIPPED.

 

So that production can know when to SEND a product out, I created a uDash based off a UD table that represents pseudo shipments.  This UD Table is maintained by the planners based on the forecast the customer gives us from the portal.  It gives them the PN, QTY and Date.   The shippers are able to update certain fields for Tracking and mark off via check box to indicate shipped.  This checkbox hides the line from being seen.

 

The shipper then prints out a fake packing slip that we created based off Part Number, no PS will be printed of the Order is closed.  The PS # is the PLANTID-DATE-mmss.  Then these are sent to the customer and the product is transferred to the shared WH.

 

Once the customer uses the product, our Customer Service Manager uses Customer Shipment Entry to process the usage.  This then will create the invoice for payment.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, September 14, 2015 6:57 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: E9: How do you handle consignment material?

 

 

Hi Miguel,

Did you ever put together a good process in the system for consignment?  I have a plant in Mexico that is on Vantage 6.1, they currently use a dummy company to handle this, but I'd like to make it all visible when they upgrate to 9.05 later this year.  Hoping you found something that works!  All the posts I've read through seem to have a convoluted process.

 

John Sieacki

Dudek & Bock Spring Mfg Co

 

 

2

Can someone describe their process for dealing with consignment material?

 

We send assemblies to our customer for them to put in their shelves.  WHen they use it, we then invoice them.

 

We need to send a packing list to them so that they can receive.

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

510-656-0603  Fax

msantillan@...

 

3

On the packing list – do they need a PO number?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, August 29, 2014 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: How do you handle consignment material?

 

 

Can someone describe their process for dealing with consignment material?

 

We send assemblies to our customer for them to put in their shelves.  WHen they use it, we then invoice them.

 

We need to send a packing list to them so that they can receive.

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

510-656-0603  Fax

msantillan@...

 

4
Hi Miguel,

We have consignment agreement with one customer.  It's not pretty, but here's how we do it.  

We have a consignment warehouse with a single non-nettable bin.  This ensures that we don't count the consignment parts in our inventory.  Parts are transferred to the consignment warehouse through inventory transfer when the customer issues a PO for consignment replenishment.

When the customer uses consigned parts, they send a weekly report to our finance group who sends the parts consumed list on to sales order entry personnel to create a sales order, with the part releases coming from the consignment bin.  The customer PO on the sales order is noted as "consign" & date.

A Customer Shipment is created (by finance AR person) with the header noted in tracking details as "Consignment withdrawals as of 09-01-2014".  A PDF of the pack slip is sent to the customer.  An invoice based on the shipment is created and sent to the customer.

We have a nasty hitch with 3 plants.  The consignment warehouse needs to be under one plant.  Therefore, we sometimes have to do extraneous transfer orders to get all aligned in inventory properly.

HTH a bit.

Nancy
 
5

Thanks, that helps with the flow.  How do you handle the sending of parts to the customer?  Our customer requires some kind of packing slip to receive the material.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, September 2, 2014 7:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: How do you handle consignment material?

 

 

Hi Miguel,

 

We have consignment agreement with one customer.  It's not pretty, but here's how we do it.  

 

We have a consignment warehouse with a single non-nettable bin.  This ensures that we don't count the consignment parts in our inventory.  Parts are transferred to the consignment warehouse through inventory transfer when the customer issues a PO for consignment replenishment.

 

When the customer uses consigned parts, they send a weekly report to our finance group who sends the parts consumed list on to sales order entry personnel to create a sales order, with the part releases coming from the consignment bin.  The customer PO on the sales order is noted as "consign" & date.

 

A Customer Shipment is created (by finance AR person) with the header noted in tracking details as "Consignment withdrawals as of 09-01-2014" .  A PDF of the pack slip is sent to the customer.  An invoice based on the shipment is created and sent to the customer.

 

We have a nasty hitch with 3 plants.  The consignment warehouse needs to be under one plant.  Therefore, we sometimes have to do extraneous transfer orders to get all aligned in inventory properly.

 

HTH a bit.

 

Nancy

 

6
Hi Miguel,

Sorry for the delay in reply, I needed to ask someone.  Our shipping personnel are creating a pack list "off system" to send in the box.  Not elegant, but working good enough for them :)  I imagine that if we ended up with more consignment moves / customers, we'd have to come up with something better.

Nancy
7

Hi Miguel,

Did you ever put together a good process in the system for consignment?  I have a plant in Mexico that is on Vantage 6.1, they currently use a dummy company to handle this, but I'd like to make it all visible when they upgrate to 9.05 later this year.  Hoping you found something that works!  All the posts I've read through seem to have a convoluted process.

 

John Sieacki

Dudek & Bock Spring Mfg Co