Edit

Share via

Configure printing for Cash and Banks Ledger reports for Peru

This article explains how to configure printing for Cash and Banks Ledger reports for Peru in Microsoft Dynamics 365 Finance.

The following procedures guide you through the process of setting up and generating the following Cash and Banks Ledger formats for Peru:

  • Cash and Bank Ledger F1.1 for cash transactions
  • Cash and Bank Ledger F1.2 for bank transactions

All the information from the movement of cash and cash equivalents (banks) must be recorded in these books monthly to maintain control of the company's financial transactions.

Prerequisites

Before you can generate and print Cash and Banks Ledger reports, the following prerequisites must be met:

  • The legal entity's address must be in Peru.

  • You must enable both the general LATAM feature and the country/region-specific LATAM feature for Peru.

  • You must download the specific report configuration from the Dataverse configuration repository. Learn more in Import Electronic reporting (ER) configurations from Dataverse.

  • You must download the following reports from the Dataverse:

    • Ledger Accounting LATAM
    • Cash and Bank Ledger F1.1 for cash transactions
    • Cash and Bank Ledger F1.2 for bank transactions

  • You must configure the Electronic reporting (ER) parameters for each report. Learn more in Configure the Electronic reporting (ER) framework.

  • You must configure the SQL Server Reporting Services (SSRS) Reports/Services reference for each format by following these steps:

    1. In the Report/Service ID field, enter an ID for each report.
    2. In the Report/Service name field, enter a name for each report.
    3. In the Report/Service type field, select an ER configuration.
    4. In the Model mapping name field, select Ledger Accounting LTM.
    5. In the Data model definition field, select GeneralLedger.
    6. In the Format mapping field, select Cash and Bank Ledger F1.2 or Cash and Bank Ledger F1.1.
    7. In the list of report/service types, enable Taxes report and General ledger.
    8. In the list of parameters, add TaxApplicationId in the Name column and the tax application code in the Value column.

    Learn more in SSRS Reports/Services references configuration for Latin America.

Additional configuration required for Cash and Banks Ledger Format 1.2

Configure application-specific parameters for both formats

To configure application-specific parameters for both the Cash and Bank Ledger F1.1 format and the Cash and Bank Ledger F1.2 format, follow these steps.

  1. In Dynamics 365 Finance, go to Organization administration > Workspace, and select Reporting configurations.
  2. In the left pane, select the format to configure.
  3. On the Action Pane, on the Configurations tab, in the Application specific parameters group, select Setup.
  4. On the Application specific parameters page, on the Lookups FastTab, select IsApplicable.
  5. On the Conditions FastTab, select Add.
  6. In the Lookup result field, select Yes.
  7. In the Document classification ID (VoucherClassId) field, select all document classes that represent bank transactions and that should appear on the Cash and Bank Ledger F 1.2 report. Alternatively, select all document classes that represent cash movements and that should appear on the Cash and Bank Ledger F 1.1 report.
  8. To ensure that the report shows the transactions that meet the configured conditions, set all the Lookup result fields as Not Applicable or No, and specify Blank and Non-blank conditions.

Generate reports for both formats

To generate reports for both the Cash and Bank Ledger F1.1 format and the Cash and Bank Ledger F1.2 format, follow these steps.

  1. In Finance, go to General ledger > Inquiries and reports > LATAM > General ledger.
  2. For each report format, in the Report ID field, select the report ID that was created.
  3. In the From date and To date fields, set the date range for the report.
  4. Set the Include current layer, Include operation layer, Include tax layer, and Print Customer/Vendor options to Yes.
  5. Select OK.