Contact Us

×

Contact Us

×

Contact Us

×

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: excel, How ERP can transform business, value of erp, ERP for business, improve business, SAP Business One, B1 Blog, sap

Recent Posts

How Alternative Items Can Save The Day in SAP Business One!

Oct 8, 2019 11:24:59 AM

How to Check Addresses on the Map in SAP Business One!

Sep 30, 2019 3:42:54 PM

How to Set Gross Profit Rate for Service Docs in SAP Business One!

Sep 24, 2019 2:17:19 PM

Don't Receive Same Batch Twice in SAP Business One!

Sep 9, 2019 12:04:20 PM

Don't Navigate. Look Up Menus in SAP Business One!

Aug 26, 2019 10:09:48 AM

Posts by Topic

see all