Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Join (Link) GAE Table ...
Finance forum
Unanswered

Join (Link) GAE Table from inventtrans/purchorderlines/salesorderlines

Posted on by 75

Hi all,

again im struggeling to find a solutions to solve my reporting issue. 

Issue: We are working with batch numer and in the past we had a very unusual way to identfiy the postings in the GAE. We've created the finance dimension Barcode. We did this to track the postings more detailed:

pastedimage1606389425891v1.png

Now i want to make the whole process more efficient and to do that i dont want to update the dimension in the purchase and sales orders. 

What i have in mind is to make a report whhere the finance dept can search for the voucher and the batchid will be diesplayed togehter with the mainaccount and etc.

Because of that, that the posting informations are created by line there must be a way to link them, but i cant find them and therefore im asking you guys.

Maybe one of you have some informations for me.

BR

Amel

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: Join (Link) GAE Table from inventtrans/purchorderlines/salesorderlines

    Hi Amel,

    It's correct. And you can create a new entity for this purpose. Otherwise, you will need to go through documents (invoices, product receipts, packing slips, and so on) which will require more data to be exported to BYOD and I'm not sure if all of these entities are available out of the box.

  • Taric Profile Picture
    Taric 75 on at
    RE: Join (Link) GAE Table from inventtrans/purchorderlines/salesorderlines

    Hi Sergei,

    its a good idea, but unfortunately i cant export the entity to BYOD because it isnt availbable.

    Our system: Dynamics 365 F&O Version 10.0.13

    BR

    Amel

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: Join (Link) GAE Table from inventtrans/purchorderlines/salesorderlines

    Hi Amel Taric,

    You can use InventTransPosting table as a link between GAE and InventTrans (InventTransOrigin).

    There is an old thread about it community.dynamics.com/.../linking-inventtransposting-to-its-posted-value

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,979 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans