Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Payment journal approval issue when exporting payment file

Posted on by Microsoft Employee

When you send for approval a Payment Run(from a payment journal) and you export the file (XML) even if they are approved before exporting, new restricted records are created and it doesn’t allow to post but you cannot approve either.

Step that were followed:
1.Enabled Payment for Journal batch (screenshot attached)
2.Created Payment Lines
3.Sent for Approval->sent batch
4.Approved
5.Export Bank payment file(XML)
6.***System creates entries for each line in Restricted records table
7.User tries to post->not able to post because of the restriction records created in the step 6

Version of the Business Central:
Version: W1 20.0 (Platform 20.0.37114.40679 + Application 20.0.37253.38055)

  • Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,260 on at
    RE: Payment journal approval issue when exporting payment file

    I tested on version 20.4

    pastedimage1660838256869v1.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment journal approval issue when exporting payment file

    Hi Alfredo Iorio,

    It looks like this happens on w1 version only and I assume you are using another version of BC.

    Thank you,

    Jezuela

  • Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,260 on at
    RE: Payment journal approval issue when exporting payment file

    Hi,

    Like Kim, I also use this functionality and I never get a further restriction on the journal if it's first approved and then a file is exported.

    If you get an error when you try to post that says unable to post due to restrictions imposed by the workflow, it means that the approval workflow is not completed.

    For example, you have a delegated approval or a workflow group approval that requires more than one user to approve the journal batch.

    Also, you might have approval on the batch and on the journal lines. This means your journal lines must be approved first as a batch, and then as individual lines.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment journal approval issue when exporting payment file

    experience.dynamics.com/.../

    There is already a request for change for this scenario. Can you please vote for this change to be included in the next releases :)

    Thank you,

    Jezuela

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment journal approval issue when exporting payment file

    Hello Kim,

    Thank you form commenting. Yes the step 6 is the problem as the system is not supposed to create restriction records anymore as the file is already approved, but it looks like this is a bug o the W1 version and I am not able to find out why is creating these restriction records.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Payment journal approval issue when exporting payment file

    Can you explain what you mean by step 6. What entries in restricted records?

    We do this all the time without a problem but we don't have step 6?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans