Guide: Managerial Reports
Date Filters on Managerial Reports:
✨Activity Date: the date of the specific activity being searched
📦Date Received: the date that inventory items are checked into inventory
🚚Date Shipped: this is the date the order is marked Shipped.
🙏Desired Delivery Date: the requested or expected ship date
❗Due Date: when the task is due
📨Email Date: the date the email was sent from Allmoxy
↩️Entered Date: this is the date a new announcement is entered into the system.
➡️Movement Date: the date that inventory moved from one location to another
🔔Start Date: the state date of a process
Activity Logs:
The activity report shows you who has been creating, modifying, and deleting records, such as orders, products, supplies, etc. The report shows you when records were changed and by whom, but it cannot specify which properties were changed as that information is not available (unless the property happens to be a subordinate record).
When possible, the report will try to display a sample of information describing the altered record (in its current state) and provide a link to the web page relevant to the altered record.
Email Logs:
The Email report shows you all emails that have been sent from the system, whether that's triggers or any other automations that are emailed from the system, you can look up emails by who the email was sent to as well as the subject of the email.
Announcements:
Announcements shows a list of all announcements that have been made in your instance. You can use the date range to filter your results. You can also sort each column in the report by using the column header arrow icons. You can export the data from this report for use with other software. Just click the “Export as CSV” button at the top.
Current Inventory:
Current Inventory shows you all items that are currently stocked in your inventory. It includes supply information, such as item name, supply location(s), quantity in stock, price per item, and total amount in stock (quantity in stock x price per item = total amount in stock). You can use the supply locations to filter your results. You can export the data from this report for use with other software. Just click the “Export as CSV” button at the top.
Inventory In Use:
The inventory in use report will give you a snapshot of all inventory attached to orders for the selected status.
Inventory Usage:
Inventory Usage lists items in your inventory as well as the quantity you’ve used, average price per item, and total cost per item used (quantity used x average price per item = total cost per item used). You can use the date range to filter your results. You can export the data from this report for use with other software. Just click the “Export as CSV” button at the top.
Order Results Comparison:
Order Results Comparison Report shows you the profit margin from your orders. It lists the order number, cost of supplies, cost of labor, total cost (supplies + labor = total cost), invoice amount, and margin (invoice amount - total cost = margin). This report uses data from labor tracked to each order as well as supplies checked out for each order. You can use the date range to filter your results. The date range filter uses date ordered. You can use the order statuses to filter your results. The order status uses the current status. You can use the tag box to filter your results using order tags. You can also sort each column in the report using the column header arrow icons. You can export the data from this report for use with other software. Just click the "Export as CSV" button at the top.
Projection Report:
The Projection Report allows you to look forward and view orders scheduled in the coming days. It gives you a per-day look at your work schedule. Use this report to plan for extra labor and materials. Print this report off to have a paper schedule for the day or the week.
The report lists the date the order is expected to ship, customer name, delivery method, order number, order date, order status, the last completed process (if you use labor processes!) number of pieces, and order total value. It also lists the total of pieces and dollars at the bottom of each work day.
Use the desired ship date, production line, ship method, order status, export class, and order tags to filter the report results. Click on a row to view extra product data for a single order, or select "Expand Extra Data" to expand data for all orders.
Note that the Printable PDF will contain whichever extra data is displayed. Export the data from this report if needed. Select Export to CSV under Send To in the black sidebar.
Received Supplies:
Received Supplies shows you a list of purchase orders for supplies that you have submitted to vendors and received. It lists the date the purchase order was placed, the date the order was received, the purchase order number, the supply location, the part number, the item name, the quantity ordered, the quantity received, and the price per item. It also lists a total at the bottom of the report in dollars.
Use the date range, supply name, and supply location to filter down the results. Sort each column in the report by using the column header arrow icons. Export the data from this report for use with other software- simply click the "Export as CSV" button under Send To in the black sidebar.
Tasks Report:
Tasks show what tasks are assigned to whom, when they are due, and when the were completed. About indicates which company, contact, or order a task is attached to. You can filter results by Date Range, About (Company, Contact, or Order Name), Completion Status, or Assignee. You can sort the columns in the report using the column header arrow icons. You can export the data from this report for use with other software. Click the "Export as CSV" button under Send To in the black sidebar.
Time Tracking:
Time Tracking lists each order in your inventory and the employee who has tracked hours to that order, including which process they tracked and the amount of hours they were clocked into that process. It also has a grand total at the bottom of the report in hours. You can use the filters on the sidebar to filter your results by order number, employee name, or order status. You must be using the Time Tracking feature to utilize this report. You can sort most columns in the report using the column header arrow icons. You can export the data from this report for use with other software. Just click the “Export as CSV” button at the top.