Logicbroker offers out of the box reporting for all documents processing through the system. There are 2 types of reporting:
Standard which is used for monitoring documents and providing a drill down view of all of your documents, counts, and Gross Merchandise Value (GMV). Reports and charts can be filtered, moved and resized according to your preferences.
Advanced which provides full business intelligence tools for analyzing your data. This includes vendor compliance reporting, year-over-year (YoY) comparisons, and extending Logicbroker Data with other data sources.
Note:
To learn more about Advanced Reporting, see this article or contact us.
By default, you will be provided a set of charts and reports. This includes an order count bar chart, GMV donut, and a list of common counts for monitoring your data. You can edit the default or create your own new reports and charts. To do that continue below. If you need to restore your default configuration, you can always click the Reset to Default button.
Reports (Tiles)
Report tiles are used to show a count of your documents based on filtered conditions.
To create a new tile click "New Report" and begin by adding a title.
The title will show up on the tile with its corresponding document count.
Then choose a color to easily distinguish the tile and add your filters. Below are a list of available filters:
| Value | Description |
|---|---|
|
Document Type |
Available options include Order, Acknowledgement, Shipment, Invoice and Return. |
|
Status |
This is the status description; all available options can be found here. Typical order statuses include Ready to Acknowledge, Ready to Ship, Ready to Invoice, and Complete. |
|
Status Code |
This is the code associated with the status; all codes can be found here.Typical order status codes 150 (Ready to Acknowledge), 500 (Ready to Ship), 600 (Ready to Invoice). |
|
Sender |
This is the sender Company ID. Your partner's Company ID can be found by navigating to the Suppliers or Retailers page. |
|
Receiver |
This is the receiver's Company ID. Your partner's Company ID can be found by navigating to the Suppliers or Retailers page. |
|
Date |
Date of the document. |
|
Status Change Date |
Date the status was last changed for that document. |
|
System |
System of how the document was received. This includes Portal, Workflow, CustomXML, CSV, External API, EDI, and other system names. For a list of all systems see our Channel and System Integrations section. |
You can add as many filters as you want and all filters conditions use an "AND" condition; therefore the documents in the report will only count if they meet all the conditions setup.
When a tile is added to your reporting dashboard, you can filter, delete, copy, edit or download a CSV/XLSX export of all the documents counted in the report. In addition, if you click the number you will be taken to a filtered page with a list of all the documents. After adding your tiles you can always re-shape move and organize your dashboard to provide a monitoring view that fits your needs.
Charts
Charts allow you to create a view of your order counts, quantity and GMV totals. You can create a Line, Bar, or Pie chart for your data and set a time interval to provide a visual picture of your data.
To create a new chart click "New Chart" and add a title.
Select the chart type (Line, Bar, or Pie) and the value field that you want to visualize. Below is a list of available values:
| Value | Description |
|---|---|
|
New Count |
# of documents that have been received based on the time interval set. |
|
Failure Count |
# of documents that have failed based on the time interval set. |
|
Complete Count |
# of documents completed based on the time interval set. That is documents that have been full shipped and/or invoiced. |
|
Duplicate Count |
# of documents that have been marked as duplicate in the time interval set. |
|
Total Amount |
Aggregated Invoice total $ amount provided on all invoices given the interval set. |
|
Subtotal |
Aggregated (Quantity * Price) for all line items provided on your orders given the interval set. |
|
Total Quantity |
Aggregated Quantity for all orders given the interval set. |
Once your value is added you can add a filter for the following:
| Value | Description |
|---|---|
|
Document Type |
Order, Acknowledgement, Shipment, Invoice, and Return |
|
Sender |
This is the sender Company ID. Your partner's Company ID can be found by navigating to the Suppliers or Retailers page. |
|
Receiver |
This is the receiver's Company ID. Your partner's Company ID can be found by navigating to the Suppliers or Retailers page. |
A Document Type should always be provided. If no sender or receiver filter is added the visual will automatically break out the data per partner. Like tiles, all charts can be edited, deleted, copied, and resized.
Export and Import Configuration
All reports created are saved on the user level; this means the reports you create are not visible across your company's account. However, you can share your reports with your colleagues by exporting your report configuration and having them import it. Use the Export Configuration to save the file and when logged in as a different user, use the Import Configuration to import that same file.
Comments
Please sign in to leave a comment.