Sage 100 ERP (formerly MAS90) v 4.5: How to Fix Crystal Report Error
Question: Mike, we recently upgraded to Sage 100 ERP (formerly MAS90)version 4.5 and are now getting a Crystal Error: Failed to load the Crystal...
1 min read
Mike Renner Apr 26, 2013 11:26:00 AM
Question: Mike, we own Sage 100 ERP (formerly Sage MAS90); we also use ADP for our Payroll. How can we import the ADP Payroll information into the Sage 100 ERP General Ledger? We spend many hours manually typing this data into Journal Entries now.
Answer: You can import ADP Payroll into Sage 100 ERP, using the General Ledger Data Exchange Utility that is a part of the General Ledger module.
First Step: You will need to ask your payroll company to provide you with a CSV file of the General Ledger data. In the example below we have used the Alternate Exchange Format .
Second Step: You will need to setup the Data Exchange, General Ledger>General Ledger Exchange. This will open up a wizard as shown, and follow comments and screen shots below:
Click Next
Select Import Data, and Click Next:
Select Transactions and Click Next:
Enter Name and Click Next:
Set Duplicate Procedure to: Do not import new entry, Click Next:
Click Next:
Click next:
Make sure the file has been saved as a CSV file, set Exchange File Type to CSV, set Exchange File Name, Click next:
Select Alternate File Name, click next:
Click Finish:
Proceed, and test first, once this is complete then you can go into
General Journal Entry and review the Journal is correct and then Update.
You can then do Payroll Journal Entries each period from General Ledger Exchange shown in the second to last screen shot and save many hours in Journal Entry processing.
Written by Mike Renner, Partner WAC Consulting, Owner at Computer Accounting Services
Mike is and expert on Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage.
Sage 100 ERP (formerly Sage MAS90/200), Sage 100 Fund Accounting (formally MIP Non Profit Software), Sage Grant Management, Sage Online Fundraising, QuickBooks Enterprise and Point of Sale VAR.
Question: Mike, we recently upgraded to Sage 100 ERP (formerly MAS90)version 4.5 and are now getting a Crystal Error: Failed to load the Crystal...
Question: Mike, we recently upgraded to Sage 100 ERP version 4.5 (formerly MAS 90 MAS 200) and now when we try to print an Accounts Payable check...
2019 Sage 100 Payroll Reports and Tax Table Updates Every year there are important changes to Sage 100 payroll reports. You get tax table updates...