SmartConnect Purchase Order Template for Business Central

It makes sense: accountants love Excel and Business Central is for accountants. Out of the box, Business Central offers ‘Edit in Excel’ functionality but it just doesn’t cut it for most users. Thankfully if you own SmartConnect, we have a solution!

Our Purchase Order template lets you do something ‘Edit in Excel’ could never do; import a transaction! ‘Edit in Excel’ doesn’t allow transactions, but SmartConnect doesn’t have that limitation. Combine the transactional capability of SmartConnect with our purchase order template and you have a very powerful combination without ever leaving Excel! Because the template is powered by SmartConnect, you still get all the data validation you expect from SmartConnect. Every time the Purchase Order template is run, Excel gives you a success message or an error description and saves this response to a run log worksheet.

The purchase order template is free to use for every SmartConnect.com customer. Instructions on how to get the template working can be found within the Excel workbook and on the download page here.

If you need some help getting things set up, we have a service offering to getting the template up and running for you.

Leave a Comment


SmartConnect Office Hours Recap for March 15th, 2019
A Summary of Top Features Added Over the Years
Join Us at eXtreme 365 Europe & Attend Our D365 & Business Central Integration Workshop Training
Key Features Series: Bulk, Change & Real-time Process
Q1 Partner Call - Get the Recording


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
New Releases of Extender and SmartList Builder
2017 SmartConnect Integration Bootcamps



open all | close all


CRM Demo Dynamics Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Flexicoder GP GPUG integration integration manager Meet the Team Microsoft Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners release SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.