Invoice Arrivals Report

Invoice Arrivals Report

The Invoice Arrivals Report gives you a printable list of arrivals information entered into the Invoice Arrivals screen.

Generating the Report

  1. On the top menu bar of Retailer, click on Reports → Stock Reports → Invoice Arrivals Report.
    The Report can also be accessed from the Invoice Arrivals screen using the Utilities button in the top right corner, then click the button next to 'Print an Invoice Arrivals report'
  2. Under Suppliers, choose between showing invoices for all or a selected supplier.
  3. In Date Range, select a Start Date and End Date to show invoices with an Arrival Date in that range.
  4. In Invoices, the options will only be visible if you chose a selected supplier above:
    1. Choose between all or selected invoices from the drop-down box. You can choose multiple invoices using the drop down box and they will appear in the box to the right.
    2. Use the Unselect Invoice button to remove an invoice from this area if necessary.
  5. In Options, the settings available are explained below:
    1. Display items in the order they arrived, else in alphabetical order.
      1. If ticked, will sort the items on the report by the sequence they were arrived.
      2. If unticked, will sort the items on the report in alphabetical order.
    2. View each invoice received
      1. Shows information for individual invoices.
    3. View each stock item received
      1. Shows information for individual stock items.
    4. Show banding on report
      1. Shows coloured bands for every second item.
    5. Show Ex GST cost
      1. Shows all cost prices as ex-GST.
    6. Show Trade Price
      1. Shows the trade price of stock items arrived on invoice.
    7. Show Pending Invoices Only
      1. Only shows invoices on the report that are ticked as Pending in Invoice Arrivals
    8. Show short item description
      1. Shows short descriptions instead of long descriptions.
    9. Show invoice notes
      1. Shows invoice notes for each invoice.
    10. Show paid invoices only
      1. Only show invoices that have been marked as paid.
    11. Show stock locale
      1. Shows locale of stock. See Store Locales. Enabling this option will hide some other details, like the Supplier totals.
    12. Show delayed billed only
      1. Only shows delayed billed invoices.
    13. Show Serial Numbers
      1. Shows Serial Numbers of stock items arrived on each invoice. See Serial Numbers.
    14. Show Individual Freight Charges
      1. Shows Freight Charges added to Cost and/or Sell prices of each item. See Invoice Arrivals Freight.
  6. Click on Preview or Print.
InfoThe report will use the Arrival date (when the invoice was entered) to work out which invoices to include, but the order of the invoices will be shown according to Invoice date.

Reading the Report

The report will show the stock arrived into Retailer over the specified date range, broken down by Supplier, then Invoice, then stock item.

  • Supp. Total / Invoice Total - Total Costs, along with individual costs, will either be Inc- or Ex-GST depending on settings. Inc-GST or Ex-GST is displayed in the heading of the report
  • Supp Ext. Cost - Total cost including freight.
  • Freight Invoice No - If invoice freight was charged to a separate freight invoice / freight supplier, shows the invoice number.
  • Invoice Cost - Total cost including freight.
  • Nett Cost - Cost price of item minus supplier discount (Disc.)
  • Supp GP $ / Invoice GP $ / GP $ - Shows the expected Gross Profit of the stock item / invoice / all invoices of the supplier. [Total Retail (Ex GST) - Total Cost (Ex GST)]
  • Supp GP % / Invoice GP % / GP % - Shows expected Gross Profit percentage of this supplier / invoice / stock item.

    • Totals for all suppliers combined are shown at the bottom of the report.

    Exporting the Report

    You can export the report to either a PDF document or Excel spreadsheet by using the Preview button and following the below steps:
    1. PDF - Click on the red PDF button at the top of the report and choose your save destination.
    2. Excel spreadsheet - Click on the Print button at the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button [...] to choose your save destination. Click OK to save the file.

      • Related Articles

      • Invoice Arrivals

        Correct procedures surrounding stock arrival into Retailer will assist your stock control, ensuring that your stock holding figures are accurate, as well as allowing for stock reordering to occur within the system. It also allows you to keep track of ...

      • Adding Freight and Invoice Arrivals

        We have a video guide on how to add freight to invoices through Invoice Arrivals in Retailer - ? Freight and Invoice Arrivals Freight can be added to invoices arrived through Invoice Arrivals in three ways: A Freight charge is charged by original ...

      • Supplier Sales Analysis Report

        The Supplier Sales Analysis Report is used to list all items sold during a specified date range for selected Suppliers. You can choose multiple Suppliers, therefore allowing you to compare the sales totals by Supplier. You can also choose different ...

      • Sales by Month Report

        This report shows the sales totals for each month in the past year ending with the selected month/date. The report can be grouped three different ways, and can display cost and sell prices together with sale numbers. Generating the Report From the ...

      • Invoice Arrivals Due Date

        When arriving a supplier Invoice in Invoice Arrivals, the Due Date field can be set to calculate one of four ways: Number of days after Invoice Date Number of days after the end of the Invoice Month Of the Following Month Of the Current Month The due ...