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.

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.

Edit a Fee Note

Before you can make any changes to a fee note, the fee note must be posted.

You can make three types of changes to a fee note:

• Waive: When you waive a fee note the fee note is not removed from the billing or sales reporting lines, but the status of the note is changed to Waived. You can see the amount of the fee note, but the fee note is not charged.

• Reinstate: When you reinstate a fee note there is no change on the billing or sales reporting line, but the status of the fee note is changed to None.

• Reverse: When you a reverse a fee note the fee note is removed from the billing or sales reporting lines, and the status is then changed to None. Reversing a fee note create an adjustment invoice. You can then create a new fee note for the periods.

When you perform any of these actions, a new invoice is generated for the customer or tenant.

To edit a fee note, do the following:

1. After you add a lease or select to edit a lease from the All Leases View, open the Sales reporting page.
2. Go to the Sales reporting lines FastTab. Select Fee note and the type of action you want to perform:
   1. Waive
   2. Reverse
   3. Reinstate
3. Depending on the type of action you select, a new page opens. If you are waiving a fee, the window is Waive fees. The layout and options of the new page are the same for each of the three types of actions.
4. On the new page, Waive fees, for example, select the checkbox under the Waive column.
5. Confirm your action on the fee note and close the page.

After you take an action on the fee note you can open the Fee Note Adjustment History page to view the history of the fee note, if it has been waived or reinstated before.

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 based rent late fee note number	Displays the late fee note number of the lease.
Fee amount	Displays the amount of the late fee.
Adjustment status	Displays the status of the fee note attached to a specific sales reporting line: None: The fee note has either not changed, not been applied, or has been reinstated. Waived: The fee note is waived and is not due.
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.

Buttons

The following buttons are available on the Action tab of the Sales reporting lines FastTab

Sales reporting lines FastTab buttons

Button	Description
Fee note	Changes the status of a fee note. To change the status of a fee note, the fee note must be posted. Waive: Waive the fee note for a specific sales reporting period. Reinstate: Reinstate the fee note for a specific sales reporting period. Reverse: Reverse the fee note for a specific sales reporting period.
Fee history	Opens the Fee Note Adjustment History page where you can see the history of adjustments of a specific fee note.