This error is related to the “DEP” on the WIN 2008 server and you need to disable the DEP from checking the Launcher32.exe file.

You might ask what DEP is?   Well  Data Execution Prevention (DEP) is a security feature that can help prevent damage to your computer from viruses and other security threats. Harmful programs can try to attack Windows by attempting to run (also known as execute) code from your computer’s memory reserved for Windows and other authorized programs. These types of attacks can harm your programs and files.DEP can help protect your computer by monitoring your programs to make sure that they use computer memory safely. If DEP notices a program on your computer using memory incorrectly, it closes the program and notifies you

Turns out that  MAS90 or 200 are not compatible with DEP on Version 4.30 and it must be disabled.  Otherwise you will receive the force close  errors and Exception error like the one below.

==============
Exception EAccessViolation in Module RpcRtRemote.dll at
00001479
Access violation at Address 74D31479 in module
‘RpcRTRemote.dll’.  Write of address 74D31479

=======================================

So the best way to resolve it is by disabling the  DEP when launching the MAS90/200

Here is  how you disable it.

I must give  kudos  to Nathan Shaw  for the solution.

Share

DSD Business Systems   

 MAS 90/ MAS 200 White Paper 

 DE6 / DE9 / DE9c / California Quarterly Unemployment Filing

Background 

 The following DSD White Paper explains the 2011 changes to filing of California EDD Quarterly Unemployment, and how it relates to DSD’s MRCA California Quarterly Unemployment Reporting. 

 The following are presented in this White Paper: 

  • What are DE6, DE9 and DE9C filings?
  • How does DSD’s MRCA California Quarterly Unemployment Reporting fulfill these filings in MAS90 | MAS 200?
  • What format is the MRCA California Quarterly Unemployment Reporting in?
  • How do I setup an online account with the EDD?
  • How do I generate the upload file using DSD’s MRCA California Quarterly Unemployment Reporting?
  • How do I upload the file to the EDD website?
  • How do I contact the EDD for assistance?

  

What are DE6, DE9 and DE9C filings?
DE6: The California DE6 Form, Quarterly Wage and Withholding Report, is a required report to be filed by California employers. Business owners report individual employee’s wages and personal income tax (PIT) withholdings. This form is used for filing for years 2010 and prior. To view a copy of this form, select this link: http://www.edd.ca.gov/pdf_pub_ctr/de6.pdf 

When filling out this form, you submit Company and Employee information on one form. 

If you have 250 employees or more, you may not use this form, but must instead file electronically. 

DE9 and DE9C: Starting in 2011, the DE9 and DE9C forms replace the DE6 form. Basically, they broke up the DE6 form into 2 forms: The DE9 is the Company information, and the DE9C is the Employee information. 

To view copies of these forms, select the following links: 

http://www.edd.ca.gov/pdf_pub_ctr/de9.pdf

http://www.edd.ca.gov/pdf_pub_ctr/de9c.pdf 

As with the DE6 form: If you have 250 employees or more, you may not use this form, but must instead file electronically. 

How does DSD’s MRCA California Quarterly Unemployment Reporting fulfill these filings when using MAS 90 |MAS 200? 

As mentioned, if you have more than 250 employees, you may not use the DE6 or DE9/DE9C forms for filing. Conversely, you may file electronically instead of using these forms, regardless of how many employees you have. 

DSD’s MRCA California Quarterly Unemployment Reporting is a MAS 90/200 enhancement that generates the file that can be sent to the EDD electronically. It can be purchased through your Sage Reseller. If you are a Sage Reseller, you may contact DSD directly to purchase at (858) 550-5900. 

What format is the MRCA California Quarterly Unemployment Reporting in? 

As of 2011, the California EDD allows for three (4) formats for Electronic filing: 

• Comma-Delimited file (CSV)
• MMREF format
• ICESA format
• XML format (added in year 2011) 

DSD’s  MRCA California Quarterly Unemployment Reporting is in the ICESA format. 

According to the California EDD, all 4 formats will be allowed for the next few years. At some point, the MMREF and ICESA formats will be retired, and you will be required to submit in XML format. DSD is currently researching this format, and the MRCA California Quarterly Unemployment Reporting will be changed to this format in the next 18 months, before it is required by the EDD. 

When uploading the electronic file, the EDD allows for the CSV and XML files to be uploaded as-is. For the ICESA and MMREF formats, the file must be zipped into a .zip file before uploading. 

How do I setup an online account with the EDD? 

Starting March 1, 2011, employers that submit Quarterly Unemployment Reporting electronically are required to enroll in e-Services for Business. To start this process, select the following link: 

https://eddservices.edd.ca.gov/index.html 

1. Select the e-Services for Business Login link
2. Select the Enroll for a username and password link
3. Enter the information on the e-Services for Business enrollment.
4. Continue through the enrollment process. Once you obtain a User Name and Password, you will then have the ability to upload your electronic file. 

IMPORTANT: DSD recommends that you setup your EDD account IMMEDIATELY, as it may take a week or more to obtain your User Name and Password, 

How do I generate the upload file using DSD’s MRCA California Quarterly Unemployment Reporting? 

The latest version of the User Manual for DSD’s MRCA California Quarterly Unemployment Reporting can be obtained by selecting the following link: 

http://www.dsdinc.com/enh/downloads/MRCA440.PDF 

Please review this User Manual, as it explains how the UIWAGE file is created. Once you create your UIWAGE file, you can then zip the UIWAGE into a .zip file, and use the .zip file to upload. 

To create a .zip file, typically, you can right-click on the UIWAGE file, and select “Send to” and then “Compressed (Zipped) Folder”. This will create a UIWAGE.ZIP in the same directory as UIWAGE. Again, the UIWAGE.ZIP is the file that you upload. 

How do I upload the file to the EDD website? 

1. Go to https://eddservices.edd.ca.gov/index.html
2. Select the eServices for Business Login link
3. After you login, a new screen will be displayed that has two sections. On the top section, it displays My Summary and on the bottom section, it displays My Accounts.
4. On the right side of the screen is the navigation “I Want to…” with some selections
5. IMPORTANT: Do NOT select an account from My Accounts, as it will display different ”I Want To” selections.
6. From the “I want to…” selection, select Attach a Return File
7. A new screen will be displayed that allows for you to enter information for the upload.
8. At the top of this screen, it will ask you for the Attachment Type.
9. Select DE9, ICESA, ZIP
10. Select the Browse Button to select the UIWAGE.ZIP that you generated from DSD’s MRCA enhancement.
11. Go to the Return File Upload section and complete the information on the screen. 

On the following page, Appendix A, there is a screenshot of this Upload screen. 

How do I contact the EDD for assistance? 

There are many phone numbers on the EDD website that you can call, but the one that I used that got me directly to the proper person is: (800) 796-3524

Prepared by
Jon Reiter
VP Engineering
 

DSD Business Systems 

 

Share

We are commonly asked how to reverse a Check or credit payment in MAS90

Reversing a check  (No Job cost):

  • Expand Modules, Accounts Payable, Main, and click Manual Check Entry.
  • In the Bank Code field, enter the bank code associated with the check to reverse.
  • In the Check No. field, enter the check number of the check to reverse.
  • In response to the question, “Is this a check reversal?” click Yes. (See step 6 if you see a different question.)
  • In response to the question, “Recall original invoices?” click Yes to reopen the original invoice or click No leave the original invoices closed.   If No is selected,
    • select the GL Distribution check box (version 4.10 and earlier)
    • From the Lines tab, click the GL Distribution button (version 4.20 or later)
  • In response to the question, “This check has been voided. Do you want to reuse check number?” click Yes.
  • In response to the question, “Is this a check reversal?” click Yes.
  • In response to the question, “Recall original invoices?” click Yes to reopen the original invoice or click No to leave the original invoices closed. If No is selected, select the GL Distribution check box (version 4.10 and earlier) or from the Lines tab, click the GL Distribution button (version 4.20 or later).
  • On the Lines tab, the invoice amount will be displayed with a negative amount. Click Accept.
  • Print the Manual Check Register and then update.

Note: If the check was for G/L distribution only, an invoice will be created and posted to the vendor’s Open Invoice file. The invoice number would be CKxxxx (where xxxx is the check number).  To avoid posting an open invoice to the vendor’s Open Invoice file, in response to the question, “Recall Original Invoices?” click No, and select the GL Distribution check box (version 4.10 and earlier), or from the Lines tab, click the GL Distribution button (version 4.20 or later). Manually enter the negative check amount.

If Job Cost is involved:

  • Expand Modules, Accounts Payable, Main, and click Manual Check Entry.
  • In the Bank Code field, enter the bank code associated with the check to reverse.
  • In the Check No. field, enter the check number of the check to reverse.
  • In response to the question, “Is this a check reversal?” click Yes. (See step 6 if you see a different question.)
  • In response to the question, “Recall original invoices?” click Yes to reopen the original invoice or click No leave the original invoices closed. If No is selected,
    • Select the GL Distribution check box (version 4.10 and earlier)
    • From the Lines tab, click the GL Distribution button (version 4.20 or later).
  • In response to the question, “This check has been voided. Do you want to reuse check number?” click Yes.
  • In response to the question, “Is this a check reversal?” click Yes.
  • In response to the question, “Recall original invoices?” click Yes to reopen the original invoice or click No to leave the original invoices closed. If No is selected,
    • Select the GL Distribution check box (version 4.10 and earlier)
    • From the Lines tab, click the GL Distribution button (version 4.20 or later).
  • In response to the message, “J/C Invoices recalled, manual distribution must be completed” click OK.
  • On the Lines Tab, the invoice amount will be displayed with a negative amount. Click Accept.

If you have any questions please contact our support desk

By Jim Woodhead
DSD Business Systems

Share

Have you ever wondered about how to automate the process of entering Accounts Receivable invoices into Sage MAS 90 ERP? How about uploading Sales Order data while you sleep at night, ready to process by the time you arrive in the morning?

With the Sage MAS 90 Visual Integrator (VI) module, users can automate the import of Accounts Receivable, Sales Order, or other types of data, by running a VI job from the command line. A Visual Integrator job or any other Sage MAS 90 program can run independent of Sage MAS 90, with a Windows task, a batch file, or similar method. This allows a user to run the job after business hours, or several times a day, without anyone having to log in to Sage MAS 90.

Please review the details below for examples and notes regarding the command line structure:

Note this is for Version 4.xx

The following information must be included in the command line:

..\MAS90\Home\Pvxwin32.exe ..\launcher\sota.Ini ..\SOA\Startup.M4P -ARG DIRECT (UI State) (User Logon) (Password) (CompanyCode) (Program Name) (Program Argument)

Example:

..\MAS90\Home\Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION myuser mypassword ABC VIWI00 AUTO

Notes:

  • If an argument has no value (for example: if the User Logon has no password), use quotation marks (“”) to hold the arguments in place.
  • The User Logon above refers to the Sage MAS 90 or Sage MAS 200 ERP user logon setup in User Maintenance (not the User Code field in User Maintenance).
  • UIState—Set this argument to either UION or UIOFF. This setting specifies if a User Interface exists (for example: a user could receive notification of errors in a message box.)
  • Set the Program Argument to Auto or Manual. The Manual option forces the import job interface to launch, and requires the user to click Accept. Use the Manual option to test your procedure, then use the Auto option once you have verified that the job launches correctly in the Manual option.
  • For batch file command lines, use this example as a model:

    F:
    CD F:\Version4\Mas90\Home
    Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION myuser mypassword ABC VIWI00 MANUAL
    REM Note we set the current directory to Home first
    REM Note we set the program argument to MANUAL initially
  • Any program run with a command line on version 4.0 must exist as a Task within the Sage MAS 90 or 200 Role-based security system. You must add Visual Integrator “legacy” jobs (jobs not using a 4.0 Table as the Primary Table) to the Jobs Menu before running the job with a command line. Jobs using a 4.0 Table as the Primary Table are automatically added to the Jobs Menu (for example General Ledger jobs).
  • After you add the task to the system tasks files, use Role Maintenance to grant access to the new menu for the Visual Integrator Jobs menu. The user logon specified on the command line above must belong to a role that has access to this new task or menu item.

Sage MAS 200:

  • For Sage MAS 200,  the path to the Sage MAS 90 directory used in the shortcut properties corresponds to the Sage MAS 90 directory of the Sage MAS 200 Server Installation, not the Sage MAS 90 directory on the workstation. In the VI job, enter the path to the Import File/Export File as it appears from the WORKSTATION, and uncheck the ‘On Host’ option.

    .

If you have any questions or need assistance creating or automating an import,   please contact our support  desk at DSD Business Systems

Jim Woodhead

VIA  Sage e-bulletin

Share

Recently with Vista and Window 7,  we are having reports of the images disappearing from the taskbar on the MAS90/ MAS200 launcher.  It turns out that  it is due to a resolution issue in windows and MAS.

In order to fix it, you need to change the DPI setting  back to the default settings (96 Pixels Per Inch/100%).
Here are detailed instructions  for Window 7/Vista followed by Win XP.

  • Windows 7/Vista
    1. Right-click on Desktop
    2. Select Personalize.
    3. Click on Display link (bottom left).
    4. Select ‘Smaller – 100% (default)’
    5. Click Apply to save changes.
  • Windows XP
    1. Right-click on Desktop.
    2. Select Properties
    3. Go to the Settings tab.
    4. Click Advanced.
    5. Change DPI settings to ‘Normal size (96 DPI).
    6. Click Apply to save changes.

If you need any assistance with this please call our support desk at DSD Business Systems

Jim Woodhead

Share

Now that the giant FRX has fallen from the ranks of Financial Statement writing champion, a battle is beginning between BizNet Insight and Sage MAS Intelligence (SMI) a.k.a. Alchemex. I recently received the following  marketing piece with a comparison of the two products.  It is definitely biased towards  the BizNet product but I provided it because it does give some decent information about both products.  The key things missing  (not even mentioned)  are that SMI has a  killer BI dashboard out of the box and the fact that the base SMI product is free for all SAGE customers with current SMP’s.

Let the battle begin!!

Marketing piece directly  from BIZNET Software

If you would like more information about either  BizNet or SMI  Please contact our office.

Jim Woodhead

DSD Business Systems

Share

A Fellow Sage Partner ,  Clients First Business Solutions,  recently held a webinar for Sage MAS 90, MAS 200, Extended Enterprise (EES) and MAS 500 end users showing the new  SAGE MAS Intelligence Excel based reporting tool that Sage is using to replace FRx.  This solution embeds as an extension to excel and then  reports on not just financial data (like FRx) but also non financial data such as dashboards, aging reports, KPI’s etc.

The video explains both the similarities and differences between the previous solution, Microsoft FRx and SMI.  You can think of  SMI as  Business Intelligence Dashboard and financial statement  solution that is embedded into Microsoft Excel that can directly read and understand MAS 90/200/500 data files.  It’s designed to create a walk a user through creating not only financial reports and statements, but other types of non-financial reports such as dashboards, analytics, KPI’s and even traditional reports such as an AR customer aging.

If you have any questions on this product feel free to call us at  858 550-5900    or contact Jeff Keirns   jeffk@dsdinc.com   for more information or to arrange a one on one demonstration.

Jim Woodhead

DSD Business Systems

www.dsdinc.com

Share
We get a lot of requests on the best ways to increase your  MAS 90 or MAS 200 performance.
Here are some suggestions and things you might try.

Workstation configuration

  • For client workstations, make sure to exclude virus scanning pointed at your network MAS 90/200 installation folder. Since these files are in constant change, an anti-virus scanner will attempt to “scan” each file every time this happens, causing significant performance issues. Note: MAS 90/200 supports only corporate editions of anti-virus packages.
  • All modern versions of MS Windows can benefit from more RAM. If you are running less than 1 GB of RAM, consider upgrading to at least 2 GB’s. More is always better, in this case. The overall performance improvement in all Windows applications will be significant.
  • If you are running MAS 200, network performance is critical. Make sure you are running at least 100MB network interface cards (in full duplex mode) and your workstation and cabling can support these speeds (Cat 5 10Base-T cabling is a good choice). If you are running a large installation with 20+ workstations, consider using a managed Ethernet switch to support high throughput. (Editors note:  My experience is that Gigabit Ethernet is the single biggest improvement of speed with MAS90 in version 4.x.  The application sizes have grown 400% since version 3.71 and all applications are pulled over the network when you launch them.  100mbs sounds fast, but its ‘megabits’ not ‘megabytes’ .  Remember it takes 8bits to make a byte so this speed, with additional network collisions and overhead isn’t even enough to watch a single high definition video)
  • If you are running MAS 90 and experience intermittent hanging of the application, make sure all the printers in the windows printer manager are valid printers. If a printer has been removed from the network but not removed from the Windows printer manager, you may see intermittent hanging as MAS 90 attempts to connect to a printer.
  • If you are running MAS 200 and Crystal Reports are slow to print, consider trying the Crystal client/server ODBC driver.

Network Configuration

  • Terminal Services – using terminal services for your MAS 90 can tremendously improve your overall application performance. The is especially true if the client workstations are not up to the latest performance specs or the system network bandwidth is not adequate. (Editors Note:  Obviously if Terminal Services works well, so will Citrix. )
  • Avoid Peer-to-Peer network configurations – network performance in these types of networks is not adequate for MAS 90/200.

Though there are thousands of online resources to help you tune your Windows PC performance, here are a few that provide the biggest “bang for the buck:”

General Windows XP performance issues

  • General performance – remove all unused applications. Go to “control panel” –> “add/remove programs” and uninstall everything you don’t use. You will be surprised how many applications you really don’t need or use. If you are not sure what the program is, don’t remove it. And don’t remove anything labeled as a “Hotfix” or “patch.”
  • Disk Drive performance – clean up your hard drives. Go to My Computer and right-click “local disk” and select properties. On the “general” tab, select “Disk Cleanup.” The utility will analyze your hard drive and recommend areas to be cleaned. Select the file types that can be removed and select “ok” and the utility will clean things up.
  • Graphics performance – make sure you have the latest video driver for your graphics card. Most graphic card manufacturers have support sites that allow you to download the latest driver for free. If you are not sure how to do this, talk to your system administrator.

As the Windows operating system gets more sophisticated, the demand on PC hardware also increases. With the economy being so tight, many companies are delaying the purchase of new PC equipment until it is absolutely necessary.  As businesses, we need to manage costs but we also need to manage productivity.  If a salesperson can enter 10% more sales orders per day, the cost of new hardware would pay for itself in a matter of weeks

If you have any questions regarding this please contact our support desk at DSD.  We can definitely assist you.

Jim Woodhead

DSD Business Systems

Share

Recently  Steve Malmgren the  ”Chief  Architect” of MAS 90 and 200 released a blog describing the  key differences between the old MAS200 SQL version  and the New MAS200 4.45 version.   This new SQL version is due out November 2010.

Here are the highlights:

I want to  shed some light on the key differences between the 3.7x SQL product and the new Sage ERP MAS 200 SQL version 4.45, releasing to market in November 2010.

The bottom line is 4.45 has achieved a level of performance comparable to the 4.40 Providex version, especially for data entry and maintenance screens.  For an average size company data set, reports, registers and updates will be close to Providex, and do not exhibit the type of degradation experienced in the 3.7x product.  Ad-hoc reporting speed via Business Insights Explorer and Crystal Reports is greatly improved over the Providex ODBC driver.


Feedback on performance of the product from partners involved in the beta process has been very positive.  Also, even before Beta began, we hosted a preview party where we invited several partners to Irvine to test drive 4.45 and we received positive feedback on performance and many other aspects of the new SQL product.  Check out this link to a blog entry from Doug Deane at DSD that discusses that experience.


Now let’s talk about what’s under the hood and why this is the case…

One of the primary architectural goals of the Business Framework was to be able to support a much better implementation on SQL Server.  This was primarily achieved in two areas.

Schema:

A fundamental change that needed to occur was at the schema level and how the MAS 200 programs access and interact with that data.  In the 3.7x version, the schema inside the SQL Server database tables was flattened out into discrete columns, however the MAS 200 program logic was designed to reference a single large string with position offsets for each individual column (remember the Offset and Length from the TRSG?).  What this meant is every time a row was read from SQL Server, the Data Access Layer needed to take the discrete columns from the table and concatenate them together into one big string that the programs could interact with.  Then when the row was written back out, the string had to be split back out to the individual columns in the SQL table.

Another issue that compounded this problem was the variant (or multiple) record types defined in the system.  An example of this is the 3.7x, SO2 table, which was the detail table for Sales Orders, where based on the line type (regular item, misc item, special, comment, etc.) different sets of columns from the SQL table were needed to map into the large string and then split back out on the write.

Finally the 3.7x detail tables were stored in a linked list sequential access table.  Not only did these tables cause issues for custom Crystal reports and trying to have the detail lines report in the correct order, they were also a source of initial deadlock issues and cross-linked orders.

All of these issues are eliminated in version 4.45.  All programs interact directly with the discrete columns that are in the SQL tables and there are no more variant record types, eliminating the back and forth mapping between the application and the database, improving overall performance of the system.  No more linked list sequential access tables for transaction detail entry tables, improves the overall integrity of the system.



ADO Data Access Layer:

The biggest difference in regards to performance between the 3.7x version and 4.45 is in the streamlined Data Access Layer using ADO to request data from SQL.  One of the largest performance bottlenecks in the 3.7x version was in how data was requested from SQL Server and some basic assumptions of how that data would be used within the application.  In 3.7x when data was requested a Dynamic Cursor was generated so that rows could be fetched as needed to be processed.  Important to note is that this cursor contains all rows from the starting access point to the end of the table based on the index being used.  If the process needed to consume all of the rows in the cursor then this is relatively efficient.  If however, the assumption, that all rows are needed, is incorrect then performance problems surface.  This is because the cursor is discarded and potentially rebuilt many times during the process.  This becomes particularly evident with large data sets.  Furthermore, even if all rows were to be processed any updates or deletes issued against those rows would cause the cursor to be discarded and recreated, causing more performance issues.

In 4.45, we have taken several steps to alleviate these problems.

  • The new development coding standards present in the Business Framework modules support the ability to only request the rows that are needed, which eliminates the need to generate a cursor to the end of the table.
  • Dynamic Cursors are no longer used, replaced with the fastest possible Read Only/Forward Only cursor type.
  • When processing sets of data such as updating or deleting multiple rows, these operations are executed on a separate statement, meaning the cursor remains open and is not discarded and recreated multiple times.

Other significant performance gains with the ADO Data Access Layer:

  • Three types of data caching to avoid multiple requests to SQL Server for the same data within a process.  This lowers CPU usage on the server by reducing the number of queries parsed, as well as reduces network traffic by eliminating repeated requests.
  • Parameterized Queries for frequently issued queries, reducing CPU usage on the server by allowing SQL Server to reuse the most effective query plan on multiple requests.
  • Update statements only update changed columns, as compared to updating every column in the table regardless of whether it was changed as was the case in the 3.7x product.
  • Efficient retrieval of related data during report process, greatly reducing the number of queries issued to SQL server.
  • Bulk insert for creating report worktables, for extremely fast inserts.

I hope this inspires you to check it out for yourself and gives you a good feel for the significant improvements that we have made in the approach and implementation of Sage ERP MAS 200 SQL.  You may also be interested in my previous blog entry on Sage ERP MAS 200 SQL if you haven’t seen it already.

Thank you for your time.

Steve Malmgren

Chief Architect, MAS 90 and 200


Jim Woodhead

DSD Business Systems

Share

Yesterday on our internal Socialcast network the question of how to move the PR Paperless Forms came up.  In the Paperless Office Module, there is a viewer for Registers & Journals, Reports, Period End Reports, Customer Documents, and for Vendor Documents, but for PR there is just the Employee Self Service viewer.

image

In order to view the employee documents using Employee Self Service you have to enter (not lookup) the employee number, social security number, and password. And once you’re in the normal options to move documents in Paperless Office are unavailable.

SNAGHTML777ee99

So what are we to do when we have to move the MAS 90 or 200 install to another location or even another server?

Answer:

In the Payroll | Direct Deposit menu, there is the Paperless Office Stub Viewer.

direct_deposit_viewer

Once you select the forms you need to move (and don’t forget to update the dates and click Refresh), you can then click the move button (circled in red above) and select the new file location just as you would with any of the other Paperless Office viewer

If you have any questions about this please contact our support team.

Jim Woodhead

DSD Business Systems

Share
© 2010 DSDtips.com Suffusion WordPress theme by Sayontan Sinha