Contracts Billed Before/After Their Contract Start Date is a new report in Rev 14 that can be found on the Contracts Reports Income Recognition Menu (CN-4-13-5). This report allows you to view or print the total contract base amount billed within a date range for contracts that either started before a date entered, or after a date entered.
Example:
Results:
Fields:
Beginning System Date Of Billing Or E’nd
Enter the beginning date the report should use for the report.
Ending System Date Of Billing
Enter the ending date the report should use for the report.
Enter Contract Start Date
Enter the contract start date the report should use for the report.
Print Contract Invoice Totals For Contracts With Contract Start Date A’fter Or B’efore Contract Start Date Entered.
Once a date is entered in the Enter Contract Start Date prompt, the wording of “Contract Start Date Entered” on this prompt will change to the date that was entered at the Enter Contract Start Date Prompt. Enter “A” to print contracts that were billed after their contract start date. Enter “B” to print contracts that were billed before their contract start dates.
Most of the reports are from the Contract History File (CNHIST.DT). The bill-to customer number, branch and company number are from the Contract Header File (CNHDR.DT). If the contract is not found, the report will use the Customer record of the ship-to customer to get the bill-to customer number and the branch. If the contract is not found, the company number will be set to 0.
Rev 15 Changes
Logic was added to skip billings in Contract History file that have an associated Credit Memo. Prior to Revision 15, the report would only skip billings if the Contract Invoice was voided.