cancel
Showing results for 
Search instead for 
Did you mean: 

Possible to copy or upload from Excel for Journal Entries?

Former Member
0 Kudos

We currently use some DSUM commands in Excel to allocate labour dollars by account, then we retype the accounts and dollars on the SAP Journal Entry screen.

It would save time to somehow upload or copy from Excel. Is it possible?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Dear Daniel,

Are you looking for function

copying from Excel and paste to SBO grid/matrix?

Try CTM(Clipboard to Matrix) add-on.

Just copy the data from Excel as many rows as you want

and paste them to SBO matrix.

Applicable for core and developed add-ons.

Free trial and demo is available upon request.

http://sapsolution.woongjin.com/B1SD/Support/Tutorial.aspx?tab=CTM

Former Member
0 Kudos

This is an Excel file for importing journal transaction directly from Excel without DTW :

http://e-tanit.blogspot.com/2012/07/journal-entries-in-sap-business-one.html

former_member583013
Active Contributor
0 Kudos

Journal Entries can be uploaded Via DTW.

Former Member
0 Kudos

Can you point me in the right direction - I went to http://www.sap.com/usa/search/index.epx?q1=datatransferworkbench&num=10

and downloaded the first document, SAP Integration and Certification Centers.

It said, "To call the data transfer workbench choose Tools → Data Transfer Workbench" However, I don't have that option under tools. I am using SAP Business One 2005A.

Please point me to where I can read additional instructions on using the DTW.

Thanks!

former_member583013
Active Contributor
0 Kudos

What are you trying.

Are you trying to Install DTW?

Or

Are you looking for a document to tell you how to fill Journal DTW template?

Former Member
0 Kudos

I don't know anything about DTW. If it is not a standard part of SAP (e.g., like AP invoices for instance) then I suppose I would have to install it. Is there anywhere that explains what is DTW, whether it is an extra cost item, how to use it, sample excel sheets, etc?

former_member583013
Active Contributor
0 Kudos

DTW stands for Data Transfer Workbench. It is a tool provided with the Business One product and is used for importing legacy data or any data associated to a module in SAP.

DTW can be installed from the SAP Product CD.

The template for the different documents are available after install. The templates are in Excel format so filling them will be easy to understand.

Once the template is filled, you can import them. There are several document available on DTW.

If you have a valid 'S' number you can download these from the Service market place.

https://websmp110.sap-ag.de/smb/sbo/documentation

https://websmp110.sap-ag.de/~sapidb/011000358700002916332005E

Suda

Former Member
0 Kudos

Perfect!!! Thanks. I do have a valid S number so I will give that a whirl. Thanks again.

former_member583013
Active Contributor
0 Kudos

Good luck with your DTW upload. Let me know if you need any help with completing the Journal templates.

Best wishes

Suda

Former Member
0 Kudos

Dear Suda, where can i find templates for jnl uploads through DTW? Thanks for any help you can provide