Dynamics GP

You cant see the delete button anymore after printing the batch or the transaction even though it is just saved and not yet posted, so this is a simple query to switch the printing status of the batch or the document to initial status before printing. update SOP10100 set TIMESPRT = 0  where SOPNUMBE='<insert the SOP document>' After executing the query the delete button will appear in the action drop down list.

Setting up and Deploying  Excel Refreshable reports 1- deploy the excel reports from  Administration> Setup> System> Reporting Tools Setup. - press on the excel reports tab - Choose Network share ( if on folder in shared network ) or choose SharePoint (online or on-premise) - if Network share GP will need a location for the extracted or published excel sheet ( that's supposed to be the shared folder) for example as a Report Server URL: \\<servername>\Reports - Another path will be needed  In the User Level area, enter the location to where Excel reports are stored on each user’s computer. You must use the “%” character as the variable for the Windows user ID in the path. For example: C:\Documents and Settings\%\My Documents\My Data Sources\GP Connections - in the white box below you will find the companies you have in the Dynamics GP,  all items that are not fully deployed are automatically marked. To exclude an item,...