Getting error in print edit list for receivables batches.

(0) Share

Report

Posted on by Saugat Dhara

135

I have a receivables transaction saved in a batch.Now before posting the batch,i try to print the edit list to find an error in the list which says"transaction analysis information is missing or is incorrect".Guys,any idea on this.if so,please respond ASAP.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Bruce Wilkins 570 on at

Like (0)

Report

Re: Getting error in print edit list for receivables batches.

Are you using Multidimensional Analysis?

Was this reply helpful? Yes No
Ian Grieve 22,784 on at

Like (0)

Report

Re: Getting error in print edit list for receivables batches.

Or Analytical Accounting?

Was this reply helpful? Yes No
Irfan Rasheed 550 on at

Like (0)

Report

Re: Getting error in print edit list for receivables batches.

Hi,

I am getting same error. We are using analytical accounting.

any suggestions.

Regards.

Was this reply helpful? Yes No
Suggested answer

Heather Roggeveen 9,146 on at

Like (1)

Report

RE: Getting error in print edit list for receivables batches.

In case someone comes looking for this answer as I was today, here is the solution I did.

The client uses Analytical Accounting. Entering a Cash Receipt they got the transaction analysis error. Deleting and re-entering the receipt did not resolve the issue. The Bank and Accounts Receivable GL distributions that were impacted are not tracked in AA. But the nature of AA creates entries anyway (because you could choose to track and reallocate at a later date).

In our case the Bank GL Distribution was correct, but the AR GL distribution was not picking up correctly so the transaction was out of balance.

I first checked AAG20000 and isolated the receipt. You need to note the aaSubLedgerHdrID.

I checked AAG20001 and this was fine - showing the correct Debit and Credit Amount.

AAG20002 however showed the Debit amount for the bank GL fine but the Credit amount for AR was not - I updated the Credit, Originating Credit and Percentage fields. The transaction then posted. The user did get a stored procedure error but nothing that we could see as an issue.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Getting error in print edit list for receivables batches.

You are totally right Heather

Or, it could simply be the result of not filling the analysis information as the error states either for AA or MDA

Was this reply helpful? Yes No
Suggested answer

Janeece Moreland 270 on at

Like (0)

Report

RE: Getting error in print edit list for receivables batches.

I had this same issue for a cash receipt that does not have ANY AA Accounts on it.

Although this customer does have Analytical Accounting.

The cash receipt was applied against an invoice which left an unapplied amount.

After I read Heather's post, I researched the AA tables and discovered that the unapplied amount showed 90 % applied in the AAG20002 table . After updating the percent to 10000 (100%) then I did NOT receive this error. I was able to post just fine!

Thank you Heather.

Was this reply helpful? Yes No