Setting up a dox42 electronic reporting report in D365 FSCM

Prev Next

There is a possibility of building the dox42 report on top of electronic reporting (ER). It gives you an advantage of using electronic reporting capabilities instead of programming new fields in the data provider of the SSRS report.

Prerequisites

Steps

  1. In D365 FSCM go to Localizations configuration and create an Electronic Reporting configuration or select an existing one:

    The interface displays localization configurations with options for reporting, tax, and metadata.

    Localizations configuration page

    Note

    If you create several dox42 configurations, all of them will be available for choosing in Electronic Reporting destination settings.

  2. We recommend using Excel format in ER format designer for transferring report data to dox42 as in the demo example following:

    SFA Invoice format designer interface with options for importing and mapping data.

    Format designer page

  3. Select the Electronic Reporting destination link to setup the link of the created configuration

    Configuration options for localization settings in Finance and Operations application interface.

    Electronic Reporting destination link

  4. Select New.

    Interface for electronic reporting destination with configuration options for various formats.

    Electronic Reporting destination page

  5. Select Settings.
    There are three dox42 destinations available:

    • Archive (dox42)

    • File (dox42)

    • Screen (dox42)

    Settings for electronic reporting destination with options for file formats and destinations.

    Destination settings

     

  6. For each desired destination set the Enabled button to Yes.

    In contrast to SRSS reports, for ER reports you are able to select several print destinations at once:

    Settings for electronic reporting destination showing file options and sales invoice details.

    Electronic Reporting destination page

  7. You need to fill in the Configuration text field for  all the print destinations field:

    Settings for electronic reporting destination with highlighted configuration options for invoices.

    Destination settings

  8. Select OK.

  9. Select Save.

  10. Go to System administration > Setup > dox42 > dox42 configurations.

  11. Create new dox42 configuration.

  12. Match it with ER configuration (column Format):

    Dox42 configurations page showing sales invoice settings and options in Finance and Operations.

    dox42 configurations

  13. In the column Language preferences configure the language to find an appropriate report template later:

    • User preference: language of the user who generates the report.

    • Company preference: language of the legal entity where the report is run.

    • Blank: the language is not setup.

  14. Go to System administration > Setup > dox42 > dox42 parameters.
    You can find a new tab Electronic reporting reports where you can setup your configuration (the one created in previous step in dox42 configurations form):

    dox42 parameters setup for electronic reporting with various configuration options displayed.

    Electronic reporting reports tab

    Report setup of Electronic Reporting report looks the same way as for SRSS reports:

    Setup screen displaying document generation options and parameters.

    Report setup

  15. Go to System administration > Periodic tasks > dox42.
    In the dox42 audit log you can check the printing of your Electronic reporting report by filtering columns: Report type; Configuration and Format:

    Audit log displaying various report types and configurations in a software interface.

    Electronic reporting in dox42 Audit log

  16. While setting up Electronic reporting through Print Management, you should choose the appropriate report format and do the setup on the Electronic reporting named destination form:

    Print management setup screen showing options for customer invoice and report format selection.

    Print management setup

    Settings for electronic reporting named destination in Sales Invoice document interface.

  17. Go to Organization administration > Electronic Reporting > Electronic reporting jobs.

  18. In the Electronic Reporting jobs form you will be able to see the history of report's running:

  19. Overview of electronic reporting jobs with task descriptions and statuses displayed.

    Electronic Reporting jobs form