Sage 100

Customer on 2016.5 who does a material number of prepaid orders both via credit card and wire transfer. They are looking for these payments that are placed on the orders (as opposed to entered in CR entry) to show on the cash receipts report. It appears that the CR Report only shows cash entered through cash receipts entry (which makes sense to me). Has anyone come up with a workaround to give a ""one report"" that shows all cash - both cash receipts and prepayments/deposits/credit cards that are placed directly onto SO/Invoice?

Maybe I'm missing something, but when you put a deposit on an SO Invoice, you still need to enter it through CR, so wouldn't that double up on report then?

@NancyHanson is correct. The design is to post the prepayments/deposits/cc to a separate GL account then do a cash receipt entry for the deposits to move it to the cash account. Then it shows up on the Cash Receipt report and makes a BR entry.

Cash in Transit GL account. Set it up in Payment Type maintenance for each card type

We were originally following that procedure but the volume became so much that we swapped over and posted directly to cash. We may have to rethink that procedure now that our processing has largely caught up.

You could set up a VI to import the cash receipt deposits appearing in the bank account. You still need to reconcile the account

If you are posting deposits directly to cash a manual entry into Bank Rec (if BR is used) is needed but that still bypasses the Cash Receipts function. Import as @JeffSchwenk suggested may still be attractive for high volume and to keep cash receipts updated.