Please follow the following steps to export inventory items to an Excel sheet for updates or changes

  • In the menu, go to Inventory Management > Product/Job code management,
  • Click on the printer,
 
 
  
  • Look at the bottom section called Printing of inventory - Select categories,
  • Select categories of items you want to export,
  • Choose the Sort order,
  • Select the items quantities,
  • Click on the printer,
 
 
  
  • On top left of the report window, click on the enveloppe,
 
 
 
 
  • In the Export window, on the Format line, click on the arrow to bring up the list of formats.
  • Make sure to choose MS Excel 97-2000 (Data only),
  • Click OK,
 
 
 
 
  • Choose Custom... and click OK,
 
 
 
 
 
  •  Save the file.