Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Data entity for vendor...
Finance forum
Unanswered

Data entity for vendor Invoice Journal attachments

Posted on by 20

Hello community,

I'm working on attaching files to a vendor invoice journal in the AP Module using a data entity through Power Automate. I based my data entity on the General Journal data entity (LedgerJournalAttachmentsEntity) after seeing it recommended for invoice journals. However, it hasn't worked, and I'm having this error: "The value 'XXXXXX' in field 'Journal batch number' is not found in the related table 'Ledger journal table'." Does anyone know which entity I should use for this case? I need to attach the file to the Header only.

Thanks in advance!

Mario C.

  • Data entity for vendor Invoice Journal attachments

    Hello,

    The problem it’s not with the attachment itself, I’m using a data entity based on LedgerJournalAttachmentsEntity, but it only seems to work with Journal Batch Numbers from General Journals, which are part of the General Ledger Module. Both vendor invoice journals and general journals are stored in the same table (LedgerJournalTable), and the only difference between them is the journal type. It’s confusing that when the data entity searches the table by journal batch number, it can find general journals but not vendor invoice journals. I feel like I might be missing something here.

    Hope that makes sense.

    Thanks!

  • Layan Jwei Profile Picture
    Layan Jwei 4,783 Super User on at
    Data entity for vendor Invoice Journal attachments
    Hi,
     
    I'm not sure if this is the correct entity. But as a start can you try and upload the attachment manually first from the form, then if it works try to do that via DMF by importing the attachment. If it succeeded it might be an issue of how you are using power automate. So let's try doing it manually via DMF as a start and let us know if it works and if it adds the attachment to the record.

    Also the error is saying that u have wrong value in the field. So make sure that this field value really exists in d365fo

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans