How do I pull a sales report in Beacon?
While there are a number of sales reporting methods in Beacon, the Total Sales Data Export is the most straightforward and complete sales report.
Filters Available:
- Event Date
- Event Last Modified
- Event Status
- PO Date
- Existing Facility Stock Used (Yes/No)
- Distributor Group
- Rep Name
- Manufacturer(s) Assigned
- Catalog #
- Product Names
- Physician Name
- Event Type
- Region
- Facility Name
- Commission Paid
- Event Invoice Number
- Invoice Paid
- Invoice Email Date
The Total Sales Data Export report will provide you with a list of all of your sales in the given range including: Event Id, Event Date, Event Name, Event Type, Event Status, Manufacturer(s) Assigned, Created by Role, Procedure Name, Facility Name, Region, Assigned Distributor Group, Rep Name, Physician Name, MRN/Case ID, Total Items, PO Numbers, PO Date, Total Sales (Calc), Total Commission, Commission Paid Status, Total Cost of Goods, Producct Line, Catalog #, Lot #, Invoice Paid Status, Invoice Email Date(s), Total Additional cost Adjustments, Event Last Modified Date.
To export, Click on the Kabob menu in the upper right corner of the report table titled, "Tile Actions", then select "Download"
Be sure not to click on the kabob menu at the top of the screen by mistake.
Then select the Advanced Settings:
- Results: With Visualization options applied
- Data Values: Unformatted (no rounding, special characters, etc.)
-
Number of Rows to Include: All Results