D365 Business Central Excel Template – Purchase Invoice

Integration Template

D365 Business Central Excel Template – Purchase Invoice

Supports

SmartConnect.com (Office 2016+)

Publisher

eOne Solutions

Integrate directly into Dynamics Business Central using our pre-configured Excel templates!

The templates make data entry fast and easy without sacrificing power or flexibility.  Each template has a simple interface can be set up quickly and used as-is or customized to fit your exact integration needs.

Right out of the box the templates get you moving quickly, starting with three tabs visible: a README tab, a setup/connections tab, and a main entry tab.  Drop-down boxes speed up data entry on the main entry tab.  Un-hiding tabs and using buttons on the ribbon give more control should you need to customize – nearly every setting and customization is saved in the workbook instead of locked away in code.

With many settings exposed, the templates are incredibly flexible and ready to be customized in many ways.  The main interface allows adding in additional fields to the heading or lines.  Additional Dynamics NAV/365BC pages can be added for creating additional lookups.  Error messages directly from NAV/365BC are in XML and can be cryptic, but cleaner and clearer error messages can be added to help with troubleshooting.

This specific workbook and map are part of a collection of 8 Dynamics Business Central templates.  There is a workbook that integrates into:

  • General Journals
  • Item Journals
  • Purchase Journals
  • Sales Journals
  • Purchase Orders
  • Purchase Invoices
  • Sales Orders
  • Sales Invoice