web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Journal Types per Module

(0) ShareShare
ReportReport
Posted on by 425

Dear D365 Community:

There is a long list of Journal Types in Journal Setup form.  As I only use the common ones like Daily, Vendor Invoice, Vendor Disbursement, Customer Payment.  I would like to ask if there is any document that segregates which Journal Type will appear per module (GL, AR, AP, Fixed Asset, Budget, etc).  Example if I setup a Daily Journal Type this will appear under General Ledger.  If I setup a Vendor Disbursement Journal Type this will appear under AP module.  If I setup a Customer Payment Type, this will appear in AR module.  

We need to customize a report which filter the different possible journal types under General Ledger >> Journal entries and on other modules.  This is to make sure I will not leave out any Journal type when the report is designed.  In case the user/admin user creates a Journal type which is not in the original setup, this is to ensure that all the transactions posted in a particular module will be captured/fetched completely.

JournalTypes.jpg

I have the same question (0)
  • Verified answer
    Zain Mehmood Profile Picture
    4,187 Most Valuable Professional on at

    Hi Pam,

    You can get the information from the following link,

    docs.microsoft.com/.../ledger-journal-types

    Currently this information is not accessing due to technical reasons, for that you can see for previous versions information

    docs.microsoft.com/.../about-ledger-journal-types

    Regards,

    Zain

  • Verified answer
    Satish Panwar Profile Picture
    14,671 Moderator on at

    Hi Pam,

    Here is the latest link for D365FO:

    docs.microsoft.com/.../ledger-journal-types

    Thanks,

    Satish Panwar

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • Suggested answer
    Satish Panwar Profile Picture
    14,671 Moderator on at

    Hi Pam,

    Can't find a list that will give the detail of each and every journal type. I assume when you say, user can create new journal type, you mean in "Journal names" form because users won't be able to add anything to the list you have shown above (Requires development and big effort to design the functionality around it). What you can do instead if pull all data from tables and show on report. I guess start with what modules are being used in the implementation and then review those modules / journal rather than reviewing the journal type list and try to go through entire D365 to find references (it's doable but will take more time and you don't really need that information).

    Thanks,

    Satish Panwar

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • pams.basilio Profile Picture
    425 on at

    Hi Satish,

    Yes I meant adding Journal Names.  My reason for this question is that I am trying to determine how to filter out records in a table and come up with 6 individual reports

    General Journal book

    Cash Receipts book

    Cash Disbursement book

    Sales Journal

    Purchase Journal

    Inventory book

    I thought that I can start with Journal type as a main filter/criteria for the report.  Add few more filters specific to each report.

    Thanks,

    Pam

  • pams.basilio Profile Picture
    425 on at

    Hi Satish,

    I was also considering to read directly individual tables i.e.

    CustTrans, VendTrans,InventTrans.  Is this a correct approach?

    What are the tables to filter out General Journal, Cash Disbursement, Cash Receipts?

    Regards,

    Pam

  • Suggested answer
    Satish Panwar Profile Picture
    14,671 Moderator on at

    Hi Pams,

    Most of the journal related information can be retrieved from LedgerJournalTable / LedgerJournalTrans. When the journal is posted it creates record in CustTrans/ VendTrans. Be careful on what you build because journal can be deleted but not CustTrans or VendTrans record.

  • pams.basilio Profile Picture
    425 on at

    Thanks Satish,

    May I reconfirm if POSTED transactions in LedgerJournalTable and LedgerJournalTrans can still be deleted?  Is this a month-end or year-end automated process or this is only a procedure decided on a company basis only if they want to purge record?   

    Also would you recommend that I directly  use the tables below as source data instead of using Journal tables?

    CustTrans,

    VendTrans,

    Inventtrans,

    Bankaccountrans

    I personally think using sub-ledger tables directly would be more straight forward but need confirmation from more experienced resource like you.

    Thanks,

    Pam

  • Suggested answer
    Satish Panwar Profile Picture
    14,671 Moderator on at

    Hi Pam,

    System provide out of the box journal clean up jobs that will help remove LedgerJournalTable/Trans. The reason is these tables are used to create entries in the system, once entries are created in GL, the source can be deleted. The entries in GL remains and if posted to sub-ledger that remains as well.

    CustTrans/VendTrans are the tables that you should use if you are trying to do any reporting for customers / vendors (Assuming you don't get into which sales order etc. created the custTrans). What i haven't gotten so far is what are you trying to achieve from business standpoint.. i have provided response so far based on what you asked.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans