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,...

In this Post i'm sharing a view regarding the Smartlist report of Account Transaction as i linked this view with another tables to get the Manual Payments that are applied to purchase invoices. this view contains the work and history tables. you will find the invoice number, date and the applied amount. USE [Company_NAME] GO /****** Object:  View [dbo].[_AccountTransactionsVSPayementsAndInvoices_AK]    Script Date: 5/21/2018 10:45:50 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[_AccountTransactionsVSPayementsAndInvoices_AK] AS select AccountTransactions.* ,  PM20100.APTVCHNM , PM20100.DOCDATE , PM20100.APTODCNM , PM20100.APPLDAMT , PM20100.APTODCDT from AccountTransactions as AccountTransactions left join PM20100 as PM20100 on AccountTransactions.[Originating Control Number] = PM20100.VCHRNMBR --where AccountTransactions.[Originating Control Number]='00000000000001094' union all select AccountTransactions....

Upgrading the Dynamics GP 2013 R2 has been a challenge for most people so in this post i'm going to set a clear path for upgrading the Dynamics GP 2013 R2 to the 2016 R2 If you got Dynamics GP 2013 R2 with a version like 12.00.1218 you will need to upgrade it to the last version of the GP 2013 R2 which is Version 12.00.2230 ( a hot fix released on January) you can download it from here . Install GP 2016 R2 version 16.00.0675 Open utilities and upgrade the database to the GP 2016 R2  This simple post will walk you through the upgrade with no problem related to the GP versions. If you want to know more about the upgrade and why anyone should upgrade please follow this  Blog post  by Sara Prudy  stating everything with the upgrade. Regards,

Purchasing Fixed Assets through Purchase order processing Use purchase order processing to purchase fixed assets To enter a standard purchase order: 1.     In the navigation pane, choose the Purchasing button, and then choose the Purchase Order Transactions list. 2.     In the New group or its overflow menu, choose Standard Purchase Order to open the Purchase Order Entry window. 3.     Enter a purchase order number or accept the default entry. 4.     Enter or select a buyer ID. 5.     Accept the default date or enter a date that will be used to update your purchasing records. 6.     In multicurrency transactions, the exchange rate used is based on the document date, the currency ID, and associated rate type that’s entered for the transaction. 7.     Choose the Date expansion button to open the Purchasing Da...

Cre a ting M a c r o in M i c r o s oft Dyn a mics GP 1. O p en wh i ch s c r e e n y o u w o u l d t o i n s e r t d at a and don ’ t i n s e r t a n y c h a r [Exa m p l e : H R - - - > P os i t i o n] 2.  St art R e c o r d i n g t h e M a c r o 3.  Na m e your M a c r o 4.  St art i ns e r t i o n o f t h e d a t a 5-  Sto p M a c ro Re c o r d ing 2-  F i l l t h e M a cro fi l e wi t h al l r e q ui r e d d at a f o r u p load . a-  O p en   Macro   c r e a t ed   fi l e   wi t h   Mic r oso ft   W ord b- F r o m M a ilin g Tab --- S e l e c t R e c i p ien t s --> Us e Exi st i n g L i s t c- S el e c t D at a So ur c e [ P r e - p r e p a red F i l e . X LS c o n t a in s a l l r e q u i r ed D a t a f o r each r e c o rd] d- if the excel sheet contains multiple sheets,  s elect wh i ch t ab ...