Cash Applied

SL Cash Applied Report

The SL Cash Applied report is similar to the Dynamics SL Payment Applications report, which lists payments and credit memos applied to accounts receivable documents during a specific time period. It also lists invoices and debit memos to which payments and credit memos have been applied.

To navigate to this report: Open Customers from the Role Center and select a customer to open a customer card. Then select Reports from the ribbon and select SL Cash Applied. You can also use the search feature and search for SL Cash Applied to select the report.

The SL Overlay adds fiscal period functionality to the Options page. You can choose the date range of the report by selecting the Beginning Period and Ending Period in the format MM-YYYY (fiscal period). You can also select the Posting Date under the Filter: Cust. Ledger Entry section in Options.

Important

To use the Fiscal Period option in reporting, you will first need to activate Enable Fiscal Period Feature in the Fiscal Period fast tab of SL Overlay Setup. For more information on the SL Overlay Setup page, see: SL Overlay Setup

Note

If you enter a period range for Beginning Period and Ending Period, this will override any entries in the Posting Date filter field and dates entered are not used. You will receive a message "Posting date will be ignored".

The report includes filters on all dimensions. Select desired dimension options for filtering under the Filter: Cust. Ledger Entry section.

The report will print two lines for each payment.

  • The first line provides information about the payment document (i.t. Payment PMT or Credit CM):

    • Payment - Customer number and Name: The customer related to the payment or credit document. - Posting Date: The date that the payment or credit was posted - Type: The type of document: Payment (PMT) or Credit (CM) - Original Amount: The amount of the original payment or credit document - Discount Taken: If a discount was applied, along with the payment, the discount amount taken displays. - Amount Applied: This is the total of the Original Amount of the payment or credit, combined with the Discount Taken (if any). - Remaining Balance: This is the remaining balance (if any) on the payment or credit after it was applied to the invoice. If a partial application was made, this field will show the payment or credit balance remaining to be applied.

  • The second line displays information about the document to which the payment or credit is being applied:

    • Applied-To Document
      • Type: The type of document (example: Invoice)
        • Number: The document number to which the PMT or CM was applied.
        • Due Date: The due date of the document to which the PMT or CM was applied.
        • Discount Date: The discount date of the document to which the PMT or CM was applied.
        • Original Amount: The original amount of the document to which the PMT or CM was applied.
        • Discount Taken: If a discount was applied, along with the payment, the discount amount taken displays.
        • Amount Applied: This is the total of the Original Amount of the payment or credit, combined with the Discount Taken (if any).
        • Remaining Balance: This is the remaining balance (if any) on the payment or credit after it was applied to the invoice. If a partial application was made, this field will show the payment or credit balance remaining to be applied.