web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error when trying to c...
Microsoft Dynamics AX (Archived)

Error when trying to create collection letter in AX 2009

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

This is my first post here, so if I accidentally break any rules, then please let me know :)

I am trying to create a collection letter in AX 2009. We have not done it before in this company, but it works in other of our companies running on the same platform. I have made the setup so it it identical to that in the company where it works, but still I get an error message when trying to create a collection letter. The message is "The record has never been selected".

I have not been able to find out what the problem (and solution) is. Any suggestions?

Thanks,

Lene Dræby Kottal

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Error when trying to create collection letter in AX 2009

    Hi all,

    It works now :)

    I can't say what did the trick, because I have tried with various settings.

    Thanks.

    BR,

    Lene

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,316 Super User 2025 Season 2 on at
    RE: Error when trying to create collection letter in AX 2009

    If it is related to the query, you can try to reset usage data. Are you aware of possible customizations?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Error when trying to create collection letter in AX 2009

    1. You have created a new setup via [AR - Setup - Interest and collection letter] and have set up all codes in the lines.

    2. You have linked this group to the posting profile via [AR - Setup -Posting Profiles]. Select the collection letter sequence per account code.

    3. On the posting profile, on the tab Table Restriction, you have ticked 'Collection Letter' (if not, transactions are not taken in account).

    4. Via AR - Periodic - Interest and Collection letter - Creation of collection letter. Click Select and reset any old queries. Select only one customer to check.

    5. In the same screen, select the parameters: Invoice, Credit not, Payment and Interest and set collection letter to All. Also fill a date and set posting profile to the correct profile (probably only one exists).

    This should result in a collection letter, if not, have a developer look at the query.

  • Community Member Profile Picture
    Community Member on at
    RE: Error when trying to create collection letter in AX 2009

    Hi André,

    Under the selection criterias, the structure was wrong. I had "Tables -> Customers -> Open customer transactions" AND "-> Customers -> Customer transactions". I then changed it to "Tables -> Customers -> Open customer transactions -> Customer transactions" only. This change made the error message go away.

    I tried to disable the continuous option, but that did not solve the problem.

    BR,

    Lene Dræby Kottal

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,316 Super User 2025 Season 2 on at
    RE: Error when trying to create collection letter in AX 2009

    Hi Lene,

    Can you explain what you mean with "changed the link"? What exactly did you do?

    You can try to disable the continuous option on the collection letter number sequence and see if this solves your problem.

  • Community Member Profile Picture
    Community Member on at
    RE: Error when trying to create collection letter in AX 2009

    Hi André,

    The error message is gone, after I changed the link between the tables under the selection criterias. Now no error message is displayed, but still no journal is made. I have checked that there are open overdue postings, so that is not the problem.

    Kind regards,

    Lene Dræby Kottal

  • Community Member Profile Picture
    Community Member on at
    RE: Error when trying to create collection letter in AX 2009

    Hi André,

    The full error message reads: "Cannot edit a record in Collection letter journal (CustCollectionLetterJour). The record has never been selected. Update has been cancelled."

    I have checked that number sequences are define and set at continuous, both for the collection letter journal numbers and for the collection letter vouchers. I have set up a collection letter sequence and made the needed changes in the accounts receivable setup parameters.

    Do I need to do anything else?

    Thanks,

    Lene Dræby Kottal

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,316 Super User 2025 Season 2 on at
    RE: Error when trying to create collection letter in AX 2009

    Hi Lene,

    Is the mentioned error the only information you have? Usually there is some more information about which table this error is causing.

    Can you verify if all settings like number sequence are defined?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans