In this article

Sales Reporting

Modules > Property lease management > Leases > All Leases > [select a lease] or select New > Sales based reconciliation > Sales reporting

Use this page to set up sales reports for sales based reconciliation and enter the reported sales amounts for a particular lease. These reports are available for use on the Sales Based page for a charge line for a lowest level in a lease.

To enter the sales reporting information for several leases, use the Mass Sales Reporting page.

Create Sales Report

To create a sales report for sales based reconciliation, follow these steps: 

  1. From the All Leases View select a line or open the Lease Details for a specific lease, and select Sales Based Reconciliation > Sales reporting.
  2. On the Sales Reporting page, select New.
    The Sales reporting number is automatically generated.
  3. Specify a Name for the sales report.
  4. Select the Sales reporting frequency.
    The Sales reporting lines area automatically updated with lines for the reporting year based on the selected frequency. The lines start with a zero (0) amount and are all unreported.
  5. Specify the Report start date and End date.
  6. If needed specify the Grace period.
  7. Select Save.
  8. Repeat these steps from step 3 to create other sales reports.

When you open this page for a lease, the page displays the first sales report that was created. To open a different sales report, select the All sales reporting headers link to view a list of all sales reports from which you can select.

Enter Sales Report Amounts

To enter the sales reporting amounts for a lease, follow these steps: 

  1. From the All Leases View select a line or open the Lease Details for a specific lease, and select Sales Based Reconciliation > Sales reporting.
    The Sales Reporting page opens with the first Sales reporting number that was created.
  2. To change the Sales reporting number, select All sales reporting headers and select the sales report you want. Or if the sales report that you want is not in the list, create a sales report.
  3. For each line that you on which want to report in the Sales reporting lines, specify the Amount, and select Save.

    4. The Reporting date is updated to the date on which the amount is entered, and the Modified date and time are automatically updated to the current date and time. Also, the Sales reporting status is updated to Reported.

    The Sales reporting audit FastTab appears and provides an audit trail when changes are made and saved to the sales reporting line.

Fields

This page contains the following fields: 

Field Description
Sales reporting setup
Specify the setup criteria for the sales based reconciliation reporting.
Identification

Specify the identification criteria for the sales based reconciliation report: 

  • Sales reporting number: Displays the sales reporting number for the report run.
  • Name: Specify a name for the report.
Reporting Period

Specify the criteria for the reporting period: 

  • Sales reporting frequency: Select the frequency for the report.
  • Report start date: Specify the start date for the report.
  • End date: Specify the end date for the report.
Lease Occurrence

Specify the criteria for sending reminders for late charges for late sales reporting.

  • Grace period: Specify the number of days from the specified end date before the sales reporting is considered late.
Apply fees

Select whether late fees apply to your leases: 

  • Yes: Late fees are applied to leases.
  • No: Late fees are not applied to leases.
Use default customer profile

Select to use the posting profile from the customer profile setup in Accounts receivable.

  • Yes: The customer profile from Accounts receivable is used when you create a new sales reporting record.
  • No: Select the posting profile from the drop-down under Posting profile.

When you set up a posting profile, you can set up your fee amount by creating an Interest code. For more information on setting up a fee amount and interest code, see Late Fee Amounts.

For more information on setting up customer profiles, see Customer posting profiles on the Microsoft Dynamics 365 for Finance and Operations documentation.
Posting profile

Select the posting profile to use when you create new sales reporting records. This option is not available if you use the default customer profile.
Fee code Displays the fee code connected to the posting profile.
Sales reporting lines
Year Displays the reporting year.
Period Displays the sequence number of the reporting period.
From/To date Displays the date range of the reporting period.
Late date to report

Displays the last date on which the sales amount can be reported. This date is the period end date plus the specified number days for the grace period. For example, the period end date is June 30, 2020 and the Grace period is 5, the last date to report is July 5, 2020.

Amount

Specify the sales reporting amount for the period. The initial value is zero (0).

Reporting date

Displays the date on which the sales amount is entered. If needed, the date can be changed.

Modified date and time Displays the date and time on which the sales amount or the sales reporting status is changed.
Sales reporting status

Displays the reporting status of the line. The initial value is Unreported.

When you specify the sales amount the status is automatically updated to Reported, which can be changed as needed. Only lines that are reported are included in the reconciliation process.

Sales reporting audit
For the selected reported line in the Sales reporting lines FastTab, displays the changes to the sales amount. This FastTab does not appear for lines that have the Unreported status.
Old value Displays the previous reported sales amount entered.
New amount Displays the new reported sales amount entered.
Modified by Displays the user name who made the change.
Modified date and time Displays the date and time on which the sales amount is changed.
Created date and time Displays the date and time on which the sales reporting line was created.