web
You’re offline. This is a read only version of the page.
close
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) / AX 2012: Attaching doc...
Microsoft Dynamics AX (Archived)

AX 2012: Attaching document to GeneralJournalAccountEntry

(0) ShareShare
ReportReport
Posted on by Adam Kostecki 215

I'm trying to attach a document or URL to GeneralJournalAccountEntry by creating a record in DocuRef table.

I create it for USMF company and when I try to access these documents through General ledger -> Audit trail -> Voucher transactions I don't see them.

The query in DocuView form uses DataAreaId which in GeneralJournalAccountEntry is inherited from Common table and is always equal to DAT.

Any idea what I'm doing wrong?

*This post is locked for comments

I have the same question (0)
  • Klaas Deforche Profile Picture
    Klaas Deforche 2,433 on at

    The dataareaid is "dat" because the table doesn't store its values per company as the savedatapercompany on that table is set to "no". You should fill the refcompanyId field with "USMF".

    Could you share you code so we can see what is going wrong?

  • Adam Kostecki Profile Picture
    Adam Kostecki 215 on at

    This is what I've got in DocuRef:

    VALUERECID 0

    REFTABLEID 3123

    REFRECID 5637306114

    NAME Invoice

    TYPEID URL

    NOTES https://url_to_my_file.com

    REFCOMPANYID USMF

    RESTRICTION 0

    SMMTABLE 0

    ACTUALCOMPANYID USMF

    PARTY 0

    DOCUTEMPLATE

    CONTACTPERSONID

    SMMEMAILENTRYID

    SMMEMAILSTOREID

    ENCYCLOPEDIAITEMID

    AUTHOR 22565422621

    MODIFIEDDATETIME 41668.8403

    DEL_MODIFIEDTIME 43802

    MODIFIEDBY Admin

    CREATEDDATETIME 41668.8403

    DEL_CREATEDTIME 43802

    CREATEDBY Admin

    RECVERSION 1

    PARTITION 5637144576

    RECID 22565448814

    And in GeneralJournalAccountEntry

    TRANSACTIONCURRENCYAMOUNT -74162.09

    ACCOUNTINGCURRENCYAMOUNT -74162.09

    REPORTINGCURRENCYAMOUNT -74162.09

    QUANTITY 0

    ALLOCATIONLEVEL 0

    ISCORRECTION 0

    ISCREDIT 1

    TRANSACTIONCURRENCYCODE USD

    PAYMENTREFERENCE

    POSTINGTYPE 48

    LEDGERDIMENSION 22565440049

    GENERALJOURNALENTRY 5637189780

    TEXT

    REASONREF 0

    PROJID_SA

    PROJTABLEDATAAREAID

    LEDGERACCOUNT 200110-001-

    CREATEDTRANSACTIONID 5637250983

    RECVERSION 0

    PARTITION 5637144576

    RECID 5637306114

    The problem is that query in DocuView looks for records with REFCOMPANYID == 'DAT'.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans