Sage 100

Is there a report that will show a list of customer invoices and the payments + credit memos applied against it? We have a customer that is constantly trying to re-use credit memos. Thanks for your input!

I'm working on an import job to enter cash receipts and don't have the AR_CashReceiptsDetail table in the table list. I see it when I'm in export job maintenance, just not import. What am I missing?

I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience. I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…

Client just upgraded from 2019 Premium to 2022.2. This Cash Receipt import was working on the prior version. It is basically line for line what I have with another client on 2019 Adv which IS working and same as what I just tested on my Std 2022. I have…

How do you record a wire transfer from a customer in AR? In AP there is the selection drop down for Wire Transfer, but not in AR. I read if we use ACH/Credit Card, it doesn't post to BR. So do we use Cash and if so, how/where do we enter the long 15 digits…

I have a client that bills once per month. I want to export the customers that have a checkbox I created that states yes, along with that month's invoice balance to auto-pay credit cards. 300+ customers need to be autopay a few days after the invoices…

Need to undo the Cash Receipts entry, but the Cash Receipts journal was posted. The Daily Transaction Register was not posted yet. Should we just finish the DTR and do a Reverse Cash Receipts entry or is there another way before the DTR is run?

Is it possible to enable auto allocation of customer receipts to customer invoices in sage 100 v 7.00.209..

With the changes made re the ARWAR4 issue, Cash Receipts is acting differently. Most clients will not notice, but I have one client who has a boatload of invoices per customer and sees this when loading the invoices Unfortunately, even when they say…

A prepayment was incorrectly made, and due to some confusion was also entered in negatively so it shows up as a positive number in the aged invoice report. Is there a way to delete a PP or reverse it? This is on the A/R side. Thank you.

I have a customer that has about 10 different divisions in different states. I received a few checks today , and while applying payments i accidentally over received in one account. So now that account shows -$239.40 , however i need that to be transferred…

Just a heads up - in v2019 an additional header was added to AP Aging Report. There are now 2 headers. Page header f and Group Header 2 If you do NOT have divisions and run the report sorted by the default Vendor Number, both headers are suppressed…

Hello, We had a strange event occur a few days ago. For one of our batches, the Cash Receipts Journal processed all of our checks except for the last 4 in the batch. However, the full batch was posted to the General Ledger, and the full amount shows…

Hello, We are encountering the following error during cash journal printing. This happens on almost any cash receipt journal we try to print, I have only had one successfully go through. Help would be very much appreciated as I have no idea where to…

Greetings, Not sure if I can explain this clearly but our finance team is having a problem with receiving a payment and the transaction not updating correctly throughout Sage. If I look up the invoice in Sage, I can see the invoice has a balance of…

Does anyone use the Estimated Cash Flow Analysis Report? I ran this report, but immediately realized it cannot be correct because it was factoring in a negative balance from a bank account that was closed years ago. Any suggestions on this or alternate…

I created two credit memos in the SO module and noted that they should apply to two specific invoices. However, the invoices had already been paid. Now the customer wants to take these credits against a different invoice. When I go to cash receipts entry…

Hello, We're recently encountered a problem with posting AR Cash Receipts. This has occurred over the last 5 months and we haven't found a solution. A Cash Receipt is properly posted and clears the AR invoice. If you view AR Inquiry, the invoices…

We have numerous $0 invoices in each customer AR account for items like samples, literature, etc. This is our way of tracking these materials. Recently, we began using bolt on programs for alerts and reporting. One report will send an alert for each customer…

We are on Sage 5.41, Can Multiple users enter a Cash Receipt at the same time with different deposit numbers???

I have one customer with an open balance and another balance with the offsetting credit balance. Is it possible to do a cash receipt and apply the two customer balances together so that both customers balances zero out like you can in SAP? This is a really…

When I enter in a Bad Debt write-off using the Cash Receipts Entry, The commission on that invoice (paid on paid) is recognized on the salesperson's commission report. How can I write off an open invoice without the commission being recognized?

Uploading payments into Cash Receipts without using Visual Integrator.

I have an invoice for a customer that shows open on their account. They sent a payment. When I try to apply the payment to this invoice, it does not show up in the list of "select invoices" option. I deleted this batch and started over. I have restarted…

I'm a new user of Sage 100 ERP 2013 (v 5.00.8.0) and am trying to post cash receipts. I have a client using three checks to pay one invoice. I entered the first check fine, but when I try to enter the second check and apply it to the same invoice it says…