FAQ Zoeken Gebruikerslijst Gebruikersgroepen Profiel Log in om je privéberichten te bekijken Registreren Inloggen

consolidated financial reporting in F

 
Nieuw onderwerp plaatsen   Reageren    Wie is de mol Online -> Speluitleg
Vorige onderwerp :: Volgende onderwerp  
Auteur Bericht
xuezhiqian123



Geregistreerd op: 16 Jul 2018
Berichten: 2692

BerichtGeplaatst: 11-01-2020 05:29:26    Onderwerp: consolidated financial reporting in F Reageren met citaat

SAP Business One Data Transfer Workbench in Complex Migration Projects Computers Articles | July 22 Victor Lindelof Shirt , 2011
Data Transfer Workbench is part of the SAP B1 basic training and certification exam.? However certified consultant is familiar with only limited part of the data import power of DTW.


They know that it is good for limited scope initial data migration, where you need to fill in CSV templates, often referred as Excel templates among consultants.? If you need to move historical data or setup ongoing data import from legacy system, we recommend you this small publication.? It is not intended to end programmer, it is rather for IT manager or project manager Ashley Young Shirt , responsible for SAP BO implementation project results.? We assume that such terminology as ODBC connection, SQL Queries and Views are common knowledge and if you got your Bachelor or MBA degree in the university ? you probably have SQL class taken and consider yourself computer literate.? Let?s come down to the details:


1.?CSV Template compliant SQL View.? It seems like Data Transfer Workbench is pretty simple in its data connection ? it is tuned to process CSV templates.? It has the option of connection to external data source via ODBC, however this is not documented in great details.? For numerous customers we helped with ODBC connection to enable initial conversion or ongoing import from ODBC complaint DB platforms, including MS SQL Server, MS Access Andreas Pereira Shirt , Oracle, MySQLPHP.? How to open ODBC compliant data to DTW?? Well, next paragraph has some clues


2.?SQL View which replicates the CSV template rows.? Well the answer might look like natural, however we saw numerous SB1 integration projects failed and customers asked for second opinion.? Ok, here how you can accomplish the job.? Consider creating Linked Server in MS SQL Server or use OPENROWSET construction to connection to external ODBC compliant database.? Use Union clause to produce the first row as the headers (by whatever reason in some cases we had to produce two rows of header Jesse Lingard Shirt , prior to appending data sensitive lines) and the second select statement should match the document fields.? In the header row, please use exactly the same names for the columns as in CSV template.? If you are working with MS SQL Server 2008 64 bit and SB1 version 8.81 it is known issue that Linked Server is not working as you would expect.? The alternative is SSIS package.? Obviously SSIS is not something that you could call in DTW.? We believe that Microsoft will fix the issue in the future.? For now we recommend you to think about moving your legacy Accounting tables into MS SQL 2008 via Data import wizard and then create SQL view with unionized header and lines directly in SQL


3.?Linux, PHP and MySQL.? We noticed some trends that SAP B1 is popular in alternative Operating System platforms, meaning not Microsoft Windows, such as Linux.? Popular free programming environment on Linux is PHP and free database platform is MySQL.? There are popular ecommerce shopping carts dedicated to LinuxPHP.? One of the most popular is Magento.? If you are looking for small business ecommerce solution to integrate Magento shopping cart to SB1 Sales Invoice with customer deposit Chris Smalling Shirt , there is the way to do export to text file from Magento and then process it via Data Transfer Workbench on demand.? We tried scheduled DTW ODBC integration and it didn?t work on version 2007A.? After appealing to SAP technical support we got the reply that it is not supported at this time (request was sent in 2009)


4.?Historical Data Migration.? It is not practical to insert millions of rows into CSV Template.? Excel is designed to serve accounting people with reasonable restrictions associated with human document reading limitations.? If you have to import millions of historical Sales Invoices the job should be done via SQL database


5.?Message to international customers of SAP Business One.? It is possible to do the whole data conversion or ongoing integration setup project via web session and remote desktop connection to your user workstation or the server.? SB1 is marching across the world with good success in Europe, South America with Brazil, Asia including India and China.? There is good progress in USA, Canada and Mexico.? If you are working in the local facility of multinational company where in the headquarters they are deploying SAP or maybe Microsoft Dynamics AX or GP then B1 is a good candidate for your local accounting.? It exports everything to Excel and you can suggest to do consolidated financial reporting in FRx or Microsoft Management Reporter via Excel worksheet of exported GL trial balance


6.?Please call us 1-866-304-3265, 1-269-605-4904 (for international customers Anthony Martial Shirt , where our representatives pick up the phone in Naperville and tion (Transport Transit, Govern heap NFL Jerseys Free Shipping[/url] Cheap NFL Jerseys Online Cheap Jerseys China Cheap NFL Jerseys Wholesale Jerseys Wholesale NFL Jerseys
Terug naar boven
Profiel bekijken Stuur privébericht
Berichten van afgelopen:   
Nieuw onderwerp plaatsen   Reageren    Wie is de mol Online -> Speluitleg Tijden zijn in GMT + 2 uur
Pagina 1 van 1

 
Ga naar:  
Je mag geen nieuwe onderwerpen plaatsen in dit subforum
Je mag geen reacties plaatsen in dit subforum
Je mag je berichten niet bewerken in dit subforum
Je mag je berichten niet verwijderen in dit subforum
Je mag niet stemmen in polls in dit subforum


Wilt u geen reclame op dit forum en genieten van extra voordelen? Klik dan vlug hier voor meer informatie!
 

Powered by phpBB © 2001, 2005 phpBB Group
Template xabbGreen für phpBB Foren - created by phpbb styles
immo op Realo
Maak snel, eenvoudig en gratis uw eigen forum: Gratis Forum