Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

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

(0) ShareShare
ReportReport
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

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans