(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-PXRXDV8'); var _ss = _ss || []; _ss.push(['_setDomain', 'https://koi-3QNL6WU154.marketingautomation.services/net']); _ss.push(['_setAccount', 'KOI-47DC8RALVS']); _ss.push(['_trackPageView']); (function() { var ss = document.createElement('script'); ss.type = 'text/javascript'; ss.async = true; ss.src = ('https:' == document.location.protocol ? 'https://' : 'http://') + 'koi-3QNL6WU154.marketingautomation.services/client/ss.js?ver=2.4.0'; var scr = document.getElementsByTagName('script')[0]; scr.parentNode.insertBefore(ss, scr); })(); Skip to main content

Importing Items into Transfers, Purchase Orders, and Invoices

As an alternative to hand-keying a large number of items onto purchase orders, transfers, and invoices, POSIM offers users the ability to directly import spreadsheets containing item information.

To access POSIM’s import tool:

From an invoice, transfer, or purchase order, access the tools menu in the upper-right corner and choose the Import option. This example uses a purchase order, but the same process can be followed for invoices and transfers.

importing to transfers pos and invoices 1

To import a spreadsheet of items with the import tool:

Use the Browse button to select the spreadsheet for import

importing to transfers pos and invoices 2

Map columns by highlighting them in the Source window and selecting the same column in the Destination window. Use the Map button once both are selected.

importing to transfers pos and invoices 3

  1. Highlight the column to be mapped.
  2. Select the Destination column.
  3. Use the Map button to map the column to its destination.
  4. Check the Skip First Line checkbox if the import file has column headers

Once all desired columns have been mapped, use the Import button to import all items onto the purchase order, invoice, or transfer.

importing to transfers pos and invoices 4
Import mapped columns with the Import button

importing to transfers pos and invoices 5
PO with imported values, ready to edit and post.

**Interested in doing more with imports? Check out the Import Manager utility of POSIM here: https://documentation.posim.com/evo#bd9f701c7748e3dd
**Interested in automating your imports? A brief description of how to automate imports can be found here: https://documentation.posim.com/evo#b5c1bb18acf5b692