You are planning to implement Dynamics 365 Finance. Accountants in your organization need to be able to enter multiple lines into payment journals. You need to recommend a tool tor expediting data ent

Question

Options

• AUse the desktop version of Microsoft Excel to use the Excel Data Connector app.
• BUse the Data migration tool.
• CUse an aggregate data entity to expose data to the Microsoft Excel Data Connector app.
• DUse Microsoft Excel online to use The Excel Data Connector app.

• A
  88% (38)
• B
  7% (3)
• C
  2% (1)
• D
  2% (1)

Explanation

The Excel Data Connector (Office Add-in) integrated with the desktop version of Microsoft Excel is the recommended tool for expediting high-volume, multi-line journal entry in Dynamics 365 Finance. Accountants can work in a familiar Excel interface, enter or paste many rows simultaneously, and push the data directly back into Dynamics 365 journal lines. The desktop Excel client is required because the add-in needs full Office integration for bidirectional data exchange. Option D (Excel Online) is incorrect because the Excel Data Connector add-in does not support full write-back functionality in Excel Online. Option B (Data Migration Tool) is for historical bulk data migration, not ongoing transactional entry. Option C (aggregate data entities) are read-optimized for reporting/analytics, not for transactional data entry into payment journals.

No community discussion yet for this question.