I would like to have the edit in Excel button on the purchase invoice entry screen to enable importing and amending of invoices

Category: Purchasing
Needs Votes
Ideas Administrator

Thank you for your feedback. Currently this is not in our roadmap; however, we are tracking it and if we get more feedback and votes, we may consider it in the future.

Business Central Team 



This is a requirement as AP invoices are arriving electronically and some have many lines on each AP invoice. Therefore the ability to have a template in Excel and import the invoices all in one go will speed this up.
I have used the Excel add-in to build the template but unfortunately several of the most important fields like QTY are read-only and render the manually designed template un-usable for this feature.

Category: Purchasing


Hi Phil,


Thanks for the suggestion. We have considered adding the ability to edit documents with header and line information in Excel with the Dynamics add-in. But can you provide a little more detail on the scenario and need for the feature on the Purchase Invoice page? Is this primarily to speed up the process of editing invoice lines in Excel?




Jared Hall


Category: Purchasing