Old A/P accounts (invoices) generated in PMO (Property Manager for DOS) won?t clear in ADAGIO ? all transactions appears with ?C? which means transaction completely settled by postdated transaction.

We note that a patch to Adagio Ledger made before version 8.00 and think that maybe, the problem relates to the data that may have been imported before the patch for PMO was put in place.

When the same report is run in ACCPAC payables (DOS) everything is cleared we don?t have this 60 page problem.

Thanks!

OK - I'm lost...

A "patch to Adagio Ledger" will not impact how Adagio Payables behaves - and it's in this module that you appear to have a problem - right?

Are you talking about clearing fully paid invoices in Adagio Payables? What report are you printing in ACCPAC Plus Accounts Payables where "everything is cleared"?

Is the data integrity check clean in Adagio Payables? Would you send me a backup of the data so that I can take a look? (Use File | Backup | Payables data and e-mail me the resulting ZIP.)

In Adagio Payables, the 'Open Payables' report will label an invoice with a 'C' for 'Completely settled by post-dated transactions' if there is one or more matching transactions applied to the invoice - with a date later than the report date - that sets the current amount of the invoice to zero.

And when you indicate that these invoices will not clear, do you mean to move these completed invoices from Current to History in Payables?

Firstly, do an inquiry to the vendor transaction and look at the applied details (ie payment, credit note, etc). Are there any and what is the transaction date? If you printed the Open Payables report with a date later than these applied detail dates, how do the invoices look on the report?

When you run period date to purge completed transactions to history, all transactions must be earlier than the purge date. If the payment date is later than the purge date, then not only will the payment not be purged, but neither will the invoices that it paid. This likely is why Adagio Payables is not clearing these invoices - if there are post-dated payments or credit notes on file, applied to these invoices.

Thank you for your reply!

-> A "patch to Adagio Ledger" will not impact how Adagio Payables behaves - and it's in this module that you appear to have a problem - right? <-

1) the module where the problem is surfacing is indeed Adagio payables. I was just trying to make some kind of guess here, so, my apologies for the red herring!

-> Are you talking about clearing fully paid invoices in Adagio Payables? What report are you printing in ACCPAC Plus Accounts Payables where "everything is cleared"? <-

2) Yes, the fully paid invoices as printed in the "Open Payables" in the Adagio payables module. Both detail and summary are incorrect. The entries that have the problem were all imported from the DOS version of property manager as they carry "PMO" somewhere inthe document number column. In regards to the report that we are comparing it against in ACCPAC, the report is the "Open Payables Report", again, either detail or summary. The point is that the transactions come up as "C" in the Adagio Reports (and everywhere else of course). The report date being given for the Adagio report is Oct 26,2006 and all the transactions are paid before that date.

-> Is the data integrity check clean in Adagio Payables? <-

3) the Accpac integrity check was error free while the Adagio one had more than 4,800 errors - probably the culprit.

-> Would you send me a backup of the data so that I can take a look? <-

4) We have a backup and will gladly send it to you. Contact me by email and I can attach it.

Again, thank you for your help and,

Cheers, JK!

Hey, I have posted my replies to each question asked and have not heard a word back after almost a week.

Could someone help us please?

Thanks, JK!

Hi ITBGEEK,

You responded to Andrew's questions, but not to ours. Here are these again:
===
And when you indicate that these invoices will not clear, do you mean to move these completed invoices from Current to History in Payables?

Firstly, do an inquiry to the vendor transaction and look at the applied details (ie payment, credit note, etc). Are there any and what is the transaction date? If you printed the Open Payables report with a date later than these applied detail dates, how do the invoices look on the report?
===

Please give an example of an invoice that is appearing with a "C" on your Open Payables report, and indicate in your reply the invoice date and the dates for all applied transactions against the invoice. If none of the applied transactions have dates later than Oct 26, 2006 then there is more to be investigated, but if you find later dates, then this is the answer.

Also, you mentioned finding 4800 integrity errors - please indicate the message (ie invalid vendor, calculated amount not correct, etc).

Hi!

Sorry, about that, I figured that my responces to Andrew's questions covered off your points. My apologies.

>> And when you indicate that these invoices will not clear, do you mean to move these completed invoices from Current to History in Payables?

Yes, this our longer term goal but at the moment we are looking at the two reports and finding divergence.

>> Firstly, do an inquiry to the vendor transaction and look at the applied details (ie payment, credit note, etc). Are there any and what is the transaction date?

yes there are details in the vendor transaction and the dates are correct and appear in the range of 1999 to 2003 etc... all well before the report date of Oct 26,2006

>>If you printed the Open Payables report with a date later than these applied detail dates, how do the invoices look on the report?

we did print the open payables report with a date later than those noted in the payment particulars (OCt 26,2006) and the items are showing up unpaid but completely reconciled by post dated transaction even those that show up in the vendor inquiry dated in 1999, 2000, 2001 etc.. etc... (ie: with a "C").

>> Please give an example of an invoice that is appearing with a "C" on your Open Payables report, and indicate in your reply the invoice date and the dates for all applied transactions against the invoice. If none of the applied transactions have dates later than Oct 26, 2006 then there is more to be investigated, but if you find later dates, then this is the answer.

Item appearing with "C" on the open payables report is:

Peter Bradly vendor number BRA01
document date: 05/15/2002
document amount: 535.00
marked as "C" right next to the current amount column

Same item in vendor inquiry report:
Peter Bradly vendor number BRA01
document date: 05/15/2002
orginal amount: 535.00
type PA:
document number: 6443
document date: 05/16/2002
reference: 6443
org amount: -535.00

Conclusion: dates are in order. Data is present in the vendor inquiry and appearing as completely settled by post dated trandsaction in the Open Payables Report.

>> Also, you mentioned finding 4800 integrity errors - please indicate the message (ie invalid vendor, calculated amount not correct, etc).

I have posted an image of the error here: http://xecinc.com/files/rf_errors.jpg

Again, thank you for your help!

Cheers, JK!

Hi JK,

Thanks for the information thus far.

Are the 'current amounts' of these invoices and payments 0.00 or the same as the original amounts? If invoices and payments are equal and non-zero, then can we assume that the payments have not been applied to the invoices? And they should have been.

To rectify that situation, you need to create 'zero-dollar' entries in a manual check batch that apply to both the invoice and pre-payment (that net to zero).

If you have Payment transactions with a current amount equal to a non-zero value, this is indicative of corrupt data.
---
As for the almost 6000 integrity errors, having to do with home equivalent balances for customers and invoices, where the data has a stored value of zero but expecting non-zero (the calculated values), this relates to whether the current amount of the invoices are zero or not.

A 'PA' payment transaction typically comes from the system check processing function and will pay existing invoices and have a current amount of zero.

I wonder if your transaction matching file is missing information. If you print the Open Payables report for just that single vendor BRA01 and make sure the 'Applied Detail' checkbox is selected, do you see the payment listed underneath the invoice? If not, then the matching file is corrupt.

At some point, you may want to make a copy of your AP data and attempt the Rebuild on the copy. This will help identify if all those integrity errors is the cause of the report scenario, which I wouldn't doubt.

Hi!

>> I wonder if your transaction matching file is missing information. If you print the Open Payables report for just that single vendor BRA01 and make sure the 'Applied Detail' checkbox is selected, do you see the payment listed underneath the invoice? If not, then the matching file is corrupt.

This is exactly the case. The payment information does not show up in this eact instance.

>> At some point, you may want to make a copy of your AP data and attempt the Rebuild on the copy. This will help identify if all those integrity errors is the cause of the report scenario, which I wouldn't doubt.

Ok, we have indeed targetted the exact location of the problem now. Can you advise as to how to perform the Rebuild on the copy...?

I'll venture a guess at making a backup first, and the opening the back up. Then from there somewhere, we run a utility called rebuild. Correct?


Thank you and,

Cheers, JK!

The Rebuild function is found on the same screen as the Data Integrity Check. If an Integrity Check is performed and errors are found, the Rebuild button becomes enabled. Choosing this will make repairs to the database. After this, you would want to re-run the Integrity Check because in some cases, data corrections will require a second round of re-calculations and another Rebuild.

I would strongly suggestion making a backup of the data (very easy to do - File/Backup/Payables Data within Adagio Payables). You can run the DIC and Rebuild on your live data or the backup copy as you wish.