ERP Software Blog | SAP Blogs | MS Dynamics 365 Blogs

How Import Transactions from Excel is Easy In SAP Business One!

By Patrick Burt

Everyone works with Excel files for large variety of purposes. One common usage is related to accounting and recording transactions. To increase productivity, SAP Business One enables you to import journal entries and opening balances from excel. The button “Import From Excel” is added to the Journal Entry and G/L Accounts Opening Balance enables you to import a single entry or opening balance for particular account: 

The option “Journal Entry” is added to the “Import from Excel” window, allowing you to import multiple transactions at once from excel file. In addition, by selecting the checkbox “Display Database Field Name” , the property name from the database is displayed next to the selected columns:

Available in SAP Business One 9.3, version for SAP HANA and SAP Business One 9.3. For more info, contact Mark Burt at mburt@d1tech.net or click here for more SAP Business One information!

Topics: sap, B1 Blog, SAP Business One, ERP for business, value of erp, How ERP can transform business, improve business, excel

Recent Posts

Need a Remark? Create a Template in SAP Business One!

Nov 15, 2018 11:01:47 AM

How to Copy Goods Issue to Goods Receipt in SAP Business One!

Nov 2, 2018 12:48:44 PM

Beware of Vulnerabilities in Windows and Office

Nov 2, 2018 3:50:35 AM

7 Signs You Should Invest in a Cloud ERP System

Oct 12, 2018 3:59:01 AM

There Are New Options for Emailing Documents in SAP Business One!

Oct 3, 2018 3:13:59 PM

Posts by Topic

see all