This is a bazaar case. Can Adagio automatically reverse an entry without assistance?

A client has noticed this twice now. The first time they manually did the corrections but it has happened again and it is surely going to be a nuisance if we don't know why this is happening and a way to prevent it.

The client noticed that a batch or batches have been reversed without anyone doing the reversing themselves. November Inventory receipts, adjustments etc were reversed on December 1st. (Please see reversed transactions and description attached)

Can anyone help with this, or let me know if it’s a tech support issue so we can get this rectified at quickly as possible. It is only happening with transactions from Inventory and Order Entry

Version Running is Ledger 9.0D, Inventroy 8.1D, Order Entry 8.1E

Adagio Ledger has an option on the batch to 'auto-reverse' the amounts for the subsequent fiscal period. You can see this by clicking the Rename button on any batch. It appears that this option has been set on some batches, and I don't belive that retrieval from sub-ledgers does this.

The next time batches are retrieved, don't post any of them as part of the retrieve process and look at each one from the Rename screen. Do any of the retreived batches have the auto-reverse property enabled?

I looked at the retrieved batch once you go to rename that option to auto-reverse is not present so it doesn't allow you to auto-reverse retrieved batches.

Hmmm, I would really have expected "auto reverse" to be the culprit here as I can't think of any other way that a user could get this to happen "without them knowing/remembering" that they had caused it. For instance, though the batch could be copied with the "reverse entries" option ticked, this would have created a new batch and they would have had to post it and at some point in the process I think they would have realized that something was awry.

If they print batch listings check the header for the auto reverse status of the batch. Also, if memory serves me well, if the batch posted with the status enabled, this should mean that the original entries and the system generated auto reverse entries should be in the "same" posting journal.

I'm also remembering something about not being able to auto reverse in the last period of the fiscal year so bear that in mind as you troubleshoot.

Best regards, Pete

Could the user have used Provisonal posting?

Provisionlly posted batches automatically "reverse out" with the new posting.

This can be disabled in the Company profile.

Provisional posting isn't enabled, and as discussed before these are sub-ledger transactions retrieved into the GL.

Hello:
The first step in your investigation is to look at the characteristics of the batch(es). Which batch did those reversed transactions belong to? What about the original transactions - same batch or different? What posting sequence(s)?

Then go to Inquiries | View Batch Status. Add columns to display "Auto-reverse", "Ledger", "Date created", "Date last edited" and "Last edited by user". What does that tell you about the batch(es) in question? If Auto-reverse = "Yes" and Ledger = "IC", then take a copy of the client's data and see if you can reproduce that circumstance. Ask them what procedures they follow.

Hi Bruce,
As I had already checked the first part of your suggestion I went on to the second part. I checked the batch status and added the columns as you said and noticed that the sub-ledger batches in question did indeed have YES under auto-reversing, however there were some batches to retrieve and so we did but those are saying NO under auto-reversing.

The client claims to only have retrieved the batches checked them then post, same procedure they always do however this issue has just started it occured once in October nothing in November and now in December nothing in January.

We could not replicate the issue.

I bet someone checked the box, just to see what it did!

LOL Andrew, but the thing about it is that the option to auto-reverse isn't available once the batch has been retrieved.....I asked them the same question if someone enabled it by mistake.