Hi Experts,
I’m trying to test a Reverse estimate eliminations on Periodic of Project Management & Accounting But wonder if this result of test is something wrong because of always having below query. the point is to see WIPEliminated = 0 but WIPEliminated = 1.
SELECT * FROM ProjWIPTable(ProjWIPTable_1) WHERE ((WIPEliminated = 0)) AND ((ProjId = N'00000100')) JOIN * FROM ProjTable(ProjTable_1) ON ProjWIPTable.ProjId = ProjTable.WIPProject
But When I try to test a Reverse estimate eliminations on Estimate of Project Management & Accounting, I can get a good query as below,
SELECT * FROM ProjWIPTable(ProjWIPTable_1) WHERE ((WIPEliminated = 1)) AND ((ProjId = N'00000100')) JOIN * FROM ProjTable(ProjTable_1) ON ProjWIPTable.ProjId = ProjTable.WIPProject
My question is even if the same batch(ProjControlPeriodEliminateRev), I wonder why the query is different .
In case of Form;
In case of Periodic batch(ProjControlPeriodEliminateRev);
I was refer tohttps://docs.microsoft.com/en-us/dynamics365/finance/project-management/eliminate-project-estimate
I'd be glad if you give me a good solutions.
Thanks
