RESOLVIT SC 1-2
 
 
 
 
 
  

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 to Enhance Your Search - Use Templates in SAP Business One!

Jul 15, 2019 12:14:01 PM

Do You Need Help in Packaging inside SAP Business One?

Jan 23, 2019 12:58:06 PM

How to Set Rate for Selection Criteria in SAP Business One!

Jan 14, 2019 10:35:26 AM

Evaluate Employee Performance with Spy Software for PC

Dec 22, 2018 5:08:49 AM

Setting Batches? Choose The UoM in SAP Business One!

Dec 11, 2018 3:53:07 PM

Posts by Topic

see all