Browse By Tags

  • 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!
  • AR_CashReceiptsDetail table missing in VI Import Job Maintenance

    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?
  • VI job to import cash receipts

    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…
  • Cash Receipt Import 2022.2 Premium

    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 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…
  • Error message receipting lease deposit

    Hello all, I'm attempting to correct a prior deposit to move it from an open credit to a lease deposit. The original receipt was voided and I created a charge for the lease deposit. When I attempt to receipt the payment against the lease deposit charge…
  • 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..
  • Sorting ability for Cash Receipts

    It would be great if Sage had the option to allow us to sort invoices in the cash receipts window for easier application. Is this something that can be added to the system?
  • 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…
  • Switching Billing/Cash Receipts to the AR Module from Job Cost

    We currently bill and enter cash receipts in Job Cost, but I want to transition it over to the AR Module. How would I go about setting this up?
  • 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…
  • A/R Report Showing Incorrect Payment for Customer

    On the AR is it showing a payment of 935.28 and an outstanding invoice of 467.64 but shows a credit on their account of 467.64 ONLY on the AR not on their customer account view - it shows zero. A prepayment was done in the amount of $467.64 and it was…
  • Sage 50 Cash Receipts Journal Changes

    We are using Sage 2020.1 Quantum and we are trying to change the cash account on a bunch of our cash receipts. I was hoping to be able to accomplish this with the import and export function available for the cash receipt journal. The issue I run into…
  • Receipt for Sales Invoice gets added as Other Applied Credit instead of Amount Paid at Sale

    FormerMember
    FormerMember
    I'm using the C# .NET Sage 50 2019.1 SDK. I am creating a Sales Invoice and after saving I want to attach a Receipt and record it as Amount Paid at Sales. Every time I do this Sage 50 shows the Receipt as an Other Applied Credit. Is this possible? …
  • 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…
  • How to correct duplicate Misc. Cash Receipt entry

    The same Misc. Cash Receipt was entered twice, on different dates. Since it was not payment towards an AR customer account, how do you correct the duplicate entry?
  • Cash Receipts Journal: Full amount is posted in General Ledger, but not to accounts?

    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…
  • Error 15: OS System command failed

    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…
  • Accounts Receivable in sage 100 Contractor

    I am transferring Quick books entries into Sage contractor 100. We receive a check from a customer and enter it in Quick Books thru "receive payments" module which posts the payment to the customer invoice and then posts the transaction to an "undeposited…
  • Ideas on how to receive monthly draw payment with OCIP/CCIP deduction?

    We currently are making a credit invoice for each invoice paid that has an OCIP/CCIP deduction. The problem we're running into is that these credit invoices are hitting a direct expense account we set up for OCIP expense. The issue with this is that the…
  • Cash Receipts Applied, yet still in open AR. Help!

    I generated an invoice for a customer on December 10th and they paid for it immediately via CC ($3,316.91). When I go into their account, it's showing the invoice is both paid AND past due. When I click on the related transactions it shows the receipt…
  • Customer Deposits to Liability Account

    How do I enter customer deposits to the liability account, then deduct it from their final bill to debit the liability? There dosen't seem to be an easy way to enter, apply, and deduct in billing or accounts receivable. I figured out how to enter a…