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

(0) Share

Report

Posted on by Taric

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:

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.

Amel

All responses (3)

Answers (0)

Sergei Minozhenko 23,089 on at

Like (0)

Report

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 75 on at

Like (0)

Report

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 23,089 on at

Like (0)

Report

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