Search our Help.

Invoice Enquiry

Follow

Unleashed's Invoice Enquiry allows you to view all Sales Invoices (SI) that have been created in your account in a reportable view. The Invoice Enquiry will not show a per product line breakdown of each Sales Invoice, but will show you the sum revenue per Sales Invoice. The Invoice Enquiry can also include Credit Notes to ensure accurate reporting for both sales and refunds processed for your goods.

Use the Invoice Enquiry to understand BI Sales Revenue

You can use the Invoice Enquiry to further review the Sales Revenue figures displayed in the Dashboard's BI Sales Revenue. To use the Invoice Enquiry to compare it with BI Sales Revenue you must:

  • Select "Invoice Date" in the Transaction Date field's drop down menu.
  • Tick the "Include Credits" check box.
  • Select "Completed" in the Status dropdown menu. 

Once the above filters have been applied, run the Invoice Enquiry. At the bottom of the Invoice Enquiry you'll see the Total Charges and Total Revenue for the given period. The Total Charges value plus the Total Revenue value will equal the Dashboard's BI Sales Revenue.

NOTE: The Dashboard's BI Sales Revenue included "Free Credits" whilst the Invoice Enquiry does not, which may cause a variance. Use the Credit Enquiry to review any Free Credits processed in the same time frame. 

Functional descriptions

To access and use the Invoice Enquiry, from Unleashed's main menu, go to Reporting, Sales and select "Invoice Enquiry". 

Header button descriptions

In the top right corner of the Invoice Enquiry, there are two header buttons available:

  • Export: Use the dropdown menu to export the report in either a PDF, CSV or XSLX format.
  • Run: Use the Run button to generate the report with any selected filters applied.

Footer descriptions

At the bottom of the Invoice Enquiry, there a three totals figures that are calculated based on the Sales Invoices that have populated in the Enquiry. The three total figures are:

  • Average Margin: The total average margin for all Sales Invoices populated, calculated as (Profit/Sales Revenue) x 100.
  • Total Charges: The sum total for all Charges included on the Sales Invoices populated.
  • Total Revenue: The sum of the Sub Total values populated in the Invoice Enquiry.

Filter field descriptions

Use the filter fields available to refine which Sales Invoices the Invoice Enquiry report displays. The filter fields available to the Invoice Enquiry are:

  • Date From: Select a date in the field's calendar.
  • Date To: Select a date in the field's calendar.
  • Transaction Date: Use the dropdown menu to select which type of date the Date From and To filters apply to:
    • Invoice Date
    • Due Date
    • Completed Date
  • Sell Price Tier: Use the drop down menu to filter the Sales Invoices by the Sell Price Tier that's been applied (based on the Customer's sell price tier).
  • Printed: Use the drop down menu to filter Sales Invoices by whether they have been printed (Yes) or not (No).
  • Include Credits: Use checkbox to determine whether Credit Notes (Returned Sales) created for the Sales Invoice should also populate in the report. 
  • Warehouse: Use the drop down menu to filter the Sales Invoices by the Warehouse selected in the Sales Order.
  • Transaction Number: Use the free text field to search and select a Sales Invoice to filter by.
  • Sales Order Number: Use the free text field to search and select a Sales Order to filter Sales Invoices by.
  • Status: Use the drop down menu to filter the Sales Invoices by the selected status:
    • All
    • All (excluding Deleted)
    • Parked
    • Completed
    • Deleted
  • Sales Order Group: Use the drop down menu to filter Sales Invoices by the Sales Order Group allocated in the Sales Order. 
  • Customer Type: Use the drop down menu to filter Sales Invoices by the Customer Type selected in the Customer's record. 
  • Customer Code: Use the free text field to search and select a Customer to filter the Invoice Enquiry by. 
  • Customer Name: Use the free text field to search and select a Customer to filter the Invoice Enquiry by. 
  • Sales Person: Use the drop down menu to filter the Sales Invoices by the Sales person allocated in the Sales Order.

Grid column descriptions

By default, the following columns will populate in the Invoice Enquiry's grid:

  • Transaction No.: Displays the Sales Invoice's transaction number as a quick link, which will redirect you to the SI's page.
  • Sales Order No.: Displays the transaction number of the Sales Order (as a quick link) the Sales Invoice has been generated from. 
  • Invoice Date: Displays the "Invoice Date" selected in the Sales Invoice.
  • Due Date: Displays the "Due Date" selected in the Sales Invoice.
  • Completed Date: Displays the date the Sales Invoice was completed. If the Sales Invoice is not in "Complete" status it will show as blank.
  • Status: Displays the current status of the Sales Invoice.
  • Customer Code: Displays the unique customer code.
  • Customer Name: Displays the name of the Customer for the Sales Invoice.
  • Warehouse Name: Displays the name of the warehouse allocated to the Invoice's Sales Order.
  • Margin: Displays the current total Margin for the Sales Invoice, based on the stock's dispatched or current value.
  • Sub Total: Displays the tax exclusive sub total for the Sales Invoice (does not include Charges).
  • Action: Use the Action Cog available on each row to complete the following:
    • Edit
    • Print (available only for Completed Invoices.)
    • Email (available only for Completed Invoices.)
    • Complete.

Hidden Column descriptions

Using the Hidden Columns button you can choose which columns are shown on the grid and where. To add or remove a column, simply drag and drop the columns you like to and from the Hidden columns box found in the "Show Toolbar" tab.

The following column headers are also available to include on your Invoice Enquiry and can be found in Show Toolbar, Hidden Columns:

  • Charge Sub Total
  • Comments
  • Cost
  • Customer Reference
  • Customer Type
  • Delivery Country
  • Delivery Method
  • Emailed
  • Payment Terms
  • Printed
  • Profit
  • Sales Order Group
  • Sales Person
  • Tax Total
  • Total

Using the custom grids

Depending on what sort of information you require, you can enter the relevant criteria and then click Run at the top on the banner. Using the toolbar above the grid, you can manipulate how the filtered information is displayed in the grid as follows:

  • Group By Column(s): To group by a desired column, simply drag and drop the column header it into the grey tile space above the grid's header row. As soon as you drop it the grid the enquiry page will group all results by the dropped column's values. You can group by as many columns as you like and expand all or collapse all the groups using the plus or minus icons shown on the left of the grid.
  • Customize Columns Shown: Using the Hidden Columns button you can choose what columns are shown on the grid and where. Drag and drop a column across the grid's headers to re-arrange their order and position in the grid. Similarly, adjust a column's size by dragging it's side to the desired width.
  • Sort by column: Click on a column's header to sort the report by that field. Click the header once to sort into descending order and click again to sort into ascending. 
Was this article helpful?
1 out of 2 found this helpful