Use this program to produce a report to reconcile tax documents to the RA Charge file.

This report program reads all tax document records with print dates that fall within the requested date range for the print location requested. Next, the Deposit/Payment file records and RA Charge records are read for the RAs within the date range. Finally, the RA Charge file is read a second time for all posted records for the opening location requested which have DBR dates within the requested date range. Those records found on the second read of the RA Charge file that were not found in the previous read of the RA Charge file will be reported since they are not associated with a tax document reported. This list can then be used for reconciliation purposes.

To access the program, type TXDOCREC (RET) at any menu "OPTION:" field or the appropriate number on the Tax Document Submenu of the Rental Accounting Menu. The screen will then display:

OPTION: RA TO NF RECONCILIATION REPORT

1 NF Print Loc ALL
2 RA Open Loc ALL
3 Start NF Print Date 06-28-04
4 End NF Print Date 06-28-04
5 Rental Type 3 (1=Daily, 2=Lease, 3=Both)
6 Detail/Summary S
7 Print/Display P Printer: /dev/tty
8 Skip RA Charge check




1PRINT 2 3ERASE 4 5BACKUP 6 7HELP 8


Enter data as follows:

1. NF LOCATION

Use this field to enter the location where the tax document was printed. Enter

  1. Up to 6 alphanumeric characters to select a single location.

  2. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+".

  3. "ALL" to include all locations

Press RETURN to accept the default location.

EXAMPLE: Type TUS RET)

2. RA OPEN LOC

Use this field to enter the location where RA's were opened. Enter

  1. Up to 6 alphanumeric characters to select a single location.

  2. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+".

  3. "ALL" to include all locations

Press RETURN to accept the default location.

EXAMPLE: Type TUS RET)

3. START NF DATE

Using your selected date format, enter the Starting Date for when the tax documents were printed. Press RET to default to today's date.

EXAMPLE: Type 60104 RET)

4. END NF PRINT DATE

Using your selected date format, enter the Ending Date for when the tax documents were printed. Press RET to default to today's date.

EXAMPLE: Type 61504 RET)

5. RENTAL TYPE

Select which type of RAs should be included in this reconciliation. Enter :

1 = Daily rentals

2 = Lease RAs

3 = Both

EXAMPLE: Type B (RET)

6. DETAIL/ SUMMARY

Enter 1 alpha character to select the report format.

D = Detailed Report

S = Summary Report

EXAMPLE: Type D (RET)

7. PRINT/
DISPLAY

Enter:

P = Print a hard copy of this report on your terminal's assigned printer. See the Edit Terminal Records Chapter for instructions on how to assign printers.

D = Display this report on this screen. See the General Data Entry Instructions Chapter on how to control the screen display.

EXAMPLE: Type P (RET)

8. SKIP RA CHARGE CHECK

Enter:

Y = Yes. Don't perform the second read of the RA Charge File.

N = No. Don't skip it; perform the second read of the RA Charge File.

EXAMPLE: Type N (RET)


PRESS "F1" AT "OPTION:" TO BEGIN.


Notes about the report:

Data is printed in order by Tax Document number. If more than one tax document is printed for the same RA (due to multiple parties per RA or the split of charges between more than one tax document), tax documents for the same RA will print after each other.

The following data columns are on the report:

First Section:

Tax document number

Issue Date

CNPJ/CNF number of the tax document customer number

Customer name

Tax document total

RA numbers associated with that tax document. For lease RAs, the son contract numbers will print.

The total of the RA Charge records that fall within the date range requested for each RA.

Deposit/Payment records for each RA whose deposit date falls within the date range requested and have positive balance due amounts. Negative balance due amounts and cancelled deposit/payment records are ignored.

The difference between the last 2 columns listed above.

Second section:

The RA charge records found on the second read of the RA Charge file that are not associated with the tax documents reported earlier. An asterisk (*) prints in the place of the tax document in the first column.

Summary figures