In the O/E Day End Processing, when we do the print-out we check off the option to include G/L account listing, which it does, but I'm looking also for the bank account listing. When we sell something at the counter and the customer pays at the time of sell, we enter payment received and if it is by credit card or cash. The Day End report shows the invoices that were paid and includes the method of payment and the G/L account associated with that method, at each individual entry. But at the end of the report, the bank accounts are not included. I am trying to get a printout at the end of the day that would say what bank accounts were credited so that I can reconcile to see if all payments were properly entered. Do you know if this is available anywhere?
Thanks
Diane

Hello KEMLTD,

Yes, you're right - there is no bank gl account summary or listing by payment type at the end of this report. There should be. Look for us to add it in a future service pack (but not the next one - sorry).

One problem about showing the bank account g/l summary on this report, is that these g/l entries are actually not made by OrderEntry, but are the responsibility of Receivables when the batch is posted there. That's why they are not showing up in the g/l summary at the end of the report.

Thanks for bring this to our attention!

Don't forget to register for the next Adagio Users Group meeting in which we review Data Integrity Checking. You can find out all about it here. You can also post any question about using Adagio when you register for the web seminar. It will be answered as part of the meeting.

Thanks for using Adagio!

Thanks Andrew, I will look forward to this in the future.

I suppose, since you didn't suggest it, that I can't pick up a listing when I retrieve the invoices into the A/R?

Thanks again
Diane

Andrew,

While this is not directly related, it made me think again of something I think I'll mention here.

Many people use OE in a sort of POS way where a large percentage of "orders" are invoiced right away, with lots of these being paid right away. However, they still need the true "order" type processing as well and prefer to stay with OE rather than going to the expense of adding a POS module.

My Question: Would you guys ever consider an OE 'standard' feature with reporting that could assist with the balancing by cashier (user) by day (maybe even shift :-).

Regards, Pete

Hi KEMLTD,

You can get the G/L posting summary on the cash posting journal in Receivables. If each cc & cash/checks are going to different g/l accounts, this is a way to get a cash out list.

In answer to Peter, yes - we will be adding a summary to the invoice posting journal in the future. We won't be balancing to "cash" though, because we don't see OrderEntry as a reasonable POS solution.

Hi Peter,

Given that the Invoice Date, Invoice Amount and Cash Payment are in the O/E Order Header as well as Salesperson (could be used for the Clerk) I would think GridView might get you close to what you want for balancing cash.

I will be in Barbados (Holetown) starting September 26th, perhaps we should get together to discuss.

Andrew - It's reasonable in a low volume scenario and could be even more reasonable in these environments with "basic assistance for cashier balancing" - without needing an additional module :-).

Michael - I did a Quik Report for one client many moons ago so I am sure that both Crystal and GV could assist. I will check to see if the User ID is in the record though, as using SPcode could have more issues.

Thanks Guys - I won't take up any more time on this but please note as a suggestion.

Regards, Pete

PS: Mike we'll definitely get together while you're here but our discussions will probably focus more on which of the island rums you prefer.