Solved

SAP Import

Posted on 2011-03-16
10
931 Views
Last Modified: 2013-12-08
We're currently in the onset of SAP implementation and we're preparing for the Data import into the SAP system.  We currently have MAS200.  Here's the question and hopefully anybody knows MAS200 and SAP, do I need to have technical expertise in MAS200's backend just to generate inputs to SAP?  What we don't know is what SAP implementation vendors will ask us during data migration.  Is it possible that we will just rely on the MAS200's report capabilities and just generate reports and export to a format acceptable to SAP or do we need to do a lot of ODBC connection to MAS (since it's a file based system not SQL)?

We want to predict and foresee right now what level of knowledge do we need from MAS200 just to provide the right output that will serve as input to the SAP system.  Anyone out there who has experienced exporting from MAS200 / 90 to SAP?
0
Comment
Question by:Vachik
  • 5
  • 5
10 Comments
 
LVL 5

Expert Comment

by:SageMas90_200guy
Comment Utility
Unless your SAP Provider has a routine specific to pulling your data out of Mas90/200, I'm thinking that the odbc connection thru Access or Excel will be your best bet.  Your SAP Vendor should be able to provide you with the mapping to thier System for these data items.    Usually, Static Data first, Customers, Vendors, Chart of Accounts, Inventory Items, Users and Security. These can all be done with plenty of lead time to going live on your new system.  Then, just before go live, Unpaid AR and AP invoices, Open Orders and Quotes.   You will probably have a discussion with your Vendors implementation team about History.. etc.  
0
 

Author Comment

by:Vachik
Comment Utility
Mapping of MAS200 vs SAP is out of the picture in our contract.  What's going to happen is they will provide templates of what they want for SAP import and it'll be our (IT and Business) side to provide the equivalent.

Ok, so when you meant static data, can we safely say that these can easily be generated in the Front End of MAS rather than connecting to the back-end?  Can we generate thru reports or report exports (like excel) most of the aspects of an accounting system?  Does it have like a report creator where we choose the fields and click a button and just generate the report?

Thanks.

0
 

Author Comment

by:Vachik
Comment Utility
By the way, the difficulty in accessing the backend is that most of the fields are archaic and difficult to know which is which.  Definitely, the field names in the backend does not directly correlate with the front-end's definitions (example: invoice might not be invoice in the field name at the back-end).  We were actually able to get from Sage Data Dictionary but it's just overwhelming since there's a lot of "tables" (actually files) that you need to logically define & connect just to derive data from possible import needs of SAP.
0
 
LVL 5

Expert Comment

by:SageMas90_200guy
Comment Utility
Although possible, with reports, most of the canned reports do not translate well when it comes to status flags.  So, in the long run, it would be a more efficient process to utilize the odbc connectivity to download every data item in the file, and change the file to match the SAP import template.  To possibly ease the temptation to stress over this, you may want to aquire, say, a customer import template from the SAP Vendor, and then walk yourself through it.  You may even consider hiring someone familiar with the MAS90 Data File Structure to assist you in this process.  
0
 
LVL 5

Expert Comment

by:SageMas90_200guy
Comment Utility
What version of MAS90/200 are we chatting about  please.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Vachik
Comment Utility
I think everything you said make sense.  Just one more set of questions before I award the points.  Can you provide examples of status flags that might not get exported or generated using reports?  Or can I generate a report where the status flag is the main criteria?  For Example : Report of all invoices that are "unpaid" where "unpaid" is the flag (just assuming).  Do you think this is possible?
0
 

Author Comment

by:Vachik
Comment Utility
MAS 200 Version 4.3  (non-SQL)
0
 
LVL 5

Accepted Solution

by:
SageMas90_200guy earned 500 total points
Comment Utility
In the case of open invoices, they are all retained in an AR_OpenInvoice.m4t File until paid, so thats pretty simple.  Static data contains relationship flags.  Customers for Example, have terms codes attached to them.  Suppose the code on the customer is Actually 01, when the system looks at the AR_TermsCode.m4t File, it sees 01, and then prints NET 10 Days.  Customer Number,  If you use divisions, the division number is available for you to see.  If you do not, it still exsists, ie  every customer number starts with a 00, but the user just can not see it, nor does it print.  It will however export throug odbc.
0
 

Author Comment

by:Vachik
Comment Utility
Thank you.
0
 
LVL 5

Expert Comment

by:SageMas90_200guy
Comment Utility
You are very welcome,

kevin@reedcg.com
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Note: You must have administrative privileges in order to create/edit Roles. Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and marke…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now