We need to have Commodity Code Field, which is showing the Commodity Code flowing from the product master, on the Open Purchase Order Lines form so that we can pull the commodity code data into Excel.

• Business impact in short is - it is PRFI legal responsibility to provide commodity code for imported goods for customs declaration. 
• PRFI uses 3PL forwarder who makes customs declaration per imported shipment on behalf of PRFI. 
• Volume related per year roughly 100 forwarding instructions/ including 200-300 Purchase Orders / 35-40 different tariff codes
• Today this Information is provided in manually with some system help, but there are manual steps in process and have commodity code as ID would be a time saving process insuring correct information. 
• So far I have not found a place with user access to get a list of all commodity codes with description from which we could as manual workaround create match with e.g. V-lookup. Is there? 
• Step 1) Go to open purchase lines view
• Step 2) Search and filter Purchase order numbers which belong to shipment lot 
• Step 3) Run lines with needed columns to Excel
• Step 4) Add Commodity Code (now only description available)
• ​Step 5) Add supplementary Unit (also manually added / checked as in report only Item ID and not description where one could see this information)
• Step 6) Add invoice numbers (also manually added / checked as invoices at this phase are not in system yet)
• Step 6) Pivot to get summary report to send to forwarder