That's great.
I'm new at this. I have version 8.03. Where exactly do you choose Sales Order type DC or CC. For some reason I don't have that option.
----- Original Message ----
From: warren klug <pirateofthemagothy@...>
To: vantage@yahoogroups.com
Sent: Friday, September 7, 2007 9:00:22 AM
Subject: RE: [Vantage] consignment orders
I received the following information from Vantage suport just the other day:
Summary:
customer consignment inventory setup and processing.
Details:
Customer consignments are becoming a bigger issue every day. Customers want their manufacturers to keep inventory levels high enough to service them. Additionally, quick delivery is an ever-growing need. For high volume distributors, moving the inventory in bulk to the distributor and consigning it there is cheaper and the customer will have the inventory when they need it. Based on requests from the DUAL Sales and Marketing Focus Group, the Sales Order and Inventory modules have been enhanced in the following areas:
� Use the order entry process to create consignment orders using a new consignment order type (�DC� and �CC�) to move inventory to consignees. These two codes of DC and CC stand for debit (Out to consignee) and credit (Return from a consignee) orders and these codes can be entered when creating a new sales order (under sales order type).
� Generate and process shippers to move inventory physically out the door. No invoice is generated as no sale has taken place.
� Allows user to �receive� the shipment into a different inventory that is designated for consignments. This is needed at cycle counting time to verify the inventory. This step occurs automatically during the shipping process. The consignment inventory is bin controlled so that bin locations can be used to identify the consignee for whom the inventory is incremented.
� When the consignee sells the inventory, a post-sale order is entered using the consignment inventory code as the Ship From inventory. A shipment is processed from the consignment inventory. Again, bin locations are used to identify the customer for whom the inventory is to be decremented. The the default is a bin equal to the customer number.
This allows running inventory reports which separate out the consignments by customer.
Consignment Inv Flag - If set to Y, this inventory is designated as a consignment inventory. If this flag is set to Y, the Bin Control flag is automatically set to Y, the WIP Inventory flag is set to blank, and the Non-Costed Inventory flag is set to blank.
However, once an inventory has been designated as consignment inventory, it can not be changed back. A new inventory code will have to be created in MMI-U-07.
Unique to Consignment Inventories:
1. Transaction types 4 and 5 will not allow the input of a consignment inventory (I-W or W-I)
2. If the Consignment Inventory flag is set to Y, the WIP Inventory flag is set to blank and the cursor skips this field.
3. If the Consignment Inventory flag is set to Y, the Non-Costed Inventory flag is set to blank and the cursor skips this field.
4. Bin control is mandatory in consignment inventories.
Consignment Inventory Flag - Attribute 11 (Element INV11)
This field designates whether the inventory is a consignment inventory. If the inventory is designated as a consignment inventory, the Bin Control flag is set to Y, the WIP Inventory flag is set to blank, and the Non-Costed Inventory flag is set to blank.
� Enter Y to designate this inventory as a consignment inventory.
� Leave the field blank if this inventory is not a consignment inventory.
No invoices can be generated from shippers for consignment sales orders. This means that any sales order pricing entered on the sales order, and any freight amount entered during Shipment Entry, has no effect on the GL. Also, since it is at invoice time that Cost of Goods Sold and Sales are recognized, there is no effect on COGS or Sales in the GL, as a result of a consignment sales order.
Cautions:
If this flag is set to Y and the nettable flag is set to Y
1. This inventory will be included in the MRP netting process as supply.
2. Consignment sales orders with the ship-to inventory set to this inventory will be seen as demand by MRP.
If this flag is set to Y and the nettable flag is set to N
1. This inventory will not be included in the MRP netting process as supply
2. Consignment sales orders with the ship to inventory set to this inventory will not be seen as demand by MRP
Summary:
IM: how to handle consignment inventory and used/usage invoices
Details:
Page ID 1738MPS
081401
Detailed Summary
------------ --------- --------
How to handle consignment inventory and Invoices from vendors based on "usage" or amounts of this consignment as it is used, or issued to jobs.
Potential Solutions
------------ --------- --------
Inventory from a vendor/supplier they keep inhouse is on consignment, understand that receiving it into nonnettable bins will keep it out of onhand quantities. But how to handle invoicing as they are invoiced by the vendor for what they use (by usage) with several invoices rather than one invoice for the whole receipt.
If only a partial invoice is created vs the receipt (For less than the full qty) the receipt is considered invoiced and no longer shows up in Invoice line entry when trying to create future invoices vs this PO Receipt.
Checked with Financial Accounting for possible invoicing solutions.
1. Can set up a full invoice with payment terms for regular intervals if the usage can be predicted. This will be reflected in the aging report.
2. Each time they receive an invoice, they could delete an existing related invoice and just enter a new receipt for only the invoiced (used) quantity. Then invoice the receipt.
3. Leave the full invoice in place for the full receipt; then through payment entry under Accounts payable, input partial payments vs this full invoice equal to the future invoices for the usage billings. Use comments/memos to form a link between these invoices and provide documentation for the records/audits.
---- If you are the vendor sending items to a customer WH on consignment where the customer will sell it from there, consider the following for how to handle any necassary bills of lading:
Create a shipment packing slip thru Miscellaneous Shipment Entry (under Shipping/Receiving > General Ops). You can create a Bill of Lading from these shipments, and they do not affect onhand qty for part master parts like regular shipments do. And these misc shipments will not be invoiced thru AR Invoicing > Get Shipments.
"Geary, Stephanie" <sgeary@triumphgroup .com> wrote:
You could just designate multiple warehouses for this. We have a
warehouse for a similar purpose. It is kept at an outside processor
until we need to ship to customer and then they ship to customer then it
is relieved from our inventory when the packing slip is pulled.
____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Ken Taylor
Sent: Friday, September 07, 2007 10:56 AM
To: vantage@yahoogroups .com
Subject: [Vantage] consignment orders
Does anyone know if within Vantage there is such a thing as consignment
order process. We have merchandise sent to customer and kept at their
facility, however, it's still considered ours until a sale is reported
at which point it's then depleted from Inventory. I'm sure modifications
to the software are needed, but some feedback will be appreciated.
Thanks.
Ken
____________ _________ _________ _________ _________ _________ _
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.
http://sims. yahoo.com/ <http://sims. yahoo.com/>
[Non-text portions of this message have been removed]
This message has been processed via your triumphgroup. com e-mail
address.
[Non-text portions of this message have been removed]
------------ --------- --------- ---
Need a vacation? Get great deals to amazing places on Yahoo! Travel.
[Non-text portions of this message have been removed]
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
[Non-text portions of this message have been removed]
I'm new at this. I have version 8.03. Where exactly do you choose Sales Order type DC or CC. For some reason I don't have that option.
----- Original Message ----
From: warren klug <pirateofthemagothy@...>
To: vantage@yahoogroups.com
Sent: Friday, September 7, 2007 9:00:22 AM
Subject: RE: [Vantage] consignment orders
I received the following information from Vantage suport just the other day:
Summary:
customer consignment inventory setup and processing.
Details:
Customer consignments are becoming a bigger issue every day. Customers want their manufacturers to keep inventory levels high enough to service them. Additionally, quick delivery is an ever-growing need. For high volume distributors, moving the inventory in bulk to the distributor and consigning it there is cheaper and the customer will have the inventory when they need it. Based on requests from the DUAL Sales and Marketing Focus Group, the Sales Order and Inventory modules have been enhanced in the following areas:
� Use the order entry process to create consignment orders using a new consignment order type (�DC� and �CC�) to move inventory to consignees. These two codes of DC and CC stand for debit (Out to consignee) and credit (Return from a consignee) orders and these codes can be entered when creating a new sales order (under sales order type).
� Generate and process shippers to move inventory physically out the door. No invoice is generated as no sale has taken place.
� Allows user to �receive� the shipment into a different inventory that is designated for consignments. This is needed at cycle counting time to verify the inventory. This step occurs automatically during the shipping process. The consignment inventory is bin controlled so that bin locations can be used to identify the consignee for whom the inventory is incremented.
� When the consignee sells the inventory, a post-sale order is entered using the consignment inventory code as the Ship From inventory. A shipment is processed from the consignment inventory. Again, bin locations are used to identify the customer for whom the inventory is to be decremented. The the default is a bin equal to the customer number.
This allows running inventory reports which separate out the consignments by customer.
Consignment Inv Flag - If set to Y, this inventory is designated as a consignment inventory. If this flag is set to Y, the Bin Control flag is automatically set to Y, the WIP Inventory flag is set to blank, and the Non-Costed Inventory flag is set to blank.
However, once an inventory has been designated as consignment inventory, it can not be changed back. A new inventory code will have to be created in MMI-U-07.
Unique to Consignment Inventories:
1. Transaction types 4 and 5 will not allow the input of a consignment inventory (I-W or W-I)
2. If the Consignment Inventory flag is set to Y, the WIP Inventory flag is set to blank and the cursor skips this field.
3. If the Consignment Inventory flag is set to Y, the Non-Costed Inventory flag is set to blank and the cursor skips this field.
4. Bin control is mandatory in consignment inventories.
Consignment Inventory Flag - Attribute 11 (Element INV11)
This field designates whether the inventory is a consignment inventory. If the inventory is designated as a consignment inventory, the Bin Control flag is set to Y, the WIP Inventory flag is set to blank, and the Non-Costed Inventory flag is set to blank.
� Enter Y to designate this inventory as a consignment inventory.
� Leave the field blank if this inventory is not a consignment inventory.
No invoices can be generated from shippers for consignment sales orders. This means that any sales order pricing entered on the sales order, and any freight amount entered during Shipment Entry, has no effect on the GL. Also, since it is at invoice time that Cost of Goods Sold and Sales are recognized, there is no effect on COGS or Sales in the GL, as a result of a consignment sales order.
Cautions:
If this flag is set to Y and the nettable flag is set to Y
1. This inventory will be included in the MRP netting process as supply.
2. Consignment sales orders with the ship-to inventory set to this inventory will be seen as demand by MRP.
If this flag is set to Y and the nettable flag is set to N
1. This inventory will not be included in the MRP netting process as supply
2. Consignment sales orders with the ship to inventory set to this inventory will not be seen as demand by MRP
Summary:
IM: how to handle consignment inventory and used/usage invoices
Details:
Page ID 1738MPS
081401
Detailed Summary
------------ --------- --------
How to handle consignment inventory and Invoices from vendors based on "usage" or amounts of this consignment as it is used, or issued to jobs.
Potential Solutions
------------ --------- --------
Inventory from a vendor/supplier they keep inhouse is on consignment, understand that receiving it into nonnettable bins will keep it out of onhand quantities. But how to handle invoicing as they are invoiced by the vendor for what they use (by usage) with several invoices rather than one invoice for the whole receipt.
If only a partial invoice is created vs the receipt (For less than the full qty) the receipt is considered invoiced and no longer shows up in Invoice line entry when trying to create future invoices vs this PO Receipt.
Checked with Financial Accounting for possible invoicing solutions.
1. Can set up a full invoice with payment terms for regular intervals if the usage can be predicted. This will be reflected in the aging report.
2. Each time they receive an invoice, they could delete an existing related invoice and just enter a new receipt for only the invoiced (used) quantity. Then invoice the receipt.
3. Leave the full invoice in place for the full receipt; then through payment entry under Accounts payable, input partial payments vs this full invoice equal to the future invoices for the usage billings. Use comments/memos to form a link between these invoices and provide documentation for the records/audits.
---- If you are the vendor sending items to a customer WH on consignment where the customer will sell it from there, consider the following for how to handle any necassary bills of lading:
Create a shipment packing slip thru Miscellaneous Shipment Entry (under Shipping/Receiving > General Ops). You can create a Bill of Lading from these shipments, and they do not affect onhand qty for part master parts like regular shipments do. And these misc shipments will not be invoiced thru AR Invoicing > Get Shipments.
"Geary, Stephanie" <sgeary@triumphgroup .com> wrote:
You could just designate multiple warehouses for this. We have a
warehouse for a similar purpose. It is kept at an outside processor
until we need to ship to customer and then they ship to customer then it
is relieved from our inventory when the packing slip is pulled.
____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Ken Taylor
Sent: Friday, September 07, 2007 10:56 AM
To: vantage@yahoogroups .com
Subject: [Vantage] consignment orders
Does anyone know if within Vantage there is such a thing as consignment
order process. We have merchandise sent to customer and kept at their
facility, however, it's still considered ours until a sale is reported
at which point it's then depleted from Inventory. I'm sure modifications
to the software are needed, but some feedback will be appreciated.
Thanks.
Ken
____________ _________ _________ _________ _________ _________ _
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.
http://sims. yahoo.com/ <http://sims. yahoo.com/>
[Non-text portions of this message have been removed]
This message has been processed via your triumphgroup. com e-mail
address.
[Non-text portions of this message have been removed]
------------ --------- --------- ---
Need a vacation? Get great deals to amazing places on Yahoo! Travel.
[Non-text portions of this message have been removed]
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
[Non-text portions of this message have been removed]