Journal Types per Module

(0) Share

Report

Posted on by pams.basilio

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.

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

Zain Mehmood 4,311 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Satish Panwar 14,673 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
pams.basilio 425 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
pams.basilio 425 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
pams.basilio 425 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No