General journal lines are deleted after posting

(1) Share

Report

Posted on by AhsanDarr

Hi Experts,

I am having a problem regarding general journals, lines of journals are getting deleted even after posting. Only today's posted general journals have lines, all the previously posted journals don't have lines.

I have checked the clean up journals job but it deletes the complete journals but in my case only lines are removed from the posted journals.

Is there something I am missing? Can anybody help me regarding this?

Note: Same case is happening with counting journal as well.

I have the same question (0)

All responses (11)

Answers (1)

Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

Are you sure the records are deleted? Maybe they're just filtered out for some reason.

Without this answer, there is a risk that you're looking for the cause at a wrong place.

Was this reply helpful? Yes No
AhsanDarr on at

Like (0)

Report

Hi Martin,

Below is the screenshot of a journal which is posted:

Lines of the journal:

Posted journal is there but lines are not there anymore.

Was this reply helpful? Yes No
Verified answer

BillurSamdancioglu 19,850 Most Valuable Professional on at

Like (0)

Report

Hi,

Can you please check if on the jounal name definition it is set to delete journal lines after posting.

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

Unfortunately, your screenshot doesn't address my question. That you don't see something in a form doesn't mean that it doesn't exist. The records may exist, they're just not shown because they're not returned by the query currently used by the form. For example, there may be a filter added in code or by a user.

In short, just looking at the form doesn't tell you that the records were deleted. That's just one of the options. You should test your assumption before you invest a lot of time on investigated based on this - possible incorrect - assumption.

You could use the table browser to verify it. And if it's a non-production environment, you can look directly to database.

Was this reply helpful? Yes No
AhsanDarr on at

Like (0)

Report

Hi BillurSamdancioglu,

As per my knowledge, on Finance journal names, delete lines after posting check is not available as shown in below screenshot of the same journal name:

Was this reply helpful? Yes No
AhsanDarr on at

Like (0)

Report

Hi Martin,

There is no filter added in the journal, no any query from code. No customizations is done. Luckily I have the backup of Production environment before this happened and I restored on UAT environment and there I can see the lines but not in Production environment.

Additionaly, our project was Live on 1 Nov 2023 and since then all the lines were there but on 1 Jan 2024, lines of previous two months got deleted. I can even see the lines of posted journals which are posted in Jan 2024.

Hope this answer your query.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

It's extremely unlikely the lines have been deleted. As Martin points out, they're just not visible in that form. Try querying Voucher transactions (General ledger>Inquiries & reports>Voucher transactions) for that Journal batch number and see what results you get.

Was this reply helpful? Yes No
AhsanDarr on at

Like (1)

Report

Hi Frank,

In voucher transactions, transactions are there but when I click on original document button, there is no journal detail there.

I have opened a ticket with Microsoft, maybe they can help with this unusual issue.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ahsan,

Can you tell us if journals are filled using data import or editing via Excel and the Dynamics connector?

When you use data import, there is an option to truncate data prior to import. That can delete all existing lines.

When you are using the Open in Excel option, when deleting rows from Excel, it will at the moment of publishing delete records from Dynamics 365 as well.

1 people found this reply helpful.

Was this reply helpful? Yes No
Deepak Agarwal 8,602 on at

Like (0)

Report

This remind me of one of the similar issues reported by the customer. Cant recall what was the fix. Looking forward for experts comments here.

Was this reply helpful? Yes No