Direct Bill Transfers Report

This report provides the details by A/R account of what direct bill settlements were transferred to Accounts Receivable during the specified time frame. The report can be run in summary view or detail view.

The A/R account name, A/R account number, contact name is printed on the report. An additional line will print below the A/R account for the details of each direct bill transferred to it. The direct bill transfer details include billed account name, account number, tax invoice number, reference number, arrival date, number of nights, departure date, and total charges. A total of all direct bill transfers for the A/R account is printed on the report. A total of all direct bill transfers for all A/R accounts contained on the report is printed on the report.

When run in detail view the report will include posting details that make up the amount of the transferred direct bill settlement for each billed account. The transaction detail includes transaction date, transaction code, transaction description, and transaction amount for each transaction associated to the billed account.

You can filter the report by A/R account and account type. You can sort the report by A/R account number, A/R account name, or date.

The application control parameter AR Level determines whether the report will list central or property level information. There are two possible values:

  • Property: The report will only return transactions for accounts that belong to the session property.
  • Central: The report will ignore the session property and return transactions for all accounts that match the other parameters.

The value for the Billed Account Number field depends on the account type:

  • Guest: ReservationStay.PMSConfirmationNumber
  • Group: PropGroupBooking.GroupBookingReferenceNumber
  • Booking Agency: TravelAgency.IATANumber
  • Organization: Organization.OrganizationID
  • Event: P5eventreservations.erv_confirmationnumber
  • Event Master: P5EVENTMASTER.EVM_CONFIRMATION NUMBER
  • Lease: P5LEASECONFIG.LCF_LEASENUMBER

The value for the Arrival field depends on the account type:

  • Guest: ReservationStay. ArrivalDate
  • Group: PropGroupBooking.StartDate
  • Booking Agency: P5Account.Acc_StartDate
  • Organization: P5Account.Acc_StartDate
  • Event: P5eventreservations.ERV_StartDate
  • Event Master: P5EVENTMASTER.EVM_STARTDATE
  •  Lease: P5LEASECONFIG.LCF_ STARTDATE

The value for the Departure Date field depends on the account type:

  • Guest: ReservationStay. DepartureDate
  • Group: PropGroupBooking.EndDate
  • Booking Agency: P5Account.Acc_EndDate
  • Organization: P5Account.Acc_EndDate
  • Event: P5eventreservations.ERV_EndDate
  • Event Master: P5EVENTMASTER.EVM_ENDDATE
  • Lease: P5LEASECONFIG.LCF_ ENDDATE

The report uses this calculation: number of nights = (departure date - arrival date).