Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Accounting source expl...
Microsoft Dynamics AX (Archived)

Accounting source explorer

(0) ShareShare
ReportReport
Posted on by sri17 346

Hi All ,

AX 2012 R3 .

After PO / SO invoice is posted , system would create entries in Accounting source explorer form with additional information such as Party Number , Name , Item number ,Name qty , price …. this information would really help for any reconciliation purpose .

The issue is that application not updated party , Item code and Source document details ( SO number or PO number ) details for many purchase / sales invoices in one of the client AX 2012 R3 environment . There are no customizations in the General ledger module .

Could i know the reason ?

One more observation is that similar behavior in D365 PU24 also .

Any light here why item and party information not updated ?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Accounting source explorer

    Hi Ludwig,

    The issue is that, as long as transaction lines have a temporary voucher ao the party of the vendor doesn’t show, while the transaction line gets the info from the purchase order, which always has a vendor.

    Finops should know what the vendor is, but it leaves it blank in the account source explorer report.

    Is there a way to get the code behind this report so we can find out from which tables it gets it’s values?

    Many thanks in advance.

    BR

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting source explorer

    Hello Ive,

    I am not sure if I understood your problem correctly.

    Can you possibly create a new thread and attach some supporting screenprints that illustrate what you try to do?

    Many thanks,

    Ludwig

  • Ive Beeckaert Profile Picture
    Ive Beeckaert 5 on at
    RE: Accounting source explorer

    Hi Ludwig,

    Why are some fields (e.g. Party Name) in certain cases blank? For instance, in case of a product receipt the fields are blank (although information such as supplier name is available).

    Accounting source explorer could be a strong report for a controller (to analyze and report detailed transactions) because you can export it to Excel and slice and dice the information (for example, in a PivotTable). Now, too many fields are blank although information is available (probably in another table).

    How can we fill (for instance) the Party Name with the name of a supplier in case of a registered purchase order?

    Best regards,

    Ive

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting source explorer

    Good Morning sri17,

    I posted a PO packing slip and invoice and see the following in the accounting source explorer.

    accsexpl.png

    For the vendor invoice posting, I can see the party and party name.

    Do you get and/or expect something different?

    Best regards,

    Ludwig

  • sri17 Profile Picture
    sri17 346 on at
    RE: Accounting source explorer

    Hi Ludwig ,

    The simple way to notice the missing data is ….pls create a PO or SO and post invoice , then see the field Party Number and Product field values in ASE form . You would notice blank values .

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting source explorer

    Hello sri17,

    Does this occur for all transactions or only for those that have multiple lines included?

    That is, do you see a difference if a SO/PO with a single line is posted vs. a SO/PO with multiple lines?

    Can you share an example of what you see / miss exactly?

    Best regards,

    Ludwig

  • sri17 Profile Picture
    sri17 346 on at
    RE: Accounting source explorer

    Hi Ludwig ,

    As cited above , when any PO/SO posted , Accounting source explorer form would update with details as Party Number (Vendor/Customer ) , Name , Item code , Item name and source document details ( SO/PO number ) , but for many transactions which were originated from SO/PO does not have above details in the Accounting source explorer form .

    The same issue observed in D365 PU24 also .

    Any light here or still do need any inputs for understanding ?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting source explorer

    Hello sri17,

    What do you mean exactly by saying that ...'that application not updated party'?

    I don't understand that and it would be great if you could provide some additional information/screenshot that helps us understanding the issue better.

    Many thanks and best regards,

    Ludwig

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans