We have D365 F&O tables being exported to our data warehouse via a PowerApps Synapse Link. My current goal is to display transactions from the GeneralJournalAccountEntry (and GeneralJournalEntry) tables and where that transaction is a vendor invoice or receipt to show the associated Purchase Order and PO Line Number.
I have the transactions displaying, and the PO number is displayed correctly, being joined with VendInvoiceTrans on purchid. This is working correctly and for a given PO, I can see the transaction lines for each PO line (but not identified by PO line) in both tables.
The problem is I don't know how to link the tables by PO line. In GJAE/GJE, there's no unique identifier for a set of lines for a given PO except for recid. In VIT, there's an inventtransid unique identifier. For the journal tables I feel like I'm missing a join since there's no unique PO line identifier (unless it's via recid in another table), and on the vendor invoice side, the literature I could find refers to the InventTrans* collection of tables. I have imported these from Synapse, but they're all empty.
Can anyone help me find this missing link?
16
Share
Report
All responses (
Answers (
