As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server , I wanted to discuss the related topic about passing of date and time variables.
Analytical Accounting Class Maintenance Error: This record has been created since your attempt to create it. Changes won’t be saved.
WARNING : This post explains a method which is carried out in SQL and also affects an active table record. Consultants / Developers / End Users, who are not aware of GP & SQL processes, MUST NOT carry out this without an experienced consultant’s / developer’s supervision or assistance.
This one is certainly a nasty issue, if we are going to use DEX_ROW_ID value on customization or integration . I have personally fallen into a trap by using DEX_ROW_ID on my customization. But now, it’s all wisdom out of that bad experience
This Quick Tip comes to you courtesy of an idea from my friend, Robert Cavill. On a Microsoft Dynamics GP system where Activity Tracking is being used, it needs to be activated for each User ID/Company ID that you want it enabled for. In most cases, you would want the Activity Tracking enabled for all valid User ID and Company ID combinations.