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.

All responses (11)

Answers (1)

Suggested answer

Waed Ayyad 6,493 Super User 2024 Season 2 on at

Like (0)

Report

General journal lines are deleted after posting

Hi @ Ahsan Darr,

Try to add a code to log when the deletion is happening and by whom. Add the code in the delete method before next.

Thanks.

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue
Deepak Agarwal 8,564 on at

Like (0)

Report

General journal lines are deleted after posting

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.
Suggested answer

André Arnaud de Cal... 291,642 Super User 2024 Season 2 on at

Like (0)

Report

General journal lines are deleted after posting

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.
AhsanDarr on at

Like (1)

Report

General journal lines are deleted after posting

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.
Frank Hamelly | MVP... 46,215 Super User 2024 Season 2 on at

Like (0)

Report

General journal lines are deleted after posting

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.
AhsanDarr on at

Like (0)

Report

General journal lines are deleted after posting

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.
AhsanDarr on at

Like (0)

Report

General journal lines are deleted after posting

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:
Martin Dráb 230,371 Most Valuable Professional on at

Like (0)

Report

General journal lines are deleted after posting

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.
Verified answer

BillurSamdancioglu 15,811 Most Valuable Professional on at

Like (0)

Report

General journal lines are deleted after posting

Hi,

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

Like (0)

Report

General journal lines are deleted after posting

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.