Sage 100

Client running SAGE 100 Std v2017 PU#1 - Reporting that the Cash Receipts Report is only showing current month (May) cash receipts for all customers. In the AR module > Setup > AR Options > History tab shows ""Years to Retain Cash Receipts History"" = 5, ""Retain Deposit Transaction History"" = None. Client is using Credit Card Processing module. Recent upgrade from v4.40...... did something change in v2017? Is client purging cash receipt records at month end? Ideas?

Longshot, but maybe they selected the ""Monthly Sales Report"". It's right below the CR report and only pulls the current month.

Thanks @ChrisStAmand, but I connected to their system remotely and ran the report myself. Only May cash receipts are showing in the Cash Receipts Report for all customers.

Is the Selection Criteria showing ""By Period""? What if you changed the selection to ""By Date"" and entered the dates for the information?

Are the receipts that show for May actual CASH (not CC) receipts? Somewhere I've read in the doc that CC payments do NOT show up on the Cash Receipts Report.

Are the cash receipts you expect to see on the report processed as Deposits on the Sales Order/Invoice? Or are they Credit Card Cash Receipts?

@JaneCavanaugh I have tried to print the Cash Receipts Report each of the six different ways that you can ""sort"" and ""select"" this report and it always shows only May receipts. @BethBowers I believe you may be on to something. In the SAGE 100 help menu it states ""Note: The **Monthly Cash Receipts Report** does not reflect credit card or ACH payment transactions. The Deposit Transaction Report includes sales order deposits (paid by cash or credit card) and sales order payments (paid by credit card or ACH) that are entered and updated in the Sales Order module, as well as credit card and ACH payment receipts entered in Cash Receipts Entry."" ............The goal is to find a report that lists all receipts for a given customer for a given time period. In version 4.40 that report used to be the Cash Receipts Report. I think something has change between v4.40 and v2017.1

@MichaelMcDonald - I THOUGHT I had the same question from one of my clients recently enough that I still remembered the SHOCKING answer.

Can you get the information from an Explorer view of cash receipts?

Help note that confirms @BethBowers belief on CC payments: ""Note The Monthly Cash Receipts Report does not reflect credit card transactions. The Deposit Transaction Report includes sales order deposits (paid by cash or credit card) entered and updated in the Sales Order module, as well as credit card receipts entered in Cash Receipts Entry."" And per the help for the Deposit Transaction Report: This task is available only if an option other than None is selected in the Retain Deposit Transaction History field in Accounts Receivable Options.

Mystery partially solved....System activity log shows that client on May 1, 2017 at exactly 11:15 am re-initialized the following files: AR_CashExpectationReportWrk, AR_CashReceiptsDeposit, AR_BillToSoldTo, and AR_CashReceiptsHistory. Next question: **WHY?** Another Question; **Who** told you to do that? Question for 90Minds: Can I restore AR_CashReceiptsHistory from a 4/30/2017 backup and then re-insert the May CashReceiptsHistory records?

And take away their access to utilities!!!

Maybe restore it to a backup company for future reference? That way you won't have to worry about the May records. Someone did something they shouldn't have - they should have to suffer the consequences and use a backup company if they need access to that data. Just my .02.

@ThereseLogeais I agree with you about someone needs to learn a lesson. But I think I will restore the 5-years of customer Cash Receipts History to the ""live"" company code so the system will add June and future Cash Receipts to the 5-year history. Then I will move the May 2017 activity to a backup company. This way if someone needs to see the ""whole history"" they will need to run two reports. Changes will be made to the security settings. And as a final step, because they are processing credit card transactions through SAGE 100, it looks like in the AR Options > History tab - I need to turn on the feature called ""**Retain Deposit Transaction History**"" from ""**None**"" to ""**All Transactions**"" From this point (June 1, 2017) going forward the report that the client will have to use in order to ""see"" all receipts will be the **Deposit Transaction Report.**

Cash receipts history is a table you can VI into. Why not restore your five years of history and import Mays into it? Or hire a programmer to write a PVX import to combine the two files. I shouldn't be that hard and the client can ""pay"" for it.

Thanks @JeffSchwenk ....I could use some more practice at using VI. So I think I will grab both files off my clients server, take them down deep into my computer lab and perform some ""surgery"" on them. If I'm successful, I'll ask my client to pay some Obamacare prices to take care of their ""self inflicted injuries"".

You're lucky. They may not have insurance in a year.....

The system activity log helps out when the client says ""We didn't do anything, it just happened"" !!