Posts

Sage 100 – Credit Card Processing For Accounts Receivable And Sales Orders

Question:

Mike, We own Sage 100 Accounts Receivable and Sales Order, we would like to use Credit Card Processing, is that possible?

Answer:

Yes Sage 100 Accounts Receivable and Sales Order Modules are fully integrated with several payment processors and transactions can be integrated through Accounts Receivable Cash Receipt Entry and Sales Order Entry without having to go outside the Sage 100 Accounting System.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100  system.

Optimize Cash Flow and Get Paid Faster

Sage 100 integrates with Paya, formerly Sage Payment Solutions, to process credit and debit card receivables quickly and conveniently?  Look at all the benefits of adding payments to your Sage ERP!

  • Accept all major credit and debit cards as well as PIN debit and signature debit transactions.
  • Securely store bank and credit card information in the Paya vault—not your software (simplifies PCI compliance).
  • Access the data you want whenever you need it.
  • Reduce the risk of theft, credit card fraud, and legal action with strict adherence to the highest industry standards.

About Paya
Paya was the first – and remains the best – Sage 100 direct integration, with easy onboarding and a powerful, user-friendly payments interface.
Paya offers industry leading payments solutions that can be tailored to meet the needs of any business. A provider of exceptional business solutions and customer experiences, Paya delivers future-proof value and flexibility for growth.
Let Paya handle the movement of transaction data automatically. Consolidate, control, and reconcile all internal and external payment sources in real time. For more information, visit https://paya.com/ or follow us on Twitter: @PayaHQ, LinkedIn: Paya.com and Facebook: PayaHQ.

Happy Holiday Scam – son (Season)

Unfortunately, scammers to do not take off for the holiday season.  In fact, it appears the scams increase!  Last week a scam surfaced around the country.  A number of bomb scares were reported requesting a bit coin payment.  Since none of the “bomb” were detonated, this appears to have been just a scam.

Bomb scares are not the only scams during the season.  Just in the last few days I received a phone call from someone that reported they were receiving information about my business computer having problems.  I was too busy to play with them, so I did the right thing and just hung up.  Other companies that you have no relationship with are not getting information about your computer.

Also, with tax season being just around the corner, the IRS does not notify you of any tax problems with a phone call.  They ALWAYS send a letter in the US mail.

The only institutions that may call, email or text you are your bank and credit card companies.  Normally you will only receive these notifications if you sign up for them.  Just to be extra cautious, do not reply to the notification, but call your bank or credit card company via the number on your statement or their website.  If it is a legitimate concern, they will forward you to the correct person to resolve your issue.

Again, if you get an unsolicited phone call about any computer issues, just hang up.  The same goes for tax issues.  If you get a strange pop up on your computer, shut it down immediately.  If it will not let up shut down your computer, unplug it! and contact your IT department or a computer professional.

Unfortunately, the holiday season is a busy time for scammers.  Don’t let the business of the season allow you to let down your guard.  Happy Holidays and be careful!

 

 

 

 

 

 

Keeping Your Software Up To Date

Most software companies will support old versions of their software for a limited amount of time.  Sage, our main vendor, only supports two prior versions of their software for Sage 300.  A new version of Sage 300 comes out just about every year.  This is not uncommon as most software vendors have a similar policy.  Therefore, when Sage releases the 2019 version they will soon thereafter discontinue support for the 2016 version.  Old unsupported versions will most likely still work fine in the short term, but they come with a risk.

Recently one of our clients was hit by a virus.  Fortunately they have good backups and were able to mitigate the damage.  They decided to update their server and all of their workstations.  Support for their accounting software had stopped a few years back due to changes by Microsoft.  When they installed all the new hardware they encountered a number of issues with the old software.  They now are facing an unplanned upgrade.   They were perfectly happy with the old software, but there is always the risk that it will not run properly with new hardware.

Now we do not recommend that you always have to upgrade to the latest version and we continue to support old software even when it no longer supported by the vendor, but we are limited in what we can do.  Technology changes quickly and we do not want to hold a company back from using newer, faster and easier computer equipment and software, because they have an old accounting or ERP system.  If you are currently using unsupported software we recommend replacing it as soon as possible.  Definitely within the next year or two.

What you will find out when purchasing a new system is that many software companies are moving to a selling on a subscription basis.  This will significantly reduce the first year cost of the software, but future years many have a larger cost.  This is the way that Sage now sells most of its products and it is the way they sell Sage 300.  Interestingly, the future yearly subscription price is about the same as the old annual maintenance fee.  There is an activation fee in the first year and of course the cost of setting up the software, moving data and training users. We have not found a client that would pay more under the new pricing plan than if they were to purchase the software under the old method and keep paying for their annual maintenance.

The moral of the story is you can either plan to upgrade your software or wait for a disaster and be forced to upgrade.  We prefer working planned updates.  It is less stressful for you and easier too!

WAC – Sage Webcast Series Avalara: Automating Sales Tax and Certificate Compliance

From the specialized tax research necessary to maintain rates and taxability, to shifting jurisdictional boundaries, to evolving payment and filing requirements to even resale certificate management, the apparent costs and complexities of sales and use tax compliance are easy to spot. However, cutting-edge technologies and superior processing logic help manage the most complicated tax issues, such as situs, nexus, tax tiers, tax holidays, exemption certificate management and product taxability rules.

Join us on 7/26/18 at 1 p.m. ET as we identify the dangers and explore and opportunity to improve processes and reduce tax compliance risk with sales tax automation. By attending this webinar you’ll learn how:

• Avalara enhances sales tax functionality
• Exemption certificates work and why they are important
• Easy it is to manage and report on tax with Avalara
• AvaTax product solution set works (demo)
Sign up here:

 

 

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

Abila MIP Fund Accounting™ Consultant Success Story with CVEP

October 26, 2017/in Abila MIP Fund Accounting™, Non Profit /by Mike Renner

Coachella Valley Economic Partnership (CVEP) is a nonprofit economic vitality organization devoted to attracting, retaining and expanding business and developing a high-skilled workforce to enhance the economy and quality of life in the region.

Albia consultant nonprofit MIP.pngWAC Solution Partners Greater Los Angeles – 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 that embraced persistence, partnership and always working with and looking out for our customers best interest.

We are very involved with the Coachella Valley business community. In 2014, a local CPA named Kelli Cox, was working with CVEP on their financial statements. CVEP had laid off their Controller. Kelli didn’t have time to do many of the accounting tasks they were requiring. She knew we were Abila MIP Fund Accounting™ Certified Consultants and brought us in to meet with Lesa Bodnar, Chief of Staff of CVEP.

Kelli recommended us to take over many of the accounting tasks due to our knowledge and expertise. CVEP also wanted additional training on Abila MIP Fund Accounting™ software for their staff. Mike Renner trained the staff on General Ledger, Accounts Payable and Accounts Receivable. Laurie Renner went onsite weekly to work on the Abila MIP Fund Accounting™  software, to make accounting entries and at the end of the month reconciled their bank statements. She also worked with Kelli to make sure the financial statements and board reports were ready for the board meetings. Laurie has been working with this client ever since. It’s an ongoing success story for 3 years now.

Some of the comments from the Chief of Staff – Lesa Bodnar are:

Costly Ghosts and Zombies in Your Business

Costly Ghosts and Zombies in Your Business
by Gary Maher, Sage Partner Account Manager

October is a great month to do something about your Ghost and Zombie Assets. After all what’s scarier than a ghost and zombie other than a ghost and zombie that are stealing money from you?

Okay, well maybe they are not stealing it, but they are costing you money you don’t need to spend (or will cost you money). So what makes them this frightening?

“Ghost Assets” are those assets that are currently on your books, but are no longer in service. Think of items that have been disposed of, misplaced, lost, stolen or damaged as some of the most popular Ghost Assets that are nowhere to be found in your actual inventory. You threw that computer or phone away but “Boo” they are still on the books.

These can be quite prevalent in most organizations as the average company’s inventory is comprised of 15%-30% ghost assets. For example, if you have $2 million in depreciable fixed assets and 15% of that is ghost assets (taking the low end of the range), then you are listing $300,000 in assets that don’t exist. Again, assuming average tax rates and depreciation, these ghost assets are costing your organization more than $50,000 in tax overpayments each year! Those are expensive ghosts! Of course, eliminating them may make you feel like a superhero.

On the opposite side, are the “Zombie Assets”. A zombie asset can be found during your physical audit, however it is nowhere to be found on the fixed assets register. Tracking these zombie assets brings value back to your company and protects you from fines for under reporting (think how scary an actual audit would be in this scenario). Generally, each company has Zombie Assets equal to 12% of their inventory just walking around lifeless. Thus in the value of ghosts vs. zombies, the ghosts win but they are both hurting your organization. In fact, utilizing the industry averages it may be frightening to realize that almost 40% or more of your organization’s assets can be classified this way.

So how can you ensure you are compliance but not paying more than you owe?

Automation is the key. Spreadsheets and manual methods won’t work beyond a few assets and help create ghosts and zombies by being inefficient. Automation tools, such as Sage Fixed Assets, enable more complete and organized physical audits, which are essential to knowing which assets are where. Of course, having better ongoing methods for tracking assets as they are added or disposed of helps as well.

In short, tools such as Sage Fixed Assets are smart investments and pay for themselves rapidly, not only in saved taxes and greater efficiencies (see for yourself with this easy to use ROI calculator: http://go.sage.com/SFA_ROICalculator), but in piece of mind. Here’s another scary fact, did you know there are over 300,000 GAAP and IRS rules and regulations for depreciation calculations? Sage Fixed Assets does, and keeps up with them for you protecting you from audit horror stories.

Whatever method you choose, make sure to make this Halloween a little less frightening by eliminating the ghost and zombie assets in your organization. For more information on how Sage Fixed Assets can help check https://www.sage.com/en-us/products/sage-fixed-assets/ or feel free to email me at gary.maher@sage.com.

Happy zombie hunting and ghost busting!

 

 

Sage 100 – How do I Change the Paperless Office PDF Location?

Question:  Mike, we have changed the location of our Paperless Office for Sage 100 to a new server. We are having trouble finding out how to change the Paperless Office PDF’s Location.  Can you help?

Answer: There are steps and several mini steps to change the PDF location in Sage 100 Paperless Office. Here’s how…

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 and we are available to help.

STEP 1 –  Change the path for future reports:

• Open Paperless Office, Setup, Journal and Register Maintenance
• Click Report Entries (Flashlight button) Select the setting desired to change from the Report List and click Select.
Note: This is a list of previously configured settings.
• In the PDF Directory field, browse to the new location for PDF storage
• Click Accept.
• Repeat for each Maintenance task and Company Code, if desired

STEP 2 – Use Link Maintenance to Re-Link or Move Reports

• Open Library Master, Utilities, Link Maintenance
• Select the Link Type to change (Forms, Journals/Registers, Reports)
• Select a Company Code and Module code or select ALL for each
• Click Refresh and documents matching your criteria are displayed
NOTE: This interface can have a long loading time for high document counts. It will take about 30 seconds per 10,000 records
NOTE: This interface can handle a maximum of 100,000 records. If there are more than 100,000 records for one time, the Viewer will have to be used to re-link the records using the date filter which Link Maintenance does not have. It is recommended that PDF’s are purged regularly as well if this number exceeds 75,000 records (Paperless Office, Utilities, Purge PDF Documents)

• Hold the Shift or CTRL key while clicking so select multiple records
• Click the Relink button to change the path, The Relink Button looks like a chain.

• A “Path” box appears – type the new path for the pdf documents and click Accept

• A message will appear if the PDF documents are not located in the new folder. You can still accept and Re-link if the PDF’s are not there.

NOTE: The PDF’s themselves can be moved before or after the Re-link process. You can move the them with Windows Copy and Paste, Once the path can see the PDF in the directory, it will go from Red to Black to

NOTE: If PDF’s are reachable (Not Broken Links), you can use the “Move” button to move the PDF and change the Link simultaneously. If this option if chosen, make a backup of the PDF documents themselves prior to doing the move using Link Maintenance.

STEP 3: Move Reports Using the Viewer

(To do this, there must at least one entry in Black that can be located. If all paths are in Red, the move button will be unavailable):

• Open Paperless Office, Main, Report Viewer
• Select Company and Module Codes or ALL. The reports will display in the list area
• Select the reports to be moved
Note: Press CTRL or SHIFT when clicking to select multiple reports.
• Click the Move button (yellow bar with the right arrow).
• Browse to New Location then Click OK
• Click Yes
• A dialog box opens indicating the number of PDF documents moved. Click OK

NOTE: This method should only be used if Link Maintenance is not an option due to large datasets.

Written by Mike Renner, Partner at WAC Solution Partners – Greater Los Angeles

Mike is an 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 and Acumatica. Please contact us at 760-618-1395 if you have questions.

Specialties

Sage 100 ERP (formerly Sage MAS90 / MAS200), Abila MIP Fund Accounting™, Acumatica, QuickBooks Pro Advisor

Tags: Sage 100 Consultant, Sage 100 Accounts Receivable

Please note: This is a repost of a blog that was written for ERPVAR.com, the original blog can be found below.

ORIGINAL ERPVAR.com blog