Sage Fixed Assets Version 2018.1 Incompatibility Issue

We recently had a client that was on version 2016 of Sage 100, they also were on an older version of Sage Fixed Assets and needed to upgrade the Sage Fixed Assets to version 2018.1. Upon doing the upgrade they received the error “Unable to cast COM object…” in Sage 100, after install the Sage Fixed Assets Client 2018.1.

So, what is the cause of this and how can it be resolved?

The cause of this “Unable to cast COM object…” error lies in the Crystal Reports runtime version (SP21) which is installed with FAS 2018.1, SP21 is not compatible with Sage 100 versions 2017 versions and earlier.

To start with replace existing pvxwin32.exe.config located in the “2016” installation of Sage 100 Standard …\mas90\home\ with a copy of the same file from Sage 100 Standard 2018. The pvxwin32.exe.config new file can be obtained from Sage 100 Support.

Then visit all the Workstations that have Sage 100 and install the FAS client, that is the fix.

In addition, Sage Support did a great job documenting the fixes for other scenarios with different versions of older and newer Sage 100. The Knowledge Base Link is here.

How to run Sage 100 Accounts Receivable Trial Balance and Aged Invoice Reports

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to run the Accounts Receivable Trial Balance and Aged Invoice Report.

Answer: The Sage 100 Accounts Receivable Trial Balance and Aged Invoice Reports are explained below:

Accounts Receivable Trial Balance Report:

This report is used to Balance against the Balance Sheet report. It is a detail by customer of all Invoices, Payments and Deposits. The report should be used to be show a customer what their balance owed to your company is. The report can print for Invoices Open, Paid or All.

The report can be accessed from Modules>Accounts Receivable>Accounts Receivable Trial Balance, you can set the parameters and then print or preview the report.

Accounts Receivable Aged Invoice Report:

This report is used to print balances owed by customer on invoices, it can be printed with each column being Current, 30 days, 60 days, 90 days and 120 days past due. It is really a report to determine collection and which customer to called for payment.

The report can be accessed from Modules>Accounts Receivable>Accounts Receivable Aged Invoice Report, you can set the parameters and then print or preview the report.

Sage 100 How to Stop Paperless Office Hangups

As a certified and experienced Sage 100 consultant, I wanted to share an experience we had with a client who had a technical issue with Paperless Office hanging up. This blog was originally posted in October of 2014 and we have dealt with this issue a few more times since then.

Question: We are a Sage 100 user, we are using the Paperless Office and the printer hangs up indefinitely.

Answer: What to do when Paperless Office hangs up?

1)  Check permissions on Sage PDF Converter:

Run, Regedit

Click on: HKEY_CURRENT_CONFIG, Software, Sage PDF Converter, right click select permissions and set full rights to everyone. Apply and OK.

2)  In Sage 100, File Run PL_AdvancedOptions_UI

3)  Uninstall Converter, then Install Converter.

4)  De-install Workstation Setup and then Re-Installed Workstation and run Update.

5)  Find Sage PDF Converter from printer properties, install Sage port if not there, on the security tab set full permissions to everyone. Apply and OK.

6)  Back to Sage 100, File Run PL_AdvancedOptions_UI and test Sage PDF printer.

This should solve the problem in most cases, Paperless Office printing is done on a machine by machine basis so it is necessary to check these steps on each machine.

Sage 100 – How to modify Standard Reports in Crystal

As a Sage 100 Certified Consultant we recently upgraded a customer from a very old version of MAS90 to Sage 100 and a new version. Previously they had many standard reports that were in DOS based screens that they liked. With the new versions of Sage all the Standard Reports are in Crystal Reports.

Our customer asked us how to modify some of the Standard Reports to make them more easier for their business purposes.

The answer to that question is contained below and we have attached some screenshots.

  1. In Sage 100 ERP, open the report task to be modified. In the example we did the Inventory Sales History Report.
  2. Click Save Down-Arrow, click Save As. Inventory_SalesReport2 as an example.
    Note: Sage recommends NOT customizing the STANDARD report setting.
  3. Enter desired Report Setting name and Description Inventory_SalesReport2 as an example.
  4. Select one of the following Types: 
    • Public
    • Private
    • Read-Only
  5. Select the Default Report check box if appropriate.
  6. Click the Designer button to open report in Crystal Reports. Click Yes to save Report Setting dialog box.
  7. Make the desired changes, click the Save button, and close Crystal Reports.
    Note: The .rpt file is saved in ..Mas90MAS_xxxReports<Inventory_SalesReport2> (xxx = company code).

Sage 100 How to Setup a Recurring Journal Entry

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to setup a Recurring Journal Entry.

Answer: The Sage 100 Recurring Journal Entry can be setup as explained below:

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100  system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us at info@caserv.com and we are available to help.

Steps are show below:

  • Essentially a Sage 100 Recurring Journal Entry is a monthly, quarterly, or some time frame that repeats for the same amount and the same General Ledger Account numbers. The Recurring Journal saves time, so you do not have to key in every month or period the same Journal Entry.
  • First go to Modules>General Ledger> Main>Recurring Journal Entry on the header select the Source Journal, Reference (Name of what you want to call the Journal), Cycle (Period that you would want to run such as MO for month or YR for year), Start and Stop Dates, and any Journal Comments that you want.

  • Go to the Lines Tab, set the Accounts, Debit and Credit amount that you want to use and any other comments for the lines and then Accept.
    • The steps above create essentially a template for the Journal that can be used over and over.
    • The next step is to run and post the journals, you can run one at a time or if you have many journals you run them all at once. Go to Modules>General Ledger> Main> Recurring Journal, select the correct General Ledger date that you want to run the Journals for, Print, and select the Source Journal, Cycle and Reference you want to use, in the example we just used Reference equal to DEPR, and then Proceed, this will create the Journal.

    • Then say Yes to Update the Recurring Journal.

    • You can then check and make sure the Journal correctly posted by reviewing Account Inquiry for one of the Journal Accounts as shown below.

Sage 100 How to copy a Custom Office task or screen to another user and company

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to copy a Custom Office task or screen to another user and company.

Answer: The Sage 100 Custom Office module can be copy as shown in the step outlined below.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100  system. If you don’t currently work with a Sage 100 consultant, contact us,

Steps are show below:

  • You should first determine the Customizer Panel that needs to be copied, in the example below we have a Custom Office modification on the Accounts Receivable Customer Maintenance task. First you will want to open that task by going to Accounts Receivable>Main>Customer Maintenance. You should then right click on the mouse, Panel Setting and Customizer.

  • From the Screen select the Company and Users you want to copy from the “Modify and Already Existing Panel” and click OK.

  • The Customizer Panel will open, and you can read the Panel Name on the top, in this case the name is “AR_CUSTOMER. M4L PMAIN. Then close the Customizer.

  • From the Module task select Customer Office>Customizer Selection.

  • Select [Customized Panels] Accounts Receivable> The User-Company that you want to copy. On the right side at the bottom click on the blue copy button.

  • This will open another screen, select either All Users or a specific user and the Company to Copy to and the Except.

  • You will see a final screen and that the Customizer has been copied, in the example ###-XYZ indicates All users and Company XYZ, you can check to the actual company and user and you will see that the screen has been copied.

4 Reasons You Should Consider Sage-Integrated Document Management

Organizations across all sorts of vertical markets have saved money and grown business by optimizing their Sage ERP with a document management and workflow solution integrated to Sage. The need to go paperless is not limited to a few verticals; it’s widespread!

You too could benefit from document management. With a Sage Endorsed document management solution such as DocLink, you’d no longer waste money on storage fees, shipping, or the cost to recreate lost documents. Think of how long it takes to approve the average invoice. For many, that approval process is tedious – you must wait on other employees without any visibility. Now think of using a mobile application to access, share, and even approve documents all from your phone. How could a solution like DocLink Mobile benefit your business?

Still, we recognize that the decision to ditch the paper can be hard for organizations. We understand that some are simply set in their ways! Perhaps you don’t even realize the business process bottlenecks paper is causing or the unseen cost of manual processes in the workplace.

Read below for a quick look at four very common indicators that you too could benefit by going paperless:

1. If your company has two or more people working in the Accounting Department, you’re probably processing a good volume of invoices! Your approval process likely involves multiple steps and might not offer document visibility throughout. With automated workflow, approvals can be expedited and better managed. You can even delegate tasks to other employees (when you’ll be gone on vacation, for instance) so that business is never at a halt.

2. Does your company have more than one office location? What about remote employees? If so, you might be spending a fair sum of money moving paper between locations. You and your coworkers are probably familiar with the pain of not being able to easily access documents. By going paperless, you can eliminate unnecessary courier and postage expenses—and your employees can spend their time on more productive efforts.

3. If your company uses off-site storage facilities, you’re also spending funds that could be put to use elsewhere! Anyone familiar with the hectic process of pulling out those files will definitely appreciate the ease with which you can access and share documents in an electronic repository. Instead of waiting or asking for someone else’s help, employees can instead serve themselves and access files in your secure document repository.

4. If your company is in any sort of highly-regulated industry such as healthcare, food and beverage or manufacturing, you likely adhere to strict requirements related to the storage, access, and processing of files. This time-consuming process can be completely changed with workflow, output automation, and tight file security and history provided by integrated document management.

Do you fall under any of the categories above? Are you aware of different ways paper is bogging your company down? Join us on our upcoming educational webinar on a Sage-integrated document management solution, DocLink.

Join us for a webinar on May 17 at 1 p.m. ET (10 a.m. PT) to learn more about DocLink and see it live. See how DocLink can help you:

  • Eliminate paper-based bottlenecks like AP invoice approval
  • No more chasing down paper, view documents right within Sage
  • Allow users to retrieve supporting documents instantly and easily, on any device
  • Automate the delivery of documents and associated data to customers, vendors, partners
  • Increase control and visibility of transactions

Sage 100 How to create a credit memo in Sale Order Invoices

Question: In Sage 100 (formerly Sage MAS90) sales order invoice entry why and how do I create a credit memo?

Answer: Normally Credit memos are done to return something such as damaged goods or the wrong item was shipped to the customer. You would do it in Sale Order Invoice Entry because you want to take advantage of the Ship to Addresses that are in Sales Order.

First, you will need to make sure that the Open Item or Balance Forward flag in Account Receivable Options are set to Mixed, which will allow you to do Credit Memos in Sales Order Invoice Entry.

Second, select Sales Order>Main>Invoice Data Entry, select the Invoice number, Customer Number, Invoice Type select: Credit Memo.

Third, from the Apply to Invoice Number box you can lookup the Invoice to apply the Credit Memo to.

Forth, go to the line tab and enter in the items to be credited, make sure they are positive numbers and Accept.

Fifth, you can now Print the Credit Memo and Update the Daily Sales Reports/Updates.

Sage 100 How to Register Sage 100 Intelligence

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how the register Sage 100 Intelligence.

Answer: The Sage Intelligence Module enables you to do custom financial report and pull data from the General Ledger as well as other Modules, but it first needs to be registered.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100 ERP system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us at info@caserv.com and we are available to help.

Steps are show below:

STEP 1 – First open Sage 100 and Login and Open the Sage Intelligence Reporter License Manager.

Sage Intelligence>Setup>License Manager:

STEP 2 – You will be prompted to enter the UNC path to the Network Repository and click OK, if you are using a standalone computer you can us the following:

\\localhost\Sageintell\ where Sageintell was new folder that we created in the C:\Sage folder, if you have a Network you can just create and folder inside the MAS90 folder on the server and just point to it.

STEP 3 – Next Complete the License manager, this is always the one you need to remember, use the old account number if you were an old customer before Sage changed their customer number structure. So, obtain the Serial number from Sage Online and the account number is the number between the v and the _ in the serial number. Put that into Account Number.

STEP 4 – Next add the Serial Number: This is the one that starts with a v, make sure you make it a small v as we have used V the large one and Sage will fail the registration, so us the small v.

STEP 5 – Then click Apply in the top right-hand corner and then click Perform Registration, and it should come back with Registration complete with no errors.

STEP 6 – If you exit out go back into the License Manager then you should be able to see all the parameters of your licenses.

Sage Alerts & Workflow

Companies with systems that automatically monitor, assess, and report on data not only anticipate events before they happen, are more competitive, more proactive and more profitable. Learn more about the tools available to you to help you make more proactive decisions to benefit your organization and eliminate the phrase “if only we had known”.

Join us online for a Sage/WAC lunch and learn session on Thursday March 22, 2018 at 1 p.m. ET to discover the tools you need to become more data-driven, better manage your critical business activities and maintain great business relationships with your customers and vendors.

When you attend the webinar session, you will also learn more about:

  • The 8 types of business conditions you should be on the lookout for
  • How to be automatically alerts so that you can respond quickly to trends, exceptions, and anomalies.
  • How to automate tasks currently done manually (such as invoicing & statement delivery)
  • Quantifying your organization’s need for “business activity monitoring”

An Article that may help you understand what Sage Business Alerts can help you with in your business.

It’s What You Don’t Know That Can Hurt You

The author Mark Twain was once asked about his many business ventures – most of which had failed. Twain explained how his ventures had failed not because of bad technology (most of the items he invested in became very successful realities, but under different ownership), but rather had failed because he had not kept an eye on their progress. He summed up the lesson that he had learned as follows:

“Put all your eggs in one basket – and watch that basket.”
If anything, that phrase is truer today than it was 100 years ago – and it’s especially true regarding ERP applications. Organizations have vast quantities of information that they need to keep watch over; invoices coming due, stock running low, changing buying trends, and so on. What with corporate downsizing and fiscal belt-tightening, few – if any – organizations have the luxury to turn to an employee and say, “Hey you – it’s your job to keep an eye on our ERP data and if anything looks wrong, let me know.”

And so, your net result – like Mark Twain’s – is that you don’t watch over all the “eggs” in your ERP basket and bad things happen. You write off bad debt. You throw away expired inventory. Late deliveries become commonplace. And you lose some of your best customers.
This is exactly what Mark Twain was talking about; keeping watch over your investments (in your case, your ERP data). In Twain’s day, the “watcher” had to be himself; but in our day, we can automate the “watching process”. And that’s exactly what you should be doing if you wish to avoid the same kind of problems that Twain experienced.

“Automated watching and responding.” That’s what Twain was talking about. He needed to constantly monitor his business ventures. He needed to know immediately when something looked out-of-whack. He needed to know when “discoveries” should have pushed him in another direction. And he needed to watch over all his ventures equally well; his problem wasn’t that all his ventures were failures, but rather that he paid more attention to those that were doing well than those that weren’t.

You can apply these same concepts to the monitoring of your ERP data. Whether it’s receivables, inventory, manufacturing, or some other area of ERP, they all need equal “watching over”. And to do this today, you need a technology that embodies the same characteristics that Twain found lacking in his own approach to his prospective inventions:

  •  Focus. Invest in a technology that focuses on doing one thing: identifying and
    responding to business conditions in your business data. Business is increasingly
    complex today; you need to be able to identify sophisticated conditions (such as
    customers who have changed their buying habits) and then communicate those
    conditions in a wide variety of ways.
  •  Delivery. Twain was fortunate in that the methods of communications in his day were
    limited; today you must consider email, fax, cell phone, instant message, dashboard,
    and social network. Some information must be in quick one-line alerts, other must be
    delivered as analytical reports or standard forms and documents. It all comes down to the right information via the right people via the right device.
  •  Independence. Twain didn’t have one invention going at a time; he had multiple. Just
    like you don’t run your business just on your ERP system – you likely have a CRM
    system, an HR solution, and maybe a help desk application. You can’t play favorites
    when it comes to “watching” – a solution must monitor and respond to all your business
    applications, commercial as well as home-grown. And don’t forget incoming email – one
    of the top three sources of information coming into businesses today.
  • Integration. “Interoperability” is the key word of today when it comes to business
    applications like ERP, CRM, and HR. You must realize that sometimes the most critical conditions aren’t always represented by information in just one of your business
    applications – but rather in the combination of data between two or more applications.
    Invest in a “watching” solution that combines, analyzes, and responds to disparate data
    across your entire organization.

It’s interesting that 100 years after Mark Twain’s passing, we can still take lessons from him. Success – whether defined as the launch of an invention or defined as a productive ERP solution with well-managed customers, partners, and transactions – is dependent on your ability to watch over, identify, and respond to changing business conditions.