CLEAR PAID TODAY FLAGS IN AR OR AP IN SAGE 100

Have you ever tried to enter in a payment from a customer and found when entering the cash receipt that the invoice is not available for selection?  If you go back to the customer inquiry you see it on the account in the invoice tab but it’s not available during cash receipt.  Additionally, it’s similar in Accounts Payable when wanting to cut a check to pay an invoice it may not show up in the selection screen.  This is a common problem that users experience when they delete a Cash Receipt of if their computer crashes during check printing.  The cause of this is a PaymentsToday field in AR_ OpenInvoice or PaidToday field in AP_OpenInvoice that needs to be reset.

 

You can easily correct this by running the Library Master – Utilities -Reinitialize Data Files (this utility is used to erase and initialize individual data files. This Process is irreversible. This utility should ONLY be used under the direction of Customer Support Representative)

Make sure you do not have any open deposits, manual checks or invoices selected before running this utility.

For AR select the following tables:

  • AR_CashReceiptsDetail
  • AR_CashReceiptsHeader

 

For AP select the following tables:

  • AP_CheckDetail
  • AP_CheckHeader

 

 

If you do not want to update or remove what you have in cash receipts or check entry, there is a manual way to do it. You may use Data File Display and Maintenance to access the Open Invoice files, locate the invoice and manually reset the values.

  • In AR clear PaymentsToday field in AR_OpenInvoice
  • In AP set PaidToday field to ‘N’ in AP_OpenInvoice

If you have any other technical questions, visit our Sage 100 Tips and Tricks page! Are you interested in more support? Check out our support services here!


Solutions by Industry

What's New

The 5 Most Common ERP Objections

Making the decision to upgrade from a basic accounting software to a robust ERP system can come with challenges. Not everyone will be on board or open to the idea of change. Throughout our years in practice, we have found the following common objections to adopting a new software.  Read More

Submitted by Ally Donahue on Fri, 01/22/21 - 11:33

ERP Hierarchy of Needs

Maslow's Hierarchy of Needs a psychological concept that people are willing to fulfill basic needs before pursuing higher level needs. This theory was created in 1943 by Abraham Maslow. The five levels, physiological, safety, connection, esteem, and self-actualization are all components of what humans need. Just like we need these basic necessities, so does a company when implementing a new ERP system. All five levels in an ERP sense are vital to future system success. Below you will find a creative infographic highlighting the similarities of each human need to each ERP need. Read More

Submitted by Ally Donahue on Fri, 01/15/21 - 12:36

Why an ERP System Isn’t “One Size Fits All”

Have you seen the phrase, “One Size Fits All”, marked on different types of clothing? Most items labeled as such usually are very plain and have a standard size to accommodate most. Of course there are outliers and truly not everyone can fit in a one sized option. This is also true of  ERP systems; they cannot be “One Size Fits All” due to complexities. Read More

Submitted by Ally Donahue on Fri, 01/08/21 - 10:27

Whatever Your ERP Needs, We Have the Solution!

Or call us for a free consultation 866-379-3799