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.
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.
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.
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.
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áb230,371Most Valuable Professional
on at
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.
Below is the screenshot of a journal which is posted:
Lines of the journal:
Posted journal is there but lines are not there anymore.
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.