accounts payable | Schulz Consulting

Unable to change Bank Codes for custom Form Code in Accounts Payable Check and Electronic Payment Processing in Sage 100 2020

October 23, 2020 by Wayne Schulz

Users of Sage 100 2020 have noticed a pesky bug which may stop them from using multiple bank codes with the same Accounts Payable check form.

Selecting a bank code – other than default – was not possible in Sage 100 2020. A fix was expected for the first product update however that fix somehow missed the update release.

Now Sage has published a separate hotfix which can be downloaded and applied to Sage 100cloud 2020 to resolve this issue.

Sage will also incorporate this fix into Sage 100 2020 Product Update 2

For more information refer to this Sage KB entry.

Here’s One Way To Pay Sage 100 Accounts Payable Invoices By Credit Card

May 26, 2016 by Wayne Schulz

Yesterday the question of how to pay off accounts payable invoices by credit card was asked in my 90 Minds group.

While Sage 100 allows vendors to be marked as credit card vendors and facilitates a way to allocate the amount paid from the credit card payment the process can be a little cumbersome.

Enter Zevez. This integration, which can be free initially (about $1,500 yearly after the first year) to certain American Express cardholders, automatically generates payment vouchers which an be used to advise vendors to charge a credit card for the specified amount.

The Zevez solution works with nearly all versions of Sage 100 (reportedly up to version 2016) and generates a data file which Sage 100 Visual Integrator uses to record the proper account for credit card vendors.

From the Zevez website:

RewardWorks software integrates with your existing software to improve your Accounts Payable system. Now you can process, pay, post and reconcile invoices using a credit card instead of a check. RewardWorks enables you to make hundreds of invoice payments on your card with just a few clicks.

Call Zevez for a customized report to identify which vendors you can pay by card, and see how much your company can earn with RewardWorks.

RewardWorks is visual, intuitive and easy to learn. Our training plan will ensure that your accounts payable staff is comfortable using RewardWorks so you can begin paying invoices by card. To get you started, Zevez will provide you with a detailed list of your vendors that accept cards. RewardWorks manages vendor acceptance terms, invoices and card information all within a completely secure environment.

Behind your secure firewall, RewardWorks safely communicates with your accounting system to present invoices for payment that have already been entered, so no additional data entry is required. Invoices paid in RewardWorks are immediately updated in your accounting system, maintaining vendor identity, audit ability and accounting system integrity.Our dramatically improved payment posting and reconciliation experience gives accounting control of the card payment process.

Vendor Reports
A Vendor Report is a great way to know which of your vendors already accept credit cards and how much you could earn in reward points just by using your credit card to pay some of your bills. Vendor Reports can be a stand alone product to tell you which vendors you could pay using a card or you can use it to jump start your RW software usage. Large volume vendors are called directly and presented in a detailed, customized report. Other vendors are matched to a large database we have. The report can give you an idea of what overall charge volume potential you have in your current accounts payable.

RewardWorks integrates with accounts payable software to help track and batch credit card payments. It makes it easy to earn lots of reward points by using your credit card to pay for accounts payable. Combining a Vendor Report with RewardWorks software will help you earn the most reward points faster.

For more information contact us.

How To Reprint The Data From A Sage 100 ERP Accounts Payable Check Stub?

January 9, 2013 by Wayne Schulz

Have you ever printed an accounts payable check and for whatever reason the detail on the stub which shows the invoices paid is missing?

When printing accounts payable checks there is a field labeled “Stub Lines”

I have seen instances where setting this number TOO HIGH can cause a check to print with incomplete/partial invoice listings.

The resolution is generally to reduce the Stub Lines number to be the actual # of lines that can fit on that check. Also, remember that both stubs of the check may have different amounts of space for invoice listing depending upon whether customization’s have made to your check layout. In those cases select the # of lines which is the SMALLEST # which fits on either of the stub in order to prevent losing invoice details.

Unfortunately re-printing check stubs is not possible however you may wish to use the Payments History Report from the Accounts Payable – Reports menu or the Trial Balance report on the same menu. Both of these standard Sage 100 ERP (fka MAS90 or MAS200) reports will show the check invoice detail.

The bank code ‘N’ is not approved for electronic payment. You must setup this bank code for electronic payment in ACH Interface Maintenance or select another bank code

September 4, 2012 by Wayne Schulz

Version(s):4.4+

Problem / Description:

When going into the Check Printing and Electronic Payment screen for a bank code that does not transmit ACH (not pre-authorized) and select “BOTH” (check and electronic) and immediately receive

“The bank code ‘N’ is not approved for electronic payment. You must setup this bank code for electronic payment in ACH Interface Maintenance or select another bank code.

This situation can arise because the customer has multiple bank accounts – some of which are used for ACH and others for pure check writing (no ACH). Vendors can be setup to have ACH through one bank account and checks through another. The solution occurs during the invoice payment selection (See below).

Resolution:

During invoice payment selection you need to check off the “Pay Electronic Payment Vendors by Check”

AND

When you go intoCheck Printing and Electronic Payment to print the checks be sure to select “CHECKS” when asked how you want to pay. Don’t select “ACH” or “BOTH” or you’ll get the error message if the bank account is not approved for ACH.

ACH Electronic Payments Processing For Sage 100 ERP

April 24, 2012 by Wayne Schulz

My friend and 90 Minds colleague Ed Wlodarczyk of Jacksonville Florida based Ennis, Pellum & Associates has a nice post that documents the steps users of Sage 100 ERP can take in order to send ACH electronic payments from within their accounting software.

Increase your efficiencies, improve your cash management, reduce operating costs and lessen the risk of lost or stolen checks by paying vendors electronically using an ACH file created from the Accounts Payable module. Enable ACH electronic payments, define how they will be handled by your company, and the type of information that will be transmitted to your financial institution.

You have the flexibility to select and set up one or more financial institution(s) for your electronic payments, and for each one you select, define the format and layout of the ACH file. The feature includes pre-note functionality, and flexibility in your electronic payment distribution, including options to allocate amounts between one or more accounts.

ACH information on processed payments, historical information and vendors paid electronically is available on AP Reports. They can include auto checks, manual checks, voided checks, reversals, credit card transfers, electronic payments, wire transfer information in any combination.

This enhancement was added to version 4.4 Product Update 2 as an incorporation of the prior Sage Extended Solution AP-1063. There is no additional cost to use the feature , including creating the transmission file, as it’s included as part of the base program.

Sending electronic payments is a great timesaver for any company issuing many expense checks to remote employees and for situations where vendors request ACH payment.

For more details head to Ed’s Blog

Contact Us