![Page 1: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/1.jpg)
Activant Prophet 21
Cleaning House with the Dead Stock Feature of Trading Partner Connect
![Page 2: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/2.jpg)
This class is designed for…
Trading Partner Connect users who are responsible for getting rid of dead stock at their companyThose who have completed the “Overview of Trading Partner Connect” WBT or have a basic understanding of TPCx
![Page 3: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/3.jpg)
Overview
This class will show you how the Dead Stock feature of Trading Partner Connect can help you eliminate “dead” or slow-moving stock.
![Page 4: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/4.jpg)
Objectives
Identify your Dead StockUpload Dead Stock to the Trading Partner Connect website, or “Hub”Browse for Dead Stock on www.tpcx.comGenerate the Data Mining Report
![Page 5: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/5.jpg)
This course will NOT cover…
Prophet 21 functionalityInternet functionalitySet-up of Trading Partner Connect
![Page 6: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/6.jpg)
Identifying Your Dead Stock
Dead Stock Identification
Identify Dead or Slow Moving Inventory
![Page 7: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/7.jpg)
Parameter Screen
![Page 8: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/8.jpg)
Parameter Screen
The end range date will default to one year back from the date
you generate the report
![Page 9: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/9.jpg)
Parameter Screen
![Page 10: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/10.jpg)
Parameter Screen
![Page 11: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/11.jpg)
Parameter Screen
![Page 12: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/12.jpg)
Parameter Screen
![Page 13: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/13.jpg)
Example Results
![Page 14: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/14.jpg)
Dead Stock Report
Verify results of reportIntegrity of dataIntegrity of material listed
BrokenUnusableOut of Date
![Page 15: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/15.jpg)
Dead Stock Report
Once you have verified the data you can then UPLOAD the information to Trading Partner Connect
![Page 16: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/16.jpg)
Dead Stock Report
You have TOTAL control over the information uploaded to Trading Partner Connect
![Page 17: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/17.jpg)
tpcx.com
Once dead stock information has been uploaded to Trading Partner Connect, it will be available for other trading partners to “see”…
During Order Processing/Sales Pricing Inquiry Purchasing Integration Trading Partner Connect Web Site/Hub
![Page 18: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/18.jpg)
Order Processing
![Page 19: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/19.jpg)
Sales Pricing Inquiry
![Page 20: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/20.jpg)
P&A
![Page 21: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/21.jpg)
Message
![Page 22: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/22.jpg)
Purchase Order Entry
![Page 23: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/23.jpg)
PO Requirements Generation
![Page 24: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/24.jpg)
PO Requirements Generation
![Page 25: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/25.jpg)
Dead Stock Summary
![Page 26: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/26.jpg)
Purchase Requirements Report
![Page 27: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/27.jpg)
Dead Stock Search on tpcx.com
Locate inventory listed as “dead stock”Search by:
By Keyword on the Item Code and DescriptionUPCTrading PartnersManufacturer LinesManufacturer’s Part Number
“One man’s trash is another man’s treasure!”
![Page 28: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/28.jpg)
Dead Stock Search Results
![Page 29: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/29.jpg)
Dead Stock Search - “NO TP Rel”
![Page 30: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/30.jpg)
Dead Stock Search - “TP Rel”
![Page 31: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/31.jpg)
If you could be provided with a way to generate a report to help
you eliminate your ‘Dead Stock’ –would you use it?
![Page 32: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/32.jpg)
Data Mining Report
Matches all dead stock posted on tpcx.com to the Average Monthly Usage (AMU) of all rationalized itemsThe information matches members that need a particular item to members that do NOT need that itemThis allows you to proactively reduce your dead stock …to a somewhat “captive” audience.
![Page 33: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/33.jpg)
Data Mining Report
Clicking Submit sends your request to TPCx for analysis
![Page 34: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/34.jpg)
Data Mining Report
Report will be delivered in approximately 24 hours to e-mail listed on the parameters screen
![Page 35: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/35.jpg)
Info on Data Mining Report
UPCDescription of Item (both)ManufacturerStock AvailableEstimated Price
Trading Partner NameContact NameContact PhoneContact EmailYour Item Code
![Page 36: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/36.jpg)
Summary
Generate Dead Stock ReportVerify and Upload the ResultsP&A Response ScreenPotential Purchase BrowsePurchase Requirements ReportSearch for Dead Stock on tpcx.comData Mining Report
![Page 37: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/37.jpg)
Responsible Parties
Determine WHO is responsible for DEAD STOCK
![Page 38: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/38.jpg)
Posting Dead Stock
Generate Dead Stock report in Prophet 21
Requirements to post your inventory as dead stock
Item must be rationalizedItem must be priced
![Page 39: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/39.jpg)
Posting Dead Stock
Generate Dead Stock report in Prophet 21
Verify the results
Upload results to the Hub
![Page 40: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/40.jpg)
Posting Dead Stock
How to capture dead itemsPurchase or sales classesLast Sale DateLast Purchase Date
How to price dead items10%-40% below cost
![Page 41: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/41.jpg)
Posting Dead Stock
You should run the Dead Stock report monthly to capture any new dead items
Add the report to your End of Month procedures
![Page 42: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/42.jpg)
Dead Stock Report and Item Rationalization
Run Dead Stock Report with Current Rationalized Status = Unrationalized
Report will be informational only, but will indicate vendor lines that need to be rationalized in order to post dead stock
![Page 43: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/43.jpg)
Data Mining Report
Remember, this report is all about saving money, it shows…
Potential to sell your DEAD STOCKPotential discounted buys of other distributor’s dead stock
So, how do you use this report?
![Page 44: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/44.jpg)
How to sell your dead stock…
Be proactive…Send a list of the items on the report to each trading partnerFollow up with a phone call to work out a deal with each trading partnerThen you can $ell, $ell, $ell
![Page 45: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/45.jpg)
Purchase Requirements Report
Review the items that are needed to purchaseNote the items that you can purchase from a Trading Partner that have the item as DEAD stockThen simply place your PO to the TPCx partner listed on the report for the items you need
![Page 46: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/46.jpg)
Now, let’s back this all up…
Dayton Supply cut a PO to E & R Industrial for some materialNow, that statement doesn’t seem all that exciting…but wait…
![Page 47: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/47.jpg)
Here are some facts about the PO
Cost to Dayton was $4,700Multiple vendor lines purchasedMaterial was DEAD for E&R IndustrialDayton Supply $aved over 25% vs. buying this material from their vendor
![Page 48: Cleaning House with the Dead Stock Feature of Trading ... · Upload results to the Hub. Posting Dead Stock yHow to capture dead items yPurchase or sales classes yLast Sale Date yLast](https://reader035.vdocuments.us/reader035/viewer/2022071005/5fc2dc93037b8b36b45f1128/html5/thumbnails/48.jpg)
Here are some facts about the PO
Dayton knew about this because of the Data Mining Report on tpcx.comMore than 60% of items listed on this one report were purchased on this ONE purchase orderE&R Industrial gained $4,700 to invest …instead of letting it collect dust and cost $$$