Sage 100

Customer on Sage 100 ADV 4.5.5 using SPS . Created AR Invoice and and then paid it during cash receipts with a customer credit card. Everything posts correctly and you can see the transactions in Customer/Invoices. Money hits GL and every thing is great. Except...... No entry shows up when you go to run a Cash Receipts Report in AR. Everything else done thru Cash Rec is there and there is a skip in the deposit numbers shown that represents the above mentioned transaction. We have done another similar transaction just to be sure we did not screw something up in the first one. Same Results! Anyone familiar with this? Where can you go besides settlement report to see a comprehensive cash receipts report.

Perhaps the theory is that this report should agree with your bank deposit. I'll bet it doesn't post to bank rec either.

That is a thought. We can run a settlement rpt and see the transaction. I will check and see if this is true on the bank rec. Thanks @KathrynScofield

I think @KathrynScofield is onto something. The help screen indicates ""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 sales order module as well as credit card receipts entered in cash receipts entry"".

Good Info. After trying that report, I get a msg ""setup indicates that this option not available on your system"". So I go into AR setup and see 2 areas that might be affecting this. The first option I see is under the Printing Tab. Page Break Cash Receipts Journal by Deposit is not checked, but I doubt that is the issue, then I find under the History Tab Retain Deposit Transaction History""---- There are options for different types of transactions ex: cash,credit cards, other. So I am choosing the Credit card option as that is all they want to see. Thanks for helping look past the issue and find the answer.