Receiving Using an Import

Step 1: Create a CSV File

To import data into Receiving you will need a source file. A CSV file is the preferred file type. You can create a CSV by:
  • Creating a spreadsheet in Excel and then saving as a CSV
  • Scanning and uploading data from a Cipher handheld data collector
  • Exporting as a CSV from another platform
It is recommended that the CSV file have only as much data as you need to import, but more fields can be in the CSV, they will just not be imported.
Each line of the CSV file must contain:
  • An Item Number, Barcode, or Vendor Item Number
    • If importing gridded items, use Grid specific barcodes
    • If importing item with alternate units, use Unit specific barcodes
  • A Quantity (unless only receiving 1 of everything)
The CSV can contain:
  • Unit cost
  • Serial numbers (if your Counterpoint license includes the serial number option)
Here is an example of a CSV to be imported into Receiving. The format of each line to be imported is Item number/Barcode, Quantity, Cost.

Step 2: Importing into Receiving

  1. Select Purchasing → Receivings → Receivings Enter
  1. Click Import
  1. Select the Receive without PO option
  1. Enter or look up the Vendor Number
  2. Enter or look up the Location
  3. Select the … for the file name
  4. Locate CSV file and choose open
  5. Click the Advanced tab
  6. For Item, type a 1 (or the field number in the CSV file if not using a format of Item Number/Barcode, Quantity, Cost)
  7. For Quantity, type a 2 (or the field number in the CSV file if not using a format of Item Number/Barcode, Quantity, Cost) or check Assume qty 1
  8. For Cost, type a 3 (or the field number in the CSV file if not using a format of Item Number/Barcode, Quantity, Cost) or check From vendor/item record
  1. Click Verify
  2. If no errors in the results move to step 15
  3. If errors exist, find the items that are shown as errors from that section, add item in Inventory → Items if not on file, or find correct barcode
  4. Select IMPORT
  5. Counterpoint will open a receiver with the lines from the CSV file. You can adjust your cost or add any new items.
  6. Click Post

Recent Posts

There are specific tasks that need to be completed at the end of the fiscal year. Your fiscal year may or may not match your calendar year. Only complete these tasks at the end of your fiscal year.
i3 POS Support has received some calls requesting additional information be displayed on the Ingenico Lane/5000 and iSC250 screen.
Is there anything better than entering a cozy local eatery on a chilly evening? The soft glow of lights and the promise of a festive cocktail can warm you instantly. The holidays are a time to reunite with the family and loved ones you don't see often—and if those reunions can be at an intimate local restaurant, all the better.
SACRAMENTO – The California Restaurant Association (CRA) today praised California Governor Gavin Newsom and members of the legislature for paving the way to offer restaurants a less- bureaucratic way to serve alcohol in expanded outdoor dining settings, allow for carry-out restaurant meals to be sold with alcoholic beverages, and to increase the number of times a catering permit may be used at the same location.

i3 Verticals, LLC is a registered ISO of Wells Fargo Bank, N.A., Concord, CA | i3 Verticals, LLC is a registered ISO of RBS Worldpay | i3 Verticals, LLC is a registered ISO of Deutsche Bank, USA, New York, NY i3 Verticals, LLC is a registered ISO/MSP of Merrick Bank, South Jordan, UT | i3 Verticals, LLC is a registered ISO of Harris NA, Chicago, IL | i3 Verticals, LLC is a registered ISO of Fifth Third Bank, Cincinnati, OH Copyright i3 Verticals, LLC © 2019. All Rights Reserved.