Finance | Project Operations, Human Resources, ...

Customer reconciliation report showing difference for particular legal entity in AX 2012

(0) Share

Report

Posted on by @rp@n

hi All,

Customer reconciliation report showing difference for one particular Legal Entity. I noticed one particular voucher is not considering in the report.

Is it data issue or code issue ?

I guess, it might be data issue , If it's code issue then entire report will impact not particular voucher.

please give me more shed on this.

thanks

All responses (5)

Answers (0)

André Arnaud de Cal... 294,099 Super User 2025 Season 1 on at

Like (0)

Report

RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

Hi @rp@n,

Due to vacation, I missed updating this question. Have you found your answer already? If an amount got posted manually, you first have to understand why it happened. Based on the reasons why, there can be several different actions taken. I'm not able to guess the reason here and if there was a manual posting at all.
@rp@n 18 on at

Like (0)

Report

RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

hi Andrea,

thanks for your reply.

Sure, i will check...

As you said "I would expect that there is a voucher posted in journal 'GJT-04951***' directly on the main account from the customer balance. Can you check if this happened?"

Suppose, if it happened then what to do ?

kindly advice
Suggested answer

André Arnaud de Cal... 294,099 Super User 2025 Season 1 on at

Like (0)

Report

RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

Hi @rp@n,

Without technical details, when I read the details on the report, I would expect that there is a voucher posted in journal 'GJT-04951***' directly on the main account from the customer balance. Can you check if this happened?

By the way, it is correct that all opening balances are not considered on this report. That is as per design as an opening transaction has no customer transactions.
@rp@n 18 on at

Like (0)

Report

RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

hi Andre,

Thanks for the response.

I have run the report in below periods -

Report output

I have analyzed and found the above +ve marked amount is missing . I mean the particular voucher is not considering.

Class - Ledger Reconcilation

Method - insertNonSourceDocumentDetail

In the above code , i found in Table FiscalCalenderPeriod, it mentioned to consider only FiscalPeriodType = Operating

and also analyzed the data from backend and found the particular record (voucher ) in table FiscalCalenderPeriod has FiscalPeriodType = Opening

So, RecId get 0 while debugging i found

Kindly let me know how to resolve this issue
André Arnaud de Cal... 294,099 Super User 2025 Season 1 on at

Like (0)

Report

RE: Customer reconciliation report showing difference for particular legal entity in AX 2012

Hi @rp@n,

Unfortunately, we don't know any details about your environment. Can you tell more about the missing voucher? What is the source of this voucher? Was it a customer related transaction or probably a manual posting? Is it skipped because of the date? Please provide some more information as we wouldn't be able to help you without any details.