SQL View to Extract Accruals from Microsoft Dynamics GP Payables Management Module (Without Joins to RED)

Posted By Ian Grieve on 22 Aug 2022 in Dyn365GP

Back in January 2021 I posted an article which included a SQL view to return accruals from the Payables Management module of Microsoft Dynamics GP. What I forgot at the time was that view included joins into the Revenue/Expense Deferral module which is not part of the standard installation.

I’ve been asked a few times since for aversion which didn;t include the RED joins as a system without…

Continue Reading azurecurve’s Article on their blog

SQL View to Extract Accruals from Microsoft Dynamics GP Payables Management Module (Without Joins to RED)

Back in January 2021 I posted an article which included a SQL view to return accruals from the Payables Management module of Microsoft Dynamics GP. What I forgot at the time was that view included joins into the Revenue/Expense Deferral module which is not part of the standard installation.

Blog Syndicated with azurecurve’s Permission