Using the Receiving Import Tool to Receive Paper Rolls

The Receiving Import tool will enable you to upload a large inventory receipt by item, include all the role specifications you need, and tie the products to the contract grade pricing from your linked purchase order.  Another benefit to using this tool is that you won’t need to record every individual roll with its’ expected specifications on the purchase order side, saving you time.  Here’s a guide on how you would use this feature.

Navigate to Inventory >Receiving>Tasks>Import to open the tool. 

You’ll begin by filling in information on the fields to the right.  Enter your Supplier, Received Date, UOM and Receiving Warehouse.  Your ship point will fill in with your Supplier INVOICE address, but you can adjust that as needed.  Make sure to set your Packaging Type to ROLLS, which will adjust the spreadsheet columns to include your standard roll specifications.  Also, link you Purchase Order so you can pull in those contract grades and therefore your contracted pricing per item.

Now we can enter information into the import tool.  Under the ROLL column, you’ll add your Roll Numbers which will be entered as Serial Numbers on your Receiving worksheet. 

Enter your products by double clicking within the fields to reveal a drop down.  Select the correct contract grade from the drop down for the first set of products.  You can drag the box down in the column to account for the number of KLB rolls you’re receiving.  Once you pull that contract grade into the correct amount of fields you can start entering the next contract grade the same way until you’ve added all your products.

Enter your UNITS for each item as 1.  This is because you are entering each item as 1 ROLL.

Enter your remaining roll information in the following columns:

• Weight ST in WEIGHT
• Width in ROLL WD
• Basis Weight in BASIS WT
• Dia” in DIAMETER
• Core “ in CORE SIZE
• Roll Length (LF) in the LINEAR LEN column.

You should be able to copy and paste this data right into the spreadsheet portion of the import tool.

Once you’ve finished entering your data select Import Data.  This will create a new Receiving worksheet that includes all this information.  You should only create one import per inventory receipt because the tool will only generate one Receiving worksheet per import.

Your Product/Grade pricing will map over from your purchase order.  The only thing left to do on your Receiving worksheet is validate that the entered data is accurate, add any additional expenses into the Expenses field, and change the worksheet Status to INVOICED to make these products available in your inventory and generate your barcode labels.