Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Can't delete unpos...
Finance | Project Operations, Human Resources, ...
Answered

Can't delete unposted journal

(0) ShareShare
ReportReport
Posted on by Shristi_MP 60

Hi Brains trust. 

This issue has me stumped. I have a big unposted general journal of approx 50k lines that I need to delete. I have tried so many ways but my AX just freezes and nothing gets deleted. I have not been able to put a dent in it for the last 3 days! I have tried:

1) The delete button for the journal - failed

2) Then tried clearing journal lines first - failed

3) tried deleting just one line - failed

4) tried to delete via the back tables - failed

5) tried deleting just one line via back tables - failed

This journal is possessed and would not budge! Please help! The only thing I'm left to try is SQL via DB but I'd rather leave that as a last resort. The journal was loaded via DMF so I checked to see if maybe it was stuck as still processing, but no, it processed fully. Are there any locks that might be stopping me from clearing it? I am not getting any warnings or messages as to why it is not working. 

Thanks

Shristi

  • Shristi_MP Profile Picture
    Shristi_MP 60 on at
    RE: Can't delete unposted journal

    This was it. After we had a server restart, I was able to go in and clear the lines easily and then delete the journal.

    Thank you everyone!

  • Shristi_MP Profile Picture
    Shristi_MP 60 on at
    RE: Can't delete unposted journal

    Hi Andre,

    Zero error messages. Just frozen AX.

    Regards

    Shristi

  • Shristi_MP Profile Picture
    Shristi_MP 60 on at
    RE: Can't delete unposted journal

    Hi Junaid. Attempt number 2 was through this feature.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Can't delete unposted journal

    Hi Shristi,

    When you mention that several attempts were failing, can you elaborate if you get error messages and which ones?

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees 12,746 on at
    RE: Can't delete unposted journal

    Yeah Ludwig my bad

    @Shristi, Did you tried delete journal line option from journal voucher, it should be available in AX 2012 as well. 

  • Suggested answer
    OsmanIstanbul Profile Picture
    OsmanIstanbul 2,803 on at
    RE: Can't delete unposted journal

    Hi

    As Junaid mentioned, there is same button in ax 2012. It will delete easily.

    Best regards

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Can't delete unposted journal

    Hi Junaid,

    As I understand it, this issue is related to AX2012, not D365FO ;-)

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees 12,746 on at
    RE: Can't delete unposted journal

    Hi Shristi_MP,

    Please enable the below feature from Feature Management and try to delete lines from Journal voucher screen. This feature will improve the performance of deleting unposted journal. The feature wad added in Sep 2020 by Microsoft.

    2703.PNG

    Delete Journal Lines.

    14504.PNG

  • Verified answer
    Aartserp Profile Picture
    Aartserp 60 on at
    RE: Can't delete unposted journal

    Hi Shristi,

    It could be that after a couple of attempts of deleting this journal the tmp database (in SQL) is getting full which makes every effort after it worthless. Deleting the one line should be your best shot of figuring out how to delete the whole journal, but if this is not possible because the tmp database does not have any space (from the settings or the harddrive itself) you'll keep ketting a frozen Dynamics.

    I've been in your situation before and a lot of restarts and trying of different ways of making sure there is enough space and memory solved the problem for me.

    Good luck!

    Remco

  • Oscar Profile Picture
    Oscar 45 on at
    RE: Can't delete unposted journal

    Do you get any feedback or does it just say that it is not allowed?

    Do you have a developer present that could check the delete methods on the journal? (or pre-actions)

    Is there a user that has opened the journal, then there could be a blocking user?

    Br
    Oscar

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans