Hello,
We've posted a receivables batch then we retrieved all our batches in the GL but when looking in the GL listing we cannot find the entries from the receivables batch. Where or how can we find this batch?

Hi Lynn,

Do you recall any errors when the Receivables batch was posted?

If you look at the Batch Status Inquiry, can you find the Receivables batch(es) in question? If you have the Next fiscal year open, you need to check both the Current and Next Year batch lists, since retrieval can automatically assign entries to the appropriate year based on the transaction date.

If the Receivables batch was successfully retrieved, it will appear on the Batch Status inquiry somewhere, provided your data is not corrupted. If the batch status is Posted, it should be in the posted transactions somewhere in Ledger - you can review the posting journal from here for convenience. If the status is Deleted, you can Recover the batch from here. If the status is Open or Printed, then the batch is not yet posted.

I presume from your comments that the Receivables batch was indeed retrieved successfully, and it is just a matter of locating where the contents are in Ledger.

Hi,
I'm not the person who posted / retrieved the batch. She said she didn't notice anything describe above. I've looked in the Current and New Year batches in AR & GL without success. In AR it's identified as Posted but in GL it's nowhere to be found. I've done a Data Integrity Check in both modules = no errors. I was wondering if she retrieved it before opening the New Year, then it would become an error batch right, but what if she then opened the New Year to retrieve that batch again. Is this possible? If it was deleted then wouldn't I see it as a deleted batch? If I recover that batch in the AR will there be double transactions in the customer files?

Hi Lynn,

Can you confirm the versions and release dates of Adagio Ledger and Receivables that you are using? These can be found from the respective Help / About screens.

If the batch(es) posted successfully in AR, then indeed you do not want to Recover the batch there, as it would result in the transactions being doubled.

If you cannot find any record of the AR batches anywhere in GL for the Batch Status inquiry or the posting journal, either for the Current year or the Next year, then based on that and your other recent comments, the AR batch was never retrieved into GL. If a GL batch was deleted, it would appear on the Batch Status inquiry with a Deleted status.

When a subledger batch is retrieved successfully into GL, that file gets cleared out, so it is not possible to re-retrieve the file, short of restoring that file from a data backup. I would not suggest going that route unless your Adagio consultant is assisting you.

Open the Retreive sub-ledger batch process, and do you see Receivables on the list to retrieve? If you do see it, highlight it on the list and verify the settings for how it is retrieved, for the options for setting the Fiscal Period (by date, specific or subledger). This will give you a clue as to what fiscal year the batch would have been retrieved to, based on your knowledge of the AR transaction dates. Don't actually do the retrieve at this time.

Then open AR and from there, preview the G/L Transactions report, which lists the posted transactions that have not yet been retrieved into GL. Perhaps the missing transactions are there, which means all you need to do is the retrieval.

If the missing AR transactions are not there, then this would not be good. Based on the above, that would imply that the GL Transactions retrieval file was created by AR posting, but lost before retrieval into GL, since there were no errors when retrieving. If this is the case, then you will need to get your Adagio consultant involved.

HI
I had already verified the AR G/L transactions, it's empty as is the Retrieve sub-ledger batch process. It seems that this batch was lost in the twilight zone!
If there was the reverse batch in AR, that's what I would have done to reinstate it after because then we would be able to retrieve it in G/L.
What I don't understand is why a posted AR batch would not retrieve in G/L ??
How can a batch be dropped? Has this ever happened before?
Thanks

Hi Lynn,

Provided there wasn't a network glitch, no this doesn't happen where data files mysteriously disappear. The name of the file that gets created by AR to retrieve into GL is ARALBTCH.dat, where dat is your data extension.

You probably will need to contact your Adagio consultant at this point, as this sort of scenario is best solved with an export who can see your system.