Dynamics Community Forum Thread Details

How to get Project Invoice Status (using Link To Fabric)? Rebuilding ProjPostTransViewStaging

I am rebuilding ProjPostTransViewStaging using the LinkToFabric tables. I have projitemtrans, projempltrans, projcosttrans, projrevenuetrans and projonacctrans tables. I can get projects, projectids, totalcostamount, totalsalesamount etc BUT I CANNOT generate the InvoiceStatus. I see in the ProjPostTransViewStaging that this is a method called, so appreciate that this is a challenge to begin with, recreating in SQL.

However, using CustTrans and ProjInvoiceJour I can see the invoices and statuses. I can derive whether it is paid or not easily enough. What I cannot do is see which invoice relates to which Line item in my ProjPostTransViewStaging.

For example , in ProjPostTransViewStaging I see ProjId, a category and a total cost amount, BUT I cannot attribute the individual invoices coming from ProdInvoiceJour/CustTrans to the individual ProjectTransactions.

Using Link To Fabric from D365 FnO into DataVerse.

Any help or advice will be appreciated.

Categories:

Dynamics 365 general

Quick Links