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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Taric 75 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No