Dynamics GP - Last time an SOP Transaction was saved/printed/accessed

The DEX_ROW_TS will update to the current time every time a record is saved, printed or otherwise accessed in GP.

Dynamics GP - eOne Extender - Extender Windows do not open after importing solution

Check the DYNAMICS..EXT00001

It should have an entry for each object.

If it is missing ,create the required records for the company you're in

Dynamics GP - SQL View - Receipt PO Numbers for posted and unposted receipts

/** This view will get the min PO number from the posted and unposted receipts
**** Object:  View [dbo].[BI_PORcts]    Script Date: 9/28/2017 10:25:39 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[BI_PORcts]
AS
SELECT        POPRCTNM, PONum
FROM            (SELECT        POPRCTNM, MIN(PONUMBER) AS PONum
                          FROM            dbo.POP30310
                          GROUP BY POPRCTNM
                          UNION
                          SELECT        POPRCTNM, MIN(PONUMBER) AS PONum
                          FROM            dbo.POP10310
                          GROUP BY POPRCTNM) AS RctPO

GO

eOne Smartview - Smartview tables - security access to smartview favorites, lock or unlock favorites

Sometimes, if you accidentally remove access to SA for a smartview, you can never get back in to see it again.

You can manually update the security tables to give access again

You can also use the SV00108 table to force-lock favorites to prevent anyone from making changes.

• dynamics.dbo.sv00100 - Favorites index
• dynamics.dbo.sv00101 - Favorites layout
• dynamics.dbo.sv00102 - Favorites restrictions
• dynamics.dbo.sv00103 - Favorites grouping
• dynamics.dbo.sv00104 - Favorites to Company link
• dynamics.dbo.sv00105 - Favorites security roles (insert security records here to grant access)
• dynamics.dbo.sv00108 - Favorite Lock (Put your favorite id here to lock it from changes, remove it to allow changes)
• dynamics.dbo.sv00110 - Favorites status
• 
  

Dynamics NAV - Export and Import or backup and restore a single company in a database with multiple companies

https://msdn.microsoft.com/en-us/library/dn789595(v=nav.90).aspx


Go To Cronus/Departments/Administration/IT Administration/General

• Export to a Data file - Export company to a file
• Import from a Data File - Import from a file

Dynamics GP - Smartlist Builder - Go To Triggers do not fire in the correct order

Sometimes certain scripts run when the window opens, causing unpredictable behaviour with the way the go to triggers will submit data to the open window.

Most times, if you leave the window open and click the go to a second time, the trigger will work as expected since the code that runs on window open has already run.

• If using a macro, ensure there is one blank line at the end of the macro to ensure the last macro line fires.
• when using a macro, smartlist builder does not wait for the macro to finish before moving on to the next step, which causes conflicts if the macro is affecting fields that smartlist builder is trying to update.
• The wait command stops the entire string of commands, and does not wait after each step
• Either do not use macros, and try to use smartlist builder tasks, or only use macros as the last step

Dynamics GP - SOP User Defined Fields Table

select * from sop10106