Consignment Issues

Yahoo Archive
1
Based on all of my testing as of today. I am more convinced that
consignment inventory is better handle by the two Sales Order method.
Let me Re-Cap the process to clean up my typing from my prior posting.


Step
----
1. SO#1-Ln1 is the build & ship schedule & ship to location for P/n#1 to
phantom customer or Phantom 'ship to' for current cust.

2. PS#1 is for SO#1-Ln1 to ship product Customer for consignment Inventory.
P/n#1 (@zero $, no std cost & no sales revenue)
3. Receive PS#1 into non-netable warehouse P/N#2
4. cust pulls / uses qty
5. PS#2 documents customers pulls has all $'s (selling Price & Std Cost)
associated with it for P/N#2. PS#2 then is turned into Invoice. PS#2 can
be against new Sales order (SO#2-Ln1) or against existing SO with new Line
item (SO#1-Ln#2).


Note : We've started using same Sales Order, & added new line to address
"Phantom" P/N#2.



Regards,


Rick Joslin
V-S Industries
rick.joslin@...
847-520-1800
847-520-0269 fax
2
We currently support consignment inventory at multiple customer
sites. The problem that we are running into is shipping the products
to the customer and only invoicing them when they report back their
usage.

We generate hand packing slips and record the quantities shipped in
an external program. When the customer reports back their usage, we
invoice the appropriate quantity.

This becomes confusing because the orders appear past due and
shipping wants to release product.

I read some of the posts in this group regarding consignment
inventory, but they pertains mainly to vendors not customers.

Any feedback would be appreciated.

Thanks,
3
We also struggled with this. This is what I came up with. What I did
was create a warehouse and bin (non-nettable) for that customer and I
show all the parts they have in that warehouse. When they report usage I
create a sales order for that part only and ship it. Then I invoice
from that pack slip.

This makes it very easy for us to tell what the customers has. I also
use this for my service person who lives in the UK. This way if he
needs to send a customer a part, I am able to create a sales order, ship
it from that warehouse, then invoice it. And I can always run a report
showing what he still has in his inventory.

I am always looking for improvements, so if you can find a different
way, I would love to see it.

fasci wrote:

> We currently support consignment inventory at multiple customer
> sites. The problem that we are running into is shipping the products
> to the customer and only invoicing them when they report back their
> usage.
>
> We generate hand packing slips and record the quantities shipped in
> an external program. When the customer reports back their usage, we
> invoice the appropriate quantity.
>
> This becomes confusing because the orders appear past due and
> shipping wants to release product.
>
> I read some of the posts in this group regarding consignment
> inventory, but they pertains mainly to vendors not customers.
>
> Any feedback would be appreciated.
>
> Thanks,
>
>
> Yahoo! Groups Sponsor
ADVERTISEMENT
[Image]

>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
> )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Dina M. Hieber
Vamco International, Inc.
555 Epsilon Drive
Pittsburgh, PA 15238
(412) 963-7100 - phone
(412) 963-9511 - fax

www.vamcointernational.com



[Non-text portions of this message have been removed]
4
We are in the same bind !! I am currently trying to deal with the loss of
a workable method that we had in 3.0. Now that we are in 5.1, our prior
method, for now does not work. We used to leave the packing slip as "Not
Ready to Invoice" this would allow us to track Consignment Inventory by PS
not invoiced report for the given customers & edit PS and move qty between
PS via editing.

Now in 5.1 I am considering a few options. One is the use of the
MRP module (which we just purchase) to enter in the Customer's ship to
consignment schedule and then use stock transfer to non-netable warehouse to
keep them in inventory. The Sales order would be used to track their usage
(stock pulls). I do not have all of the mechanics worked out yet, since
MRP is new for us.

However, another method that would work, is to use two Sales Orders.
One is for the Customer's ship to consignment schedule, the other is for the
Stock pulls & invoicing. SO#1 would be without selling $ nor the part
number also has not Std Costs. That way any transactions does not
effect GL.
1. SO 1 is the build & ship schedule. (phantom cust to id ship to)
2. PS for SO 1 shipping product to Cust. Inv. (@ zero $)
3. Receive PS1 into non-netable warehouse
4. cust pulls / uses qty
5. Sales Order 2 is to bill has EAU estimate Forecast qty if you will one
line & one release due date way out there
6. PS 2 documents customers pulls Has all $ (selling Price & Std Cost)
associated with it. PS then is turned into Invoice.


Third option is to set Consignment location as vendor. Ship to Vendor.
Cust pulls qty then generate Cust. PS from phantom vendor location.



All three have pluses & minuses. I am trying to work with Epicor to
develop a method using a stock transfer (from MFG to Non-netable warehouse)
& print a packer there. Might be interesting if we can get it to work...


Regards,

Rick Joslin
V-S Industries
rick.joslin@...
847-520-1800
847-520-0269 fax



-----Original Message-----
From: fasci [mailto:fasci@...]
Sent: Tuesday, January 15, 2002 7:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Consignment Issues


We currently support consignment inventory at multiple customer
sites. The problem that we are running into is shipping the products
to the customer and only invoicing them when they report back their
usage.

We generate hand packing slips and record the quantities shipped in
an external program. When the customer reports back their usage, we
invoice the appropriate quantity.

This becomes confusing because the orders appear past due and
shipping wants to release product.

I read some of the posts in this group regarding consignment
inventory, but they pertains mainly to vendors not customers.

Any feedback would be appreciated.

Thanks,



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/