Hi everyone
I'm busy reporting on GeneralJournalEntry. On browsing the data, I noticed that thousands of records have a JournalCategory that is blank.
Why is it blank? Should it be blank? Is this a problem? How do you resolve it?
My problem is a repeat of this unanswered question:
https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/303512/generaljournalentry-journal-category-missing
Any help appreciated.
Thanks
Hello,
Can you share the scree shot?
Sure
Hello BrandonSA,
I don't see this journalcategory field in my demo machine.
Is this a customized field?
Best regards,
Ludwig
Thank you.
Which form is this? general journal?
Hi BrandonSA,
JournalCategory extends LedgerTransType Enum.
In LedgerTransType ,there is a None value, the None value is displayed as blank on the page.
You can check the database, you will find that there are many entries with 0 in the table, you can confirm whether the data you see is also 0.
Hi Ludwig and Ramit
Thanks for the answers. Not a customized field, standard Ax.
It's UI label is Transaction Type. I can check this field via voucher transactions as well and it's blank there too (naturally reflecting the value in the table). On voucher transactions, I view record info, and all fields. It's transaction type.
Tx
Thank you for the details.
if your query is related to "transaction type" then its out of box function.
It comes from module you are booking the transaction, such as if you book free text invoice then the type will be customer and for invoice journal type is vendor.
Can you please check the blank values from where those were booked?
Hi Brandon,
I see.
Why do you have to report on the transaction type?
I mean, why aren't the ledger accounts and findims sufficient for generating your reports?
I commonly use the transtype for checking if something was posted incorrectly and does not reconcile e.g. with inventory but I have not used it for creating a financial report.
One of the reasons are the blank values that Blue Wang mentioned.
Another reason is that we have usually a lot of findims and main accounts that should be sufficient for analyzing data.
Can you actually let us know what kind of report you try do generate with the transtype?
Hi Ludwig
Thanks for your reply.
Sorry, i wasn't very clear with regards to my purpose. I'm not reporting the data of that field. I just need to use that field as a filter criteria.
I'm trying to (for example) pick up all GeneralJournal entries, and only those.
There are other sets of data i'm trying to retrieve too, but that's an example of how I'm trying to use the field.
Hi Blue
Thanks, I understand that. What is the point of the field then. It's useless if it should contain 'General Journal' but contains blank instead.
Why is it blank? Why doesn't it correctly reflect the type of transaction it is? Is it a bug, or is there reason for this?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,122
André Arnaud de Cal... 918 Super User 2025 Season 2
Sohaib Cheema 646 User Group Leader
