SQL View for to Extract Accruals from Microsoft Dynamics GP Payables Management Module

I recently did a webinar for my employer, ISC Software, on Prepayments and Acruals and as part of the accruals section used a SQL View to extract the accruals to be created; as mentioned in thw webinar, the extract cna be done either using a SmartList or a direct query in SmartConnect.

The SQL view has been created using the EOMONTH function which si available only in later versions of SQL…

Continue Reading Ian Grieve’s Article on their blog

SQL View to Extract Accruals from Microsoft Dynamics GP Payables Management Module

I recently did a webinar for my employer, ISC Software, on Prepayments and Accruals and as part of the accruals section used a SQL View to extract the accruals to be created; as mentioned in thw webi‎…

Blog Syndicated with Ian Grieve’s Permission