I'm assuming that in the Open Payables report, you are also selecting the option to include 'Fully Paid Transactions'. If this is the case, then the report will print all vendors with any activity, even if the outstanding amount for that vendor nets to zero. This is how the similar 'Open Payables' report works in Accpac Plus AP and intentionally part of the report design.

Would you like to see this work differently? That if the option 'Zero Balance Customers' is not selected, then up-to-date vendors 'never' print on this report? If so, we can forward that suggestion to R&D.

Thanks and regards,

What version and (release) of Adagio Payables are you using? (To find out, when you have Payables open, click on Help-About.)

I cannot duplicate this with the current shippping version, which is V6.8A (011207). Since you are on a Combined Support Plan, I am going to send you an email. I would like to see a copy of your data, to see if I can duplicate it here.

Regards,

As per my email - thanks for sending your data. This helped to find the source of the problem. I am posting it here so others may benefit from this information.

The reason the Open Payables report was printing Vendors with 'zero' balances was because even though these Vendors had a net balance of zero - the transactions that made up that balance were not in fact matching transactions.

In this case, all the Vendors listed on the report except for one, had both invoices and offsetting adjustments posted, but the adjustments were not applied to those specific invoices, so even though the amounts matched, the transactions did not 'match up' in the system, thus the report listed them appropriately. Even running Period End would not clear these transactions out of the system, because as far as the system goes, they are separate transactions if not applied correctly.

In one instance, there were actually credit invoices entered to seemingly offset the original invoices - the end result is the same.

Once adjustments were entered and correctly applied against these invoices (and the incorrectly entered adjustments), the Vendors did not show up on the Open Payables Report.

ACCPAC Plus A/P works in the same way and lists all these Vendors with a 'net' zero balance with unmatched applied details.

It is debatable whether or not the Open Payables report should print these types of transactions or not - if you think it should work differently, then please feel free to enter a suggestion to this effect. As it stands, I would see this as a warning device, to let you know that transactions were not correctly applied, but not everyone may see it this way.

Take care,