Wiki

Case Status
Log In

Wiki

 
Invoices»Invoice Listing Report
  • RSS Feed

Last modified on 8/18/2017 9:09 AM by User.

Tags:

Invoice Listing Report

Overview 

Invoices come in many styles depending on your business model. You may have or create:

-          From a Manufacturer - Copies of invoices sent to a customer (Commissioned)

-          From a Manufacturer – Invoices sent to you for Buy/Sell items (Resell)

-          Created invoices sent to your customers for buy/sell or services rendered (Resell)

These invoices are entered into OASIS or created from OASIS. They can be reported in several different manners. Users may want to see an Aged Invoice report https://ingensoftware.fogbugz.com/default.asp?W737 to show what invoices they have not been fully paid on or a basic list of invoices for the last month or so. A basic invoice listing report is what is covered in the information below.

 

Basic Invoice Reporting 

In Invoices, go to Reports (toolbar) and select “Invoice Listing”

 

Select the “Output to:” as needed. See the link below for more information on output.

https://ingensoftware.fogbugz.com/default.asp?W471

 

Title – if saving this report for future use you can give it a title and click the “Save Report” option at the bottom of the window. For information on saving reports click on this link http://support.oasissalessoftware.com/support/default.asp?W759

 

Report Style 

 

Invoice Listing – one line per invoice

Will show all invoices (can be filtered on the Select tab)

Resell Invoice

Will show all resell invoices (can be filtered on the Select tab)

Collected Tax Report

If doing resell and charging taxes, this report will show collected taxes for payment to a governing agency.

Disputed Invoices

Only invoices checked as being disputed will show on the report. If an invoice has been resolved it will not show on the report.

Timeframe

PO Entry Timeframe

Uses the PO Entry date for running the report

Invoice Date Timeframe

Uses the Invoice (Entry) Date to run the report

Payment Received Timeframe

Uses the Payment Received (Entry) Date to run the report

Balance Due and Paid Percentages

Min Amount due %/$

First Text Box – uses a percentage of amount still owed (Balance Due) to run the report

Second Text Box – uses a dollar amount still owed (Balance Due) to run the report.

Amount Paid PCT

First Text Box – uses a percentage of amount paid percentage to run the report

Second Text Box – uses a dollar amount paid percentage to run the report

Most groups run the report based on the parameters selected above, however, the report can be further filtered using the Select tab below.

Select Tab (Optional) 

 

Basic tab (right side of screen) 

At this point, in most cases, users will check Commissioned, Buy and/or Sell depending on what they are looking for and then simply hit print.

Below are details of other filter selections for the report.

 

Invoice#:

Report on a single invoice number – the wild card “*” maybe used to search. Example – “1234*” will report all invoices beginning with the number 1234.

PO Number:

Report on a single PO number – the wild card “*” maybe used to search. Example – “1234*” will report all PO’s beginning with the number 1234.

ASO

Report on a single ASO number – the wild card “*” maybe used to search. Example – “1234*” will report all ASO numbers beginning with the number 1234.

MFG Order

Report on a single MFG Order number – the wild card “*” maybe used to search. Example – “1234*” will report all MFG Order numbers beginning with the number 1234.

Project

Report on a single Project Name – the wild card “*” maybe used to search. Example – “1234*” will report all PO’s beginning with the number 1234.

Timeframe

Invoice Date Timeframe

Uses the Invoice (Entry) Date to run the report

Payment Received Timeframe

Uses the Payment Received (Entry) Date to run the report

 Invoice Entry Date

Uses the Invoice Entry Date to run the report

PO Entry Timeframe

Uses the PO Entry Date to run the report

Other Options

Disputed

Will report any invoice flagged for being “Disputed” for more information on disputing an invoice click on this link

https://ingensoftware.fogbugz.com/default.asp?W658

 

Commissioned

Will report commissioned invoices

Sell

Will report the invoices sent to a customer from your company

Buy

Will report the invoices a manufacturer sends to you for resell items

Has Payment

Filters out invoices that have no payments

No Payments

Reports only invoices that have no payments applied.

More, Search Keys, Advanced and Sort tabs (right side)

These tabs will direct you to:

-   More tab – will allow you to narrow the search by Manufacturer, CSR, Customers or Sales Account

-   Search Keys tab – will allow searching by tags that you have created in the system – click on this link to find out more about Search Tags https://ingensoftware.fogbugz.com/default.asp?W205

-   Sort tab – will allow sorting the report by Project Name, Manufacturer or Customer

 

Example of a basic Invoice Listing report