• Customer activity report

    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!
  • How to record a wire transfer in AR

    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…
  • automate - 300+ customers need to be autopay a few days after the invoices go out.

    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…
  • Cash Receipt Journal posted, did not run Daily Transaction Register. How to undo Cash Receipt

    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?
  • Auto allocation

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

    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…
  • Reverse a Prepayment

    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.
  • Moving an overpayment from one customer to another

    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…
  • Sage 100 2019 A/P Aging defect

    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…
  • AR Invoice Balance did not update

    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…
  • Cash Flow

    FormerMember
    FormerMember
    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…
  • AR_CashReceiptsHistory InvoiceField error

    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…
  • Utility to clear $0 invoices off all AR customer accounts...affecting data in alerts & reporting

    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…
  • AR Cash Receipts

    We are on Sage 5.41, Can Multiple users enter a Cash Receipt at the same time with different deposit numbers???
  • Can I apply customer balances to each other?

    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…
  • Salesperson Commission Report recognizing Bad Debt Writeoffs

    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?
  • Is there a way besides using Visual Integrator to upload payment into AR Cash Receipts?

    Uploading payments into Cash Receipts without using Visual Integrator.
  • Cash Receipts

    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…
  • How to apply multiple checks to one AR invoice in same deposit?

    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…
  • Customer short paid freight

    1. What do I do if a customer short pays freight? 2. How do I write off the amount not paid? 3. Do I need to associate something with a GL account? Thanks!
  • A/P Discount After Invoice

    Some of our vendors issue discount checks after we have received, recorded (and in some cases paid) the invoices that they are discounting. What is the best way for me to: 1) Receive the check against the vendor's account (rather than customer) …
  • Importing Cash Receipts

    Hi we are running MAS90 V4.5.4.0, I get a excel spreadsheet from customer, they supply PO#, check description, doc date, gross amt, disc amt, net amount paid. Currently someone manually enters into cash receipts, we have 1000s of entrys, the customer…
  • Prepayments double counting?

    I recently discovered that you can enter pre-payments from customers through Manual Check and Payment Entry. But, when we create the invoice, using the same number as the PrePayment, it looks like it is double counting it and the customer looks as though…
  • Cash deposit into wrong company

    Hello, We have two separate companies that we track with Sage 100, each with their own bank accounts. I received a check and used Cash Receipts Entry to record the deposit into the correct company. But, I then physically deposited the check into the…
  • Undeposited Funds account

    Would like some help in activating "undeposited funds". Does anyone have experience with this?