Posts

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.

Measuring Success…What do you Measure?

 

Every so often I decide that I need to get my diet under control.  The first thing I do is start recording what I eat in a food diary.  Why?  Because our goals are more achievable when we measure the steps that get us there.  Over the next month or so let’s look at some ways we can measure our HR and Payroll performance.

One standard measurement in Human Resources is TURNOVER.  This is where you divide the number of terminating employees for the period by the total number of employees in the organization.  But this number alone might not tell the whole story.  Here are some additional ways to look at turnover:

EARLY TURNOVER:  This looks at the number of recruits leaving in their first year divided by the number of recruits hired in the period.

REGRETTED LOSS:  Regrettable turnover is when an employee’s departure from a company has a negative impact on the team or organization.  The measurement is the number of employees who left the company but who the company had planned to retain divided by the total number of terminations.

NON-REGRETTABLE TERMINATION RATE:  Employees who left the company, but their leaving had no appreciable effect on the company.

CONTROLLABLE SEPARATION RATE:  Employees who left for a reason that the company might have been able to address if they had been aware of it.

UNCONTROLLABLE SEPARATION RATE:  Employees who left for a reason that the company could not possibly control, even if they had been aware.  This measurement would include death, military service, plant closure, etc.

Some of these statistics are readily available.  Others may require you to review the way you currently classify the terminations in your HR System.  Once you start tracking them, however, you will be able to see where you need to focus your attention.

 

​​

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 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.

Sage 100 Success Story with Mervin Manufacturing Snowboards

WAC Solution Partners Helping Businesses to Grow Effectively

 

As providers of accounting software, implementation and support, we offer a wide range of solutions designed to fit businesses and non-profits of all sizes. Our combination of products and services allow you to better manage your accounting and to make insightful decisions about your company’s future.

EXPERTISE WITH LOCAL ROOTS AND NATIONAL REACH

This is a success story about a very fun customer Mervin Manufacturing that we began working with in 1989. It was a great partnership.

Mervin Manufacturing is home to Lib Tech, GNU, Roxy and Bent Metal Bindings and is a leading designer and manufacture of snowboarding products. We began working with Mervin Manufacturing in 1989 when they were just a 10-year-old company.

They were looking for a partner to help them grow their business to the next level. Our company provides small business bookkeeping services as well as Accounting Software system sales, implementation, support and training.

They originally called us because we were close to their Seattle office, initially it was a box of checks. The project was to reconcile their bank accounts and do monthly financial statements for them, we did all the accounting on our system.  We also did their accounts payable and payroll.

As the company grew further they asked us to provide an in-house accounting system and computer network system. We sourced an IT company for the computers and sold them Sage 100 (Formally MAS 90). Their original customer base was on an Apple Macintosh that we helped them bring over to the new Sage 100 (Formally MAS 90) system.

This was a phased in training and implementation, first the financial modules including General Ledger, Accounts Payable, Accounts Receivable and Payroll. And then the distribution modules which included Inventory, Sales Order and Purchase Order.

We trained the customer staff from the ground up as they had never had much experience with Sage 100 (Formally MAS 90) or other accounting systems.

Upon completion of the Software Implementation we continuing as their outsourced accounting company. We provided monthly financial statements, did their payroll for them, closed all the accounting and distribution modules monthly. We remained their accounting company for over 10 years.

Eventually Mervin Manufacturing was sold to Quiksilver and in recent years the company was repurchased and now operates as an independent standalone company under Altamont. They are home to many snowboard enthusiasts and many Olympic snowboard athletes.

Review of Sage Sessions in Los Angeles, February 13, 2018.

It was my pleasure to attend the first Sage Sessions at the Los Angeles Westin Bonaventure. This was the first of 10 Sage North America events. 6 US cities and 4 Canadian cities.
The single day events focus was on Sage partners, customers and solutions, with powerful keynotes, networking opportunities, product demos, and more. These events replaced the previous mega conferences called Sage Summit located in one city over a week-long period.
SageSessions was a fun informative breath of fresh air from our perspective as a longtime Sage Business Partner. It was close in Los Angeles, so we had the chance to invite many of our local customers in the Southern California area and being only one day it was very easy to attend.
The hosts from Sage were Dave Faupel @davezamazing VP Field Marketing, and Nancy Harris @SageNancyHarris Managing Director Sage North America @SageNAmerica. The opening message from Nancy was “We are all about customers and we are interested in your success.” We loved that message.
The keynote was John Garrett @RecoveringCPA, TheRecoveringCPA.com. John gave an incredible talk about being relatable and real and “Don’t let your professionalism suffocate your personality. After the initial keynotes there were technical content and business development sessions focused on real issues customers are facing in todays world as well as several updates on new Sage Products.
One of the sessions I attended and really loved was Sage 100c tips and tricks done by Johnnie Woodward @JohnnieWoodward ‏ Sage Field Sales Engineer – Sage 100 & Sage CRM from Sage. There were several new features presented that most people in the room could really benefit from.
There was a section of the conference dedicated to product demos from many of the sponsors, Sage and ISV’s that provide a wealth of information to our customers.
All in all, SageSessions was an absolute great investment of our and our customers time.
A list of upcoming sessions scheduled at this time:

Chicago, IL April 24
Location
Hyatt Regency Chicago
151 E Wacker Dr.
Chicago, IL 60601

Toronto, ON May 8
Location
Westin Toronto
One Harbour Square
Toronto, ON M5J 1A6

Austin, TX May

Atlanta, GA June

Montreal, QC June 26
Location
Hyatt Regency Montreal
1255 Jeanne Mance St.
Montreal, QC H5B 1E5

Edmonton, AB July

New York, NY July

Seattle, WA August 7
Location
Hilton Bellevue
300 112th Avenue SE
Bellevue, WA 98004

 

Vancouver, BC
September

Registration and Detailed Information

 

 

Registration and Detailed Information

Sage 100 Consultant Tip: Paperless Office Won’t Print

Sage 100 ERP consultant, we had a client who had a technical issue with Paperless Office hanging up. Do you know how to stop this from happening?

NOTE: Consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100 ERP system.

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

Answer: Here’s what to do when Paperless Office hangs up…

1)  Check permissions on Sage PDF Converter:

Run, Regedit

Sage 100 ERP consultant paperless office

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

Sage 100 ERP consultant paperless office 2

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.

Sage 100 ERP consultant paperless office 3

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.

If you have questions please contact us at www.caserv.comemail or 760-618-1395. Please stay tuned for more helpful Sage 100 ERP tips!

Sage 100 ERP (MAS 90): How to Create a Receipt of Goods Entry

Question: We own Sage 100 ERP (formerly Sage MAS90), we just added the Purchase Order and Inventory Management Modules. After we issue a Purchase Order and the goods are received, how do we make the Receipt of Goods Entry?

Answer: First, you will need to go to Modules > Purchase Order>Main>Receipt of Goods Entry. You will select a new entry by clicking on the # sign next to the Receipt number. Then you should select or type in the PO number.

Sage 100 ERP Purchase Order Blog resized 600

Second, if you have received the invoice with the shipment it can be entered into the Invoice number box, if not and you received the invoice at a later date you can then us Receipt of Invoice task at a later date.

Third, select the lines tab, the system will ask if you want to receive the entire order:

Sage 100 ERP Purchase Order 2 resized 600

Select yes if you have received the entire order, select no if you have received a partial shipment and would like to leave the Purchase order open.

Sage 100 ERP Purchase Order 3 resized 600

Fourth, we selected yes in the example. Quantities can also be adjusted at this point. If you have Lot or Serial Number inventory items they will show as a yellow ! at the left of the item code and they must distributed using the Lot/Serial Distribution icon that is shaped like a grid.

Sage 100 ERP Purchase Order 4 resized 600

Fifth, once all distributions are made Accept and run the Daily Receipt Register and Update, this will adjust the Inventory quantities and be available for business use.

Sage 100 ERP Purchase Order 5 resized 600

 

Tax Cuts and Jobs Act

On December 22, 2017 President Trump signed the largest income tax change in thirty years.

It is a complex bill with many changes, but for the most part taxpayers will be paying less taxes in 2018. With 3 simple examples I shall try to demonstrate the impact this new law may have on your own situation.

A single person making $50K using the standard deduction will pay $5,638.50 in 2017. Compare that to $5,223.75 in 2018 – a savings of $414.75.

A married couple filing joint return using the standard deduction with no dependents will pay $11,277.25 in 2017. Compare that to $10,447.50 in 2018 – a savings of $829.75.

Finally, a married couple using the standard deduction with 2 dependents under 17 will pay $7,732.35 in 2017. Compare that to $6447.50 in 2018 – a saving of $1,284.85.

The driving factor behind the savings is the increase in the child tax credit as well as standard deduction.  Whereas currently about 70% of taxpayers use the standard deduction, the new tax law is expected to rise this number up to 95%. An impact on states with high property and income taxes is also anticipated since the new law also dictates the limit of itemized deductions for state and local taxes for not to exceed $10K.

Ultimately, this article only covers the impact of the individual tax changes, the corporate changes are much more dramatic. Please consult a tax professional for more complete information.

Written by Michael Ericksen, WAC Solution Partners- Midwest