Solved

SAP Import

Posted on 2011-03-16
10
935 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
ID: 35160061
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
ID: 35160171
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
ID: 35160210
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 5

Expert Comment

by:SageMas90_200guy
ID: 35160286
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
ID: 35160324
What version of MAS90/200 are we chatting about  please.
0
 

Author Comment

by:Vachik
ID: 35160329
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
ID: 35160385
MAS 200 Version 4.3  (non-SQL)
0
 
LVL 5

Accepted Solution

by:
SageMas90_200guy earned 500 total points
ID: 35160568
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
ID: 35160579
Thank you.
0
 
LVL 5

Expert Comment

by:SageMas90_200guy
ID: 35161595
You are very welcome,

kevin@reedcg.com
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

785 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