Dynamics GP 2013 - Record Macro records an empty file. Macro does not record.

Give your user Explicit Admin Access to the Dynamics GP Program Files Folder

• Go to C:\Program Files (x86)
• Right click on Microsoft Dynamics, Properties, Security, Edit, Add
• Type in your user name
• Check Names, Add, Full Control, Replace on all subcontainers
• Apply
• Macros will record properly now

Dynamics GP 2013, 2015-Integration Manager 12 - The input string was not in a correct format.

You can try this http://support.microsoft.com/kb/2012471
But it didn't help me.

• The Registration keys on your Integration Manager and GP do not match.
• Ensure that you are using the exact same Name in your Integration Manager Key, as your GP Site Key
• You may be running GP and Integration manager with different levels of permissions
• Right click on Dynamics GP and Run as Administrator
• Right click on Integration Manager and Run as Administrator
• Most likely, your data is bad.
• Remove all spaces that do not belong in your data

• Convert everything to text to ensure that when it is exported to your text file, 1 converts to "1" and not 1.00
• This tends to happen with the document type field, make sure there's no decimals
• Use Tab delimited to prevent "," in data from being misinterpreted

Dynamics GP - How to install Purchase Requisition Management for GP 2013

1. Download Business Portal 5.1
1. The download is located on the GP2010 Release Page
2. Download Sharepoint 2010 Foundation with SP1
1. Sharepoint 2010 Foundation
2. Sharepoint 2010 Foundation SP1
3. Cumulative Update Refresh Package Jun 30, 2011
3. GP 2013 Purchase Requisition Management Requirements
1. Confirm that you are registered for Purchase Requisition Management (GP Module Reg)
2. BP cannot be installed on a Domain Controller
3. Workflow is installed
4. Business Portal 6.0 (use 5.1 until 6.0 is released)
1. Sharepoint 2010 Foundation is installed (Sharepoint 2013 will not be supported until GP 2013 SP1 is released)
5. Be a BP Admin
6. Original Requirements List
4. Download the Purchase Req manuals from here
1. Admin Guide
2. User Guide
5. 
   

Dynamics GP - Update User Category Fields and Drop Down Menus

Create another temp table, load it with all your data and the item numbers to update.

update u
set uscatvls_1 = s.dept from iv00101 u
    inner join iv00101_load s on
        u.itemnmbr = s.itemno

Update the Custom Category Lookup Menus
Original Post here
http://www.gp-dynamics.com/dynamics-gp-command-details.asp?id=57

/*
* 1. Load all CUSTOM CATEGORY1 DATA FROM INVENTORY (IV00101)
* 2. Iterate through each CATEGORY1 and check if it exists in the table of CUSTOM CATEGORIES (Must match the category code AND category position)
* 3. If not found then create a new custom category entry in the reference table
* 4. The correct custom category1 of your items should now correctly display when viewed in the Item Maintenance window.
* Note that there are 6 custom category positions so change @ATEGORY_POSITION accordingly. The query below works for the first custom category only.
*/

declare @CATEGORY_CODE char(11)
declare @CATEGORY_POSITION int

set @CATEGORY_POSITION = 1

declare curs cursor for
select distinct v.USCATVLS_1
from IV00101 v
where len(v.USCATVLS_1) > 0

open curs

fetch next from curs into @CATEGORY_CODE

while @@fetch_status = 0
begin
  if not exists(select USCATVAL from IV40600 where  USCATVAL = @CATEGORY_CODE and USCATNUM = @CATEGORY_POSITION)
  begin
    print @CATEGORY_CODE
    insert IV40600 (USCATVAL, USCATNUM) values (@CATEGORY_CODE, @CATEGORY_POSITION)
  end
  fetch next from curs into @CATEGORY_CODE
end

close curs
deallocate curs

Dynamics GP - Increase Smartlist Export Speed

• Go to C:\Program Files\Microsoft Dynamics\GP\Data
• Edit the Dex.ini
• Enter this line SmartlistEnhancedExcelExport=TRUE

Original post

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2010/05/13/smartlist-exports-slowly-to-excel-part-1.aspx

Update a table based on a join with another table

update u
set Description = s.Description
from tabletoupdate u
    inner join readfrom s on
        u.id = s.udid

http://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql

Dynamics GP - Bank Rec Tables

CM20200 - Bank Transaction Header
CM20300 - Bank Transaction Receipt
CM20400 - Bank Transaction Distribution