When we enter a paid invoice in O/E, we enter the 'Payment Method' Code (being M/C Visa Cheque Debit or Cash)Then in the 'Cheque Number' field we use a prefix of the method paid and the total of the invoice. EX: M/C 190.43 or CSH 190.43. This gives us the unique cheque number and minimizes the number of times we get a 'duplicate cheque' error.

I actually have two questions: 1/ In Accpac Plus the data entered in the 'cheque number' field could be shown on the copy of the invoice, but we can't seem to do that with the Adagio. My second question is...on the Invoice Audit List created when I do a day-end, the idividual invoices are listed and show when a payment has been made showing my 'cheque number' and the Bank account it has been applied to. At the end of the list it shows "Total payment" and gives one total. Is it possible for it to break down the total into $X.XX to bank plus $X.XX to cash account?

The spec code for printing the check number is C14 'Customer Check number'. Is that the same code as Plus OE uses?

For your other question, you would like to see a breakdown of payments by the GL account being posted to? Or a breakdown of payments with a bank code and those without? To get this, the report would have to be modified - I can forward this request to R&D. How would you want the report to look if there are multiple cash accounts posted to, in addition to the bank account?

Thanks for the C14! When setting up we couldn't find that anywhere so have just been 'making do'. Works great now!

On the report...Specifically, we have payment codes for:
Cheque acct 1010
Visa 1010
M/C 1010
Debit 1010
Cash 1000

If the report could split up the total for accts 1000 & 1010 would make reconciling easier, however, if it is possible to break the Payment Total into the 5 codes, that would be the ideal.
If it is possible to modify the report, I would be very grateful. (I'm afraid I'm not familiar with 'R&D') If you think it is better to send it to our Adagio rep. and have him do the changes, that would be great to.

I appreciate your help.
Diane

Hi Diane,

Sorry for any confusion. I've forwarded your suggestion to 'Research and Development' as a possible addition to the audit list report, for consideration to include in a future upgrade.

If this is something you are looking for more immediately, you could create a custom report (using GridView or Crystal Reports) to list all the payments in OrderEntry and the associated Payment type and/or GL account. Then sort/summarize the records as desired.

Thank you. It would just be a good feature when doing my Day End. Right now I have to go through the whole report and pick out each invoice that was paid and how it was paid to make certain that all were processed correctly. I use the 'Total Payments' at the end of the report as a verification that I caught them all. If the 'total payments' was able to be split up into more detail, I could reconcile using the various payment slips. Thank you again for your help and the extra 'learning' I recevied along the way!
:)Diane