Invoice Reports

A/R Invoices Report and A/R Invoices by G/L Report

Navigate to Invoices -> A/R Invoices Report or A/R Invoices by G/L Report. The only difference between these two is the presence of a grouping by G/L code.

The A/R Invoices Report and the A/R Invoices by G/L Account screens have search filters at the top for various date range types, Invoice selections (Paid/unpaid/etc), currency and module, as well as specific customers and companies or batches.

These reports offer configurable columns as well as the option to save search criteria and/or column selections to run this report in various ways for various reasons. For example you regularly want to see a list of bank deposits by batch, which has one set of columns and a list of credit card deposits with a different set of columns. Those columns can be saved as part of the template and easily run (or shared with other users to run). (Using report templates has already been documented in Campaign Reports - please refer to the section Using Report Templates there for instructions on using and updating report templates.)

Invoice Search

The Invoice Search feature will find ALL Invoices and not just Miscellaneous Invoices

User navigates to AR module -> Invoicing -> Invoice Search. Search by any of the search fields below. A list of Invoice numbers, Customer name, Invoice date, Origin Description (ex. IN for Ad Bills, JC for Job Costing/Production Invoices), Currency, Period, Amount, Tax, Balance, PO. User can now drill through the invoice using the hyperlink to invoice number.

List of Invoices

Search for Invoices in the system using the various options under Invoices -> List of Invoices

• List of Invoices - Allows filters by Company and Period. Allows options to view in Summary, Detail (includes expansion option to see G/L code) or it can group by G/L Revenue code.

• List of Open Invoices - Same as above, but filters out invoices that have been paid in full

• List of Invoices by Currency - Same as list of Invoices, but also includes filters for Currency and Module

• List of Invoices by Module - Same as list of Invoices, but also includes filter and Module

• Invoices by Revenue Category - Same as list of Invoices, but also includes filter for Revenue Category. Revenue Category is defined in General Ledger Module -> Setup -> Revenue Category, and then must be linked to the G/L in Accounts -> G/L Account Maintenance

• Custom List of Invoices - Most flexible search which includes all available filters

• List of Imported Invoices

• List of Service Charge Invoices - Same options as List of Invoices, but these will only show invoices for Service Charges

• List of Advertising Sales Invoices - Same options as List of Invoices, but can be filtered by Sales Rep. Only invoices from the Ad Module will be returned.

List of Misc. Invoices by Product

User Navigates to Invoices -> List of Misc. Invoices by Product to query by Period, Currency, Batch, Client or Product ID. You can choose to filter out paid invoices. (Note Include Multi-Media Products has been deprecated in the Digital First version of Naviga Ad, so that can be ignored here)

By default, this report will be grouped by Product ID. To remove that grouping, click the X next to Product ID in the light blue heading. To group by something different, drag and drop another column header to the light blue bar.