I am reading the manual for Bank Rec and note that all receipts should be entered in Bank Rec as there is no interface with Receivables. What happens to cash invoices in Order Entry where cash is paid directly? Do we need to enter those invoices as charge invoices and then do a receipt in Bank Rec?

Hello CPS,

The interface between BankRec and Receivables sends cash receipts entered in BankRec and applies them to invoices in Receivables. Currently there is no interface with cash entered in OrderEntry - the only way to handle this is to create a clearing account for the OrderEntry cash and then enter the day's receipts as a single entry in BankRec against the clearing account. You wouldn't be able to reverse an NSF cheque easily though.

Expect to see better integration in coming releases of OrderEntry.

Has any attention being given to this matter. I have the Bank Rec module and have been unable to use it because of the lack of an interface between the cash receipts in OE and Bank Rec.

Hi, CPS,

Sorry but we haven't added any integration for OrderEntry cash receipts to BankRec as yet. Please continue handling these receipts in the manner outlined by Andrew previously and I'll note your renewed request for R&D.

Thanks,

It is not possible to handle cash sales in Order Entry in Receivables. When you retrieve into Receivables they do come in as cash invoices, however the cash does not show up in Bank Rec. If you are to handle it the way Andrew suggests then all your invoices would be charge invoices and payments would be on account.

Having the ability in OE to do a cash invoice saves you have to write a receipt as the payment appears on the invoice.

It is definitely time for R & D to pay some attention to this.

Hello CPS,

While Andrew/Softrak agrees that it's not the perfect solution, I believe that their work around does work.

Probably best if you create a specific clearing a/c called OE Cash Payments Clearing (close to your Bank Account in the Chart). When processing the payment through OE remove the default Account Set and go to the Account field and use your OE Cash Payments Clearing account. This will cause a debit in that account in the GL.

In BankRec (BR) you can use summary Receipt transactions (single entries) to Debit the Bank and Credit the OE Cash Payments Clearing account by Day (or by some other period that ties back to totals shown on your OE DayEnd Reports). Remember to leave the customer code blank so that you are processing as a Miscelaneous Cash receipt not a "Receivables" type receipt.

The "normal" OE/AR processing will handle the applying of the cash to clear the AR invoice so you must not use BR for this.

I know that the above is not crystal clear, sorry. If you're having difficulty implementing the work around, at least know that it does work and contact your Adagio dealer for assistance.

Hopefully R&D is looking at a tighter solution for the 9.0 versions.

Good luck, Pete

Thanks, I will copy my data to my local machine, try it and I am sure with trial and error it will become crystal clear.