100
Hi All,
I'm pulling AX data to a datawarehouse which will be used as source data for business intelligence.
I have pulled the data for GeneralJournalAccountEntry table 2 days ago do the datawarehouse, but when I compare the data today, the recid was not found. Is there any scenario in AX that can delete the record in GeneralJournalAccountEntry or GeneralJournalEntry?
Thanks!
Raymon
Hi raymonmon,
There are transaction text, posting type, and main account fields are available. Could they help to identify the source?
Hi Sergei,
These orphaned transactions have reference to GeneralJournalEntry (it's in RecID format) not zero value. I'm not sure how to confirm these transactions with the financial team since we don't know which legal entities these records belong to (since they don't have GeneralJournalEntry, no DataAreaId can be found) and also no AccountingDate information. Any suggestion?
Regards,
Raymon
Hi raymonmon,
I would say it's better to find all this kind of orphaned transaction and discuss it with the financial department about the origin of these. It could that these transactions are the result of a malfunction. By the way, do you see if these transactions has reference to GeneralJournalEntry or it's zero value?
Hi raymonmon,
I think in all cases records from both tables are deleted. Are you using NoLock hint for DW loads a well?
Hi raymonmon,
As far as I know "Fiscal year close" process can generate GJ transactions for optimization purpose and delete them after. I had the same case with D365 F&O.
You asked if it's possible. But you already found such records so clearly it is possible :)
Again looking at the system, you can see that relation from GeneralJournalAccountEntry to GeneralJournalEntry has related table cardinality "ZeroOne" which means that there could be 0-1 related GeneralJournalEntry records.
Also, there is no delete action that would always delete GeneralJournalAccountEntry records if GeneralJournalEntry is deleted.
I have no idea what kind of situation would cause such data, but at least it's not prevented technically (and if it were, you would not see such data).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (