Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 963
  • Last Modified:

SAP Import

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
Claudia Carlotti
Asked:
Claudia Carlotti
  • 5
  • 5
1 Solution
 
SageMas90_200guyCommented:
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
 
Claudia CarlottiIT DirectorAuthor Commented:
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
 
Claudia CarlottiIT DirectorAuthor Commented:
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
SageMas90_200guyCommented:
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
 
SageMas90_200guyCommented:
What version of MAS90/200 are we chatting about  please.
0
 
Claudia CarlottiIT DirectorAuthor Commented:
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
 
Claudia CarlottiIT DirectorAuthor Commented:
MAS 200 Version 4.3  (non-SQL)
0
 
SageMas90_200guyCommented:
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
 
Claudia CarlottiIT DirectorAuthor Commented:
Thank you.
0
 
SageMas90_200guyCommented:
You are very welcome,

kevin@reedcg.com
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now