Query to fetch all the receivables credit memo along with origi9nal transaction details

Summary:

Need to develop one report to extract data for prior period of Oct-24. For all the receivables credit memo along with original transaction details for only nominals 140002 and 141003.

Content (please ensure you mask any confidential information):

I have masked the confidential information, have changed the nominals

Version (include the version you are using, if applicable):

No version as of now

Code Snippet (add any code snippets that support your topic, if applicable):

I have written a query but it's not working