In Memory temporary tables must be the outer tables when they are joined .

(0) Share

Report

Posted on by Community Member

Hi guys,

i have a doubt in ax 2012 CU12 customization, I ill be getting an error in customer payment journal,

the error occurs in line form, in settlement tab . i shared my error here , 2133.error.png

"Cannot select a record in Open customer transactions (CustTransOpen).
InMemory temporary tables must be the outer tables when they are joined to a TempDB table or permanent table."

and after debugging it error occurs in class like super().

Can any one suggest me answer.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

But Custtransopen Table or related query are in regular type their is no InMemory table type is present.

Thanks&Regards,

padmapriya.v

Was this reply helpful? Yes No
Raheel Khan 40 on at

Like (0)

Report
Copy link

Link copied!

Can you write down the solution, I am facing same issue.

Was this reply helpful? Yes No
Raheel Khan 40 on at

Like (0)

Report
Copy link

Link copied!

There is no inMemory even TemTable there.

Was this reply helpful? Yes No
Suggested answer

Mohammed Khatib 430 on at

Like (0)

Report
Copy link

Link copied!

Hi Padma,

I believe this is an old post, did you find a solution to this error?

Can you please mention the AX version you are using?

I have AX 2012 R3 CU13. Go to AOT --> Forms --> CustOpenTrans

Compare SYS layer with SYP layer, you will find that the latest update added a new data source to the form which is a view "CustTransOpenLastUpdCollectionLetter" and has a configuration key "CustCollectionLetter", this configuration key is disabled in our environment, and it doesn't match the business to enable this configuration key.

Note: Our environment AX Version is AX 2012 R3 CU12 6.3.5000.138

So as a workaround for this case, I changed the join type of this data source from Outer Join to Delayed, and set the Join data source value to empty since the tables behind this view are empty and hold no data:

Was this reply helpful? Yes No