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!

 

 

 

 

 

 

Sage 100, How to add Vacation and Sick Accruals to Payroll Check on Sage 100 2018 and higher

Question: Mike, we own Sage 100 (formerly MAS90) we recenty upgraded to version 2018 and we previously had version 2015 in the old non Crystal version of check form, all the Vacation, Sick and PTO fields were lost, how can we get them back onto the new Check form.

Answer: This is 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.

  1. The Payroll Module Database in version 2018 has been changed from previous versions, the Vacation Sick and PTO fields were changed and they are now named TimeOff1, TimeOff2, TimeOff3. They are named HoursAccrued, UsedHours, AnnualLimitHours, AvailableHours for each of the 3 type of Accrual. You can see a picture of the Crystal Reports Field Explorer  below that will show each of the fields.

 

2. In addition there is a new version of Crystal Report that is included with Sage 100 version 2018, Crystal 2016 and it needs to be installed so you can edit the new forms, the Payroll forms were completely rebuilt by Sage, as well as Sage Support does not support Modifications to the out of the box forms, so these instruction will help you modify the form and add the Accrual fields that to the Crystal Report. You can see a picture of the Plain from which you can start with. Click the form button from the Print Checks screen Modules>Payroll>Main>Print Checks and the Crystal Report will open.

3. Next what you need to do is drag the bottom line down from the Group Footer #2 to allow enough space to the insert the Accrual Fields, this is located just below the Net Earnings, the out of  the box form from Sage does not include the accrual fields so this is a customization. You will also want to reposition all the existing fields to the bottom, and then you can open the Crystal  field explorer and drag and drop the acrual fields into position as well as you can add text titles. You will need to play with this and it is mostly trial and error to get it printing in the right place. In addition you will need to reduce the stub lines on the check printing. You can also suppress the fields in Crystal and move fields that are out of position. This blog is just to give you the general idea of how to modify this form and not teach you all the details of Crystal Reports design.

 

 

 

 

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:

 

 

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

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.

 

​​

Acumatica Cloud ERP Best of Summit Anaheim wrap-up and comments

Acumatica Cloud ERP Best of Summit Anaheim wrap-up

On April 26, 2018 we had the chance to spend some time with the leaders of Acumatica Cloud ERP at their Best of Summit Anaheim event.

This was an Acumatica Customer, Partner and Potential Customer event. We learned about the new features and enhancement to the new Acumatica 2018 R1 version, heard from customers that had very interesting stories of coming off very old systems and implementing Acumatica Cloud ERP. Some very long-term customers and some just recently making the decision to move forward.

Acumatica Cloud ERP now has over 4,000 customers and is continuing to gain much momentum in the ERP space. We look forward to hearing more and please stay tuned. The upcoming 2019 Acumatica Summit will be in Houston Jan 27th though Feb 1st at the Houston Marriott Marquis.

We hope this was helpful. We are very excited about Acumatica Cloud ERP . If you have any questions, please contact us, call 760-618-1395 or email us at info@caserv.com and we will be happy to help.

 

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.

TPAC 2018

This past February was the Third-Party Advantage Conference (TPAC) held in Vancouver, British Colombia, Canada. I had the opportunity to visit this beautiful city and participate in the conference that brings together a great group of products and people on the Sage 300 ERP platform. Sage Business Partners, Development Partners, and customers from all over the globe were in attendance to discover what products are available on the market to enhance an end user’s Sage 300 experience.

I was in Vancouver the week before TPAC to attend a pre-conference training session for AutoSimply, one of the featured third-party exhibitors at the conference. The two-day training session discussed how to utilize the Manufacturing Order Module (version 2018) within Sage 300. The Manufacturing Order Module allows end users to create Bills Of Material (BOMs), manufacturing order entries, returns, and receipts. Other modules that were discussed, which can be added to Sage 300 in addition to the Manufacturing Order Module, includes Manufacturing Lots for lot control operations; Production Planning for budgeting and forecasting; and Shop Floor Control for tracking manufacturing operations such as runtime and operation downtime. AutoSimply also discussed their Inventory Barcode Manufacturing product which allows end users to scan compatible barcodes and automatically upload the information to their Sage 300 ERP. End users can also create Purchase Order (PO) Receipts, PO Returns, Order Entry (OE) Shipments and OE Returns from their handheld barcode scanning device.

At the end of the two-day AutoSimply training session, I was awarded a Certificate of Completion from AutoSimply.

I also attended a conference session regarding new features coming to the next version of Sage Alerts & Workflow led by Donald Farber of Vineyardsoft, a developer of the product. The next version of Sage Alerts & Workflow will be web based for convenient user access along with modern web screen designs.

Sage Alerts & Workflow is a query reporting software that notifies end users of events that users without Sage Alerts could only “wish they had known sooner.” These events include lists of: customers with open invoices due over ‘x’ days ago; customers whose credit cards expire next month; open sales orders that have not been shipped yet and are past the expected ship date; orders that have been shipped to the customer but have not been invoiced, etc. These reports can be set to automatically run on certain time intervals such as “Daily at 9am” or “Every 4th Friday of the Month,” and sent via email, text, or fax to persons of different departments and management levels internally and externally according to a business’ needs. Sage Alerts & Workflow is a great tool for users to keep track of their business from all angles.

Overall, TPAC 2018 was a successful and enlightening event to attend, to forge new relationships and learn about different products that operate alongside Sage 300. I look forward to attending again next year!