Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Collection Letter help

(0) ShareShare
ReportReport
Posted on by

Hello,

I am having a hard time generating collection letters in our test environment, I have it working just fine in the demo. All was setup along with MS' documentation.

The collection letter sequence is setup, it is also defined in the posting profile, the A/R Collection parameters are set, yet whenever I generate the letters either for a specific customer or all customers, the Print/Post Collection Letters form is empty. 

Is there anything else that is controlling this that I do not have turned on? There should be plenty of letters generated. I'm confused.

Thanks for any input.

*This post is locked for comments

  • Verified answer
    MinJan Profile Picture
    298 on at
    RE: Collection Letter help

    Please check if CustTrans table records in TEST environment have  CollectionLetterfield value set to "Yes"( in demo app all custtrans have this attribute activated). Because when you activate Collection Letter attribute in customer posting profile form, it will be applicable to transactions that you are going to register, not to those that are already posted in AX.

  • MinJan Profile Picture
    298 on at
    RE: Collection Letter help

    Yes, sort of; I have trouble calculating interest

  • Community Member Profile Picture
    on at
    RE: Collection Letter help

    No, I dropped the ball on this for the time being, but I will be addressing this eventually. Are you facing the same problem?

  • MinJan Profile Picture
    298 on at
    RE: Collection Letter help

    @Drumcode, any updates upon this issue?

  • RamK Profile Picture
    2,580 on at
    RE: Collection Letter help

    Have you done any customization...?  If not try to delete, your usage data and try it again

  • Community Member Profile Picture
    on at
    RE: Collection Letter help

    Ram, I've followed all of the steps in both demo VM and on the Test box. Both were configured exactly the same and demo VM generates letters just fine. I have a feeling there really is something funky going on with the code.

  • RamK Profile Picture
    2,580 on at
    RE: Collection Letter help

    If you have all the jobs, Have you run periodic activity New Collection letter by selecting all the parameters (Accounts receivable -> Periodic -> Collections -> New collection letter)...?  What are the check boxes you have selected and what is the collection letter sequence you have selected...? What is the posting profile setup (in the job) you have selected...?

  • Community Member Profile Picture
    on at
    RE: Collection Letter help

    Ram:

    Letter 1  = 1

    Letter 2 = 5

    I am not using any fees. It's a pretty straight forward query.

    Jay:

    Thanks for the tip, I'll ask the partner for help.

  • Community Member Profile Picture
    on at
    RE: Collection Letter help

    Try debugging the salesCollectionLetterPost class?  Pop a break point in the run method to see if it is the Query that is not finding records, or something else in the process that is rejecting the records that it finds?

    Hope this helps :D

  • RamK Profile Picture
    2,580 on at
    RE: Collection Letter help

    Collection letter works on the following values:

       Step 1: Define custom text for the letter

      Step 2: Define number of days that the payment must be overdue before the letter can be generated

       Step 3: Define an amount that is associated with the collection of the overdue amount

      Step 4: Define an account where the fee amount is posted

    Can you please verify step 2...?

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
Zain Mehmood Profile Picture

Zain Mehmood 6 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans