Hi everyone, it has been a while since I have written an article, but something has happened to us internally that I would like to share with you in case it can help you in your implementations, either end customer or Spanish customers that you may manage.
Since a few months ago we are having an internal audit of our accounting and as such, the auditor asked us to produce a Spanish journal book with all the entries from 2022 to date. A few years ago we implemented internally Dynamics 365 Finance and SCM (hereinafter Dyn365FnO) and as you can imagine, being a consulting firm our main source of income is services and therefore the hours of the collaborators play a fundamental role (project module).
Well, I won’t spend too much time telling you how to extract a Spanish journal in Dyn365FnO, as it is as simple as accessing the option identified in yellow and then having the details of the list of transactions from “Journals recorded in the journal”..
The auditor told us that he did not reconcile the Trial Balance with the Spanish journal and the reality is that this was the case, we found some accounting entries that had not been transferred to the Spanish journal, despite having been generated and posted correctly in the ERP.
After several analyses of these specific entries, it was identified that the audit trail id did not exist and the system had discarded these entries from the journal. After searching and trying to understand why certain accounting records were without an audit trail, we discovered that we had hours recorded from the timesheets themselves, whose Activity they had been allocated to was a Parent node of the Work Breakdown Structure (which is rare, because the system does not allow allocation to parent nodes).
Seeing that this had happened very few times and knowing where the error came from, we started to analyse how to recover these records within the Spanish journal itself.
Our technical team, after debugging the code, found something curious, to say the least, the General Ledger parameter called “Extended accounting journal”:
Although apparently its functionality is based on sorting the report by journal number, magically, we found that when we unchecked it, it included all records, including those with the audit trail omitted.
And with this, happy management, happy auditor and everybody happy… 17 years working with this product and every day it keeps surprising you.
About the Author: Antonio Gilabert
