Wiki

Case Status
Log In

Wiki

 
Payment Reports - Line Level
  • RSS Feed

Last modified on 5/19/2015 11:27 AM by User.

Payment Reports - Line Level

Line Level Reporting

Line level reporting is now available for Payments.  It can be accessed from the Payments section of OASIS.

Line level reporting is very similar to the current customizable report that is available for payments.  However, where the current customizable report focuses on reporting about the payment; this report is designed to focus on the content within the payment.

For example, for this payment...

A customizable payment report will look like this...

A customizable line level payment report will look like this...

Report Body
The payment detail report body focuses on information about the payment: check number, received date, check amount, etc.  The line level report body focuses on the content of the payment.  There are 12 lines in the payment that make up the body of the report.  The line level body lists the customer, paid amount, invoice number, order number, earnings on the invoice and order, etc.

Report Heading
The report heading is a new section available in line level reporting.  The focus of the report body is about the payment content, but information about the payment itself is still important.  That information can be displayed in the report heading.  Here, the information that would typically be in the body of a payment listing report can be displayed: check number, received date, check amount, etc.

Layout
To create report headings, the Layout feature contains an additional section...

The report fields selected in this list become part of the report header.  The width of the field and row breaks can be defined here as well.  Multiple row breaks are allowed in this section of the report to create spacing within the report header.

The report heading can contain any report field.  But the point must be emphasized that the information displayed will be for the entirety of the payment.  Some fields will not display any information (invoice number for example).  While others, like Sales Account(List) would display every value for the whole payment.

The Payment Total Reconciled Amount, Adjustment, and Difference report fields are specialized fields that can only reside within the report heading of a line level report.

Grouping
By default, a line level report uses the payment's unique ID (internal to OASIS) as its first field in Grouping.  This is necessary in order for a report to contain heading information.  If the default field is removed or re-positioned so that it is not the first field in Grouping, the report heading will not appear on the report.  When working in Grouping, if the default field is not present as the first field in Grouping, a dialog will display to act as a reminder that no report heading information will be available...

Likewise, if report header information is added in Layout, but the default field is not present as the first field in Grouping, a dialog will display to act as a reminder that no report heading information will be available...

This default Grouping value will not show as a Group header value.  It will show as a total line for the payment and acts as a convenient way to get totals for the currency fields in the body of the report when reporting per payment.

Examples (same report with only changes in Grouping):
No Grouping defined...

Default Grouping field defined...

Default Grouping field defined along with Manufacturer...