Difference between revisions of "Importing order items into Proposals, Service, and Install Orders"

From High5Wiki
Jump to navigation Jump to search
(Created page with "'''How to import lists of items from Excel into the Order Items tab of Proposals, Service Orders, and Install Orders.''' * Excel Import File settings as follows. ** Note that...")
 
 
Line 17: Line 17:
 
** SLACategory
 
** SLACategory
 
* Your Excel spreadsheet should look as follows.
 
* Your Excel spreadsheet should look as follows.
−
[[File:ExcelOrder1.jpg]]
+
[[File:ExcelOrder1.png]]
 
* Right click in the Order Items tab and select ‘Import from File’.
 
* Right click in the Order Items tab and select ‘Import from File’.
−
[[File:ExcelOrder2.jpg]]
+
[[File:ExcelOrder2.png]]
 
* Pick your import file. Excel has two extension types. Select the correct one.
 
* Pick your import file. Excel has two extension types. Select the correct one.
−
[[File:ExcelOrder3.jpg]]
+
[[File:ExcelOrder3.png]]
 
* The data will load as shown.
 
* The data will load as shown.
−
[[File:ExcelOrder4.jpg]]
+
[[File:ExcelOrder4.png]]
 
* Click on the Field Mappings tab and answer No to the Prompt to reset field mappings.
 
* Click on the Field Mappings tab and answer No to the Prompt to reset field mappings.
−
[[File:ExcelOrder5.jpg]]
+
[[File:ExcelOrder5.png]]
 
* Mach on the ItemName as it will associate the item if found in inventory.
 
* Mach on the ItemName as it will associate the item if found in inventory.
−
[[File:ExcelOrder6.jpg]]
+
[[File:ExcelOrder6.png]]
 
* Click Start and the data will load:
 
* Click Start and the data will load:
−
[[File:ExcelOrder7.jpg]]
+
[[File:ExcelOrder7.png]]
 
* Wait until the Import complete prompt.
 
* Wait until the Import complete prompt.
−
[[File:ExcelOrder8.jpg]]
+
[[File:ExcelOrder8.png]]
 
* Click Close:
 
* Click Close:
 
* The data will load.
 
* The data will load.
−
[[File:ExcelOrder9.jpg]]
+
[[File:ExcelOrder9.png]]

Latest revision as of 18:51, 19 February 2020

How to import lists of items from Excel into the Order Items tab of Proposals, Service Orders, and Install Orders.

  • Excel Import File settings as follows.
    • Note that items not in your inventory will be added as item name only since there are fields in inventory that need to be correctly entered for SME to process them correctly.
  • The Excel spreadsheet only needs the following columns as shown below.
  • It is not necessary to have all columns however the columns in bold must be used.
  • Column names matter and should be entered exactly as shown below.
    • Class
    • ItemCost
    • ItemDate
    • Itemgroup
    • ItemName
    • ItemNum
    • ItemPrice
    • ItemQuantity
    • ItemText = item description
    • SLACategory
  • Your Excel spreadsheet should look as follows.

ExcelOrder1.png

  • Right click in the Order Items tab and select ‘Import from File’.

ExcelOrder2.png

  • Pick your import file. Excel has two extension types. Select the correct one.

ExcelOrder3.png

  • The data will load as shown.

ExcelOrder4.png

  • Click on the Field Mappings tab and answer No to the Prompt to reset field mappings.

ExcelOrder5.png

  • Mach on the ItemName as it will associate the item if found in inventory.

ExcelOrder6.png

  • Click Start and the data will load:

ExcelOrder7.png

  • Wait until the Import complete prompt.

ExcelOrder8.png

  • Click Close:
  • The data will load.

ExcelOrder9.png

Retrieved from "https://www.high5software.com//mediawiki/index.php?title=Importing_order_items_into_Proposals,_Service,_and_Install_Orders&oldid=6438"