web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

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)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

    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?

  • Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

    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

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

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

  • Community Member Profile Picture
    Community Member on at

    Hi all,

    It works now :)

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

    Thanks.

    BR,

    Lene

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans