News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) how to check where the...

Microsoft Dynamics AX (Archived)

how to check where the IC journal originated from

(0) Share

Report

Report

Posted on by MYGz

1,858

Hi,

If I post a customer transaction of a different company, it will create an IC journal for that transaction in that company. How can I traceback where the IC journal came from from SQL server?

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

RadKlai 40 on at

Like (1)

Report

RE: how to check where the IC journal originated from

Hi MyGz,

You need to go to the History tab on the journals grid and check the original Journal number(originator of the IC) in "Original Journal No."

Thanks,

Rad
Verified answer

MYGz 1,858 on at

Like (0)

Report

RE: how to check where the IC journal originated from

Hi Tom Cai,

I don't think you understood my question.

I got the solution, to track the original company and Intercompany voucher we can check these two fields in ledgerjournaltrans table:

ForeignVoucher

ForeignCompany
Community Member Microsoft Employee on at

Like (0)

Report

RE: how to check where the IC journal originated from

Hi MYGz,

You can configure database logging to trace from the database level :docs.microsoft.com/.../configure-and-manage-database-logging

Best Regards

Tom Cai

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans