SQL Scripts for Microsoft Dynamics GP: SQL Trogger on PO invoice Insert to Change GL posted Date
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script created a SQL trigger on the Posting Definitions Master Dup (SY00500) table to change the GL Posting Date to current date when a transaction is created.
This script was created for a…
Continue Reading azurecurve’s Article on their blog
SQL Scripts for Microsoft Dynamics GP: SQL Trogger on PO invoice Insert to Change GL posted Date
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. This script created a SQL trigger on the Posting Definitions Master Dup (SY00500) table to change the GL Posting Date to current date when a transaction is created.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
Dyn365GP2023.03.22New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Easier to Create Opening Balances for Item Tracked Inventory
Dyn365GP2023.03.22New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Demo Tool and Data for Warehouse and Inventory Scenarios
Dyn365GP2023.03.21New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Catalog Items Use Standard Number Series, Can Include in Blanket Sales Orders
Dyn365GP2023.03.21New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Add More Columns to Pages for Better Insight
