1 min read

Sage 100 Consultant Tip: Accounts Receivable Double Posted Payments

Sage 100 Consultant Tip: Accounts Receivable Double Posted Payments

Sage 100 Consultant Tip – 4 Steps to Adjust a Double Posted Payments on the Customer’s Accounts?

Sage 100 Consultant Question: Hi Mike, please advise, how do I adjust double posted payments on the customer’s account balance? 

Sage 100 Consultant Answer:  So, you can see my example, you have two payments on a customer for the same invoice 1234, the original invoice was $55.25 and it got paid twice through cash receipts so now has a credit balance on the invoice 1234 at bottom of AR Aging report -$55.25.

Sage 100 Tips and Tricks

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 and we are available to help. Sign up for more helpful Sage 100 consultant tips & tricks below! 

Sage 100 Consultant Tip: How to Easily 

STEP 1 - You want to do negative Cash Receipt posting of -$55.25.

Sage 100 consultant tip accounts receivable 1.png

STEP 2 - Accept negative amount, give it a check number as you can see:

Sage 100 consultant tip accounts receivable 2.png

STEP 3 - Then lines, and pull up invoice that is negative:

Sage 100 consultant tip accounts receivable 3.png

STEP 4 - Accept then post the cash receipts register, this time we ran AR trial balance and it will no longer be negative. And you can see all the postings.

Sage 100 consultant tip accounts receivable 4.png

Here are the postings below. Sage 100 consultant tip accounts receivable 5.png

Congratulations!  Now you know how to make a double entry on an account balance.

Check out other related Sage 100 Accounts Receivable Blogs: 

Written by Mike Renner:  Partner of WAC Solution Partners - Greater Los Angeles, a Sage 100 ERP consultant and support provider based in Indio, CA.

Mike is an expert on ERP and fund accounting and supports Abila Fund Accounting and 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.

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

How to Make a Sage 100 Credit Memo in Sales Order Invoice Entry

How to Make a Sage 100 Credit Memo in Sales Order Invoice Entry

Sage 100 Tips & Tricks - How to Process a Sage 100 Credit Memo in Sales Order Invoice Entry Back by popular demand, we're happy to review the 5 steps...

Read More
How to Email Invoices in Sage 100 Accounts Receivable Automatically

How to Email Invoices in Sage 100 Accounts Receivable Automatically

How Do I Email Invoices in Sage 100? 9 Steps to Set Up Automatic Electronic Delivery in Accounts Receivable? Sage 100 Question: Mike, how can I...

Read More
Sage 100 Consultant Tip - How to Use Customizer and Crystal Reports to Add a Field and Run Reports

Sage 100 Consultant Tip - How to Use Customizer and Crystal Reports to Add a Field and Run Reports

Sage 100 Consultant Tip - Add a Custom User Define Field (UDF) to a Sage 100 Panel with Customizer and Report on it with Crystal Reports Question: ...

Read More