I am doing my monthly bank statement and notice that a cheque that cleared the bank in listed in the debit column on the detail report. It should be listed in the credit column as it is a payable. I went into the vendor to cheque the transaction and everything appears to be entered/posted correctly. I checked the previous month which shows the cheque in the credit column.

Another thing, I printed the detail report 2 days ago and I reprinted it this morning. Nothing has changed except the report balance totals are different. at the top of the detail listing it shows hitghest posting sequence from 2 days agao as 234 and todays at 235.

Thanks.
Cindy

Hi Cindy,

Is the detail report you are referring to the Adagio Ledger Detail Listing report? If so, look for the same transaction using the View Transactions function (within View Transactions/Budgets). Is the amount sign correct there? This can help determine whether the problem is with the data or with the report.

Did you recently install a service pack to Adagio Ledger 9.0C? If so, we are aware of a problem with Balance Sheet accounts and the Report totals that was introduced in this particular release. Perhaps you are seeing this problem as well.

When I look for the same transaction for the account using the view transactions, there is no amounts for any period.

I did install a service pack to Adagio Ledger 9.0C.

Assuming that data integrity is clean, when you open View Transactions/Budgets, select the Fiscal Year and Period for which the check was written and appears on the Detail Listing report. Then highlight the GL account in the grid and click the Transaction button to the right to list the details for that account. Because the check appears on the Detail Listing report, it will be found here as well.

I see the cheque in the view transactions list but it is in the debit column and needs to be in the credit column as it is a payable. I checked the detail listing for December 2010 to see if the cheque is in the correct column and it is.

How or why would the November 2010 cheque be in the wrong column?

Thanks
Cindy

Hi Cindy,

Could the transaction have been entered and posted with a mistake? When you have the transaction in GL highlighed on the Transactions grid, try using the 'View GL Entry' button to see the entire entry. This could help identify what other accounts may have debit/credit differences.

Does the GL Posting journal for this entry show the correct debit/credit amount? If the posting journal has the wrong (negative) amount, then the problem was in the GL batch prior to posting. Also on the posting journal will be the Created Date, the Last Edited Date and the Posting Date. It may be that the batch was edited after retrieval and prior to posting.

You mentioned that the check is correct in AP, both in the Vendor Transaction and presumably in the AP check posting journal. This would imply that there were no problems in AP and the issue is limited to within GL.

To fix this, you would need to Unpost the batch that contained this AP check, make a correction to the entry in question, and re-post that batch. It may be beyond sleuthing for why this happened, especially if the batch was edited or if it was rebuilt from a data integrity check due to posting errors.

Cindy:

This type of issue is very difficult to correctly advise you on without actually seeing the data.

Before you start unposting batches I would like to suggest that this is a issue best handled by working with your Adagio Consultant. His/her expertise would be invaluable to helping you correctly determine and fixing the problem.

The entry was posted in the prior year. How would I unpost a batch from a prior year?

Thanks
Cindy

Cindy:

You can't unpost from a prior year. You would need to do an adjustment but based upon your discription of the issue I don't think it's that simple, which is why I recommend that you contact your Adagio consultant to assist you.