Together with the creation of Cornerstones Staff Lists and integrating them with Smart Flow there are some steps that should be taken to create an Item / Inventory List for synchronization.


First of all, open the Reports menu and click Invoice Item > Invoice Item Setup ReportEither double-click on the report in the list or click Create Report and the next pop-up appears:


From the Sort order drop-down list, select one of the following options: 

Invoice Item Description - sorts items alphabetically by invoice item name. 

Invoice Item ID - sorts items alphabetically by invoice item ID.


Use the following options from the Description drop-down lists to filter your list: 

Item Status - to include only active items and then enter/select the following: 

  - Starting value: Active 

  - Ending value: Active 

  - And/Or: AND 


Type - to include your service type items after what you can enter/select the following: 

  - Starting value: S

  - Ending value: S 

  - And/Or: OR 


Type - to also include your inventory type items and then enter the following: 

  - Starting value: I 

  - Ending value: I 


To check and confirm the information in the report looks correct click Preview, and then, if everything is fine, Save:


Right after that you will need to:


1. Choose the location to save the report. 

2. Name the file using the following convention (to best assist your Smart Flow consultant): CLINIC ID-CLINIC INITIALS-itemlist (for example, 123456-APVH-itemlist). 

3. Select Excel as the file type and finally click Save


NOTE: Sometimes it could be necessary to adjust the Excel file by removing any items not necessary for integration. To do this, apply column filters and sort by the classification column. After that, select and delete item rows that you do not want to export into Smart Flow and save the file with your changes. 

The last thing to do is to send the file to your Smart Flow consultant.