Standard Report - Pay Bill Only Transaction

Report Description

Shows transaction types that have "pay but no bill" or "bill but no pay".

Parameters

Parameter Name	Options	Explanation
Branch	All available branches.
Transaction Type	All available Transaction type.
Show Type	Pay Only, Bill Only
Date Type	Accounting Period Date, Week Worked, Check Date, Invoice Date
Start Date
End Date
Group 1	Branch, Customer Department, Root Customer, Employee, Transaction Type	Group data as per selected value and shows the totals as per group value.
Group 2	Branch, Customer Department, Root Customer, Employee, Transaction Type	Group data as per selected value and shows the totals as per group value.
Customer		Filters results by customer Name.

Report Fields

Field Name	Explanation
Acct Period Date	Pulls accounting period date from transaction.
Week Worked Date	Pulls weekworked from transaction.
Employee Name	Pulls employee name from employee.
Transaction Type	Pulls name from configtransctiontype.
Pay units	Pulls payunit from transactionentryitem. Visible when show Type is Pay only.
Bill units	Pulls Bilunit from transactionentryitem. Visible when show Type is Bill only.
Pay Rate	Pulls Pay Rate from transactionentryitem. Visible when show Type is Pay only.
Bill Rate	Pulls BillRate from transactionentryitem. Visible when show Type is Bill only.
Item Pay	Pulls itempay from transactionentryitem. Visible when show Type is Pay only.
Item Bill	Pulls itembill from transactionentryitem. Visible when show Type is Bill only.
Check Date	Pulls checkDate  from paymentbatch. Visible when show Type is Pay only.
Invoice Date	Pulls invoicedate from billingbatch. Visible when show Type is Bill only.
Check #	Pulls checknumber  from paymentcheck. Visible when show Type is Pay only.
Invoice #	Pulls invoicenumber from invoice. Visible when show Type is Bill only.