Dynamics GP - Sample Report List

Bank Reconciliation Sample Reports	Checkbook Register Report
Bank Reconciliation Sample Reports	Bank Transaction Posting Journal
Bank Reconciliation Sample Reports	Reconciliation Posting Journal
Bank Reconciliation Sample Reports	Checkbook Posting Journal
Bank Reconciliation Sample Reports	Reconciliation Edit List
Bank Reconciliation Sample Reports	Bank Transaction History Report
Bank Reconciliation Sample Reports	Distribution Detail History Report
Bank Reconciliation Sample Reports	Voided Receipts Removal Report
Bank Reconciliation Sample Reports	Voided Transactions Removal Report
Bank Reconciliation Sample Reports	Bank Deposit Worksheet
Bank Reconciliation Sample Reports	Outstanding Transactions Report
Bill of Materials Sample Reports	Assembly Analysis
Bill of Materials Sample Reports	Assembly History Removal Report
Bill of Materials Sample Reports	Assembly Lot Number History
Bill of Materials Sample Reports	Assembly Posting Journal
Bill of Materials Sample Reports	Assembly Serial Number History
Bill of Materials Sample Reports	Component Where Used Report
Bill of Materials Sample Reports	Document Inquiry Report
Bill of Materials Sample Reports	Gross Requirements
Bill of Materials Sample Reports	Indented Bill of Materials
General Ledger Sample Reports	Detail Inquiry Report
General Ledger Sample Reports	Budget vs Actual Inquiry Report
General Ledger Sample Reports	Accounts List
General Ledger Sample Reports	Category List
General Ledger Sample Reports	Budget List
General Ledger Sample Reports	Cross-Reference Report by Journal Entry
General Ledger Sample Reports	Detailed Trial Balance
General Ledger Sample Reports	Quick Trial Balance Summary
General Ledger Sample Reports	Reconcile Report
General Ledger Sample Reports	General Posting Journal
General Ledger Sample Reports	Account Category List
General Ledger Sample Reports	Clearing Entry Edit List
General Ledger Sample Reports	Profit and Loss Statement
General Ledger Sample Reports	Transaction History
General Ledger Sample Reports	Account History
General Ledger Sample Reports	Year-End Closing Report
Intercompany Sample Report	Intercompany Distribution Detail
Inventory Control Sample Reports	Assign Currency Audit Report
Inventory Control Sample Reports	Cost Variance Journal
Inventory Control Sample Reports	Detailed Item List
Inventory Control Sample Reports	Distribution History Report
Inventory Control Sample Reports	Historical Stock Status Report
Inventory Control Sample Reports	Item Allocation Inquiry Report
Inventory Control Sample Reports	Item Class List
Inventory Control Sample Reports	Item Period History Report
Inventory Control Sample Reports	Item Price List Options List
Inventory Control Sample Reports	Item Transaction Inquiry Report
Inventory Control Sample Reports	Lot Number List
Inventory Control Sample Reports	Physical Inventory Checklist
Inventory Control Sample Reports	Purchase Advice Report
Inventory Control Sample Reports	Purchase Receipts Inquiry Report
Inventory Control Sample Reports	Sales Summary Report
Inventory Control Sample Reports	Serial/Lot Trace Inquiry Report
Inventory Control Sample Reports	Stock Count List
Inventory Control Sample Reports	Stock Status Report
Inventory Control Sample Reports	Transaction Edit List
Inventory Control Sample Reports	Transaction History Report
Inventory Control Sample Reports	Turnover Report
Inventory Control Sample Reports	Valuation Method Change Audit Report
Invoicing Sample Reports	Invoice
Invoicing Sample Reports	Inventory Sales Report
Invoicing Sample Reports	Item Inquiry Report
Invoicing Sample Reports	Distribution Detail History Report
Invoicing Sample Reports	Invoicing Transaction History Report
Invoicing Sample Reports	Invoicing Serial/Lot History Report
Invoicing Sample Reports	Inventory Sales Register
Invoicing Sample Reports	Invoicing Posting Journal
Invoicing Sample Reports	Transaction Removal Report
Invoicing Sample Reports	Multidimensional Analysis Sample Report
Invoicing Sample Reports	Account Analysis Report
Multicurrency Management Sample Reports	Account History
Multicurrency Management Sample Reports	Accounts List
Multicurrency Management Sample Reports	Detailed Trial Balance
Multicurrency Management Sample Reports	Exchange Rate List
Multicurrency Management Sample Reports	General Posting Journal
Multicurrency Management Sample Reports	Revaluation Report
Multicurrency Management Sample Reports	Year-End Closing Report
Payables Management Sample Reports	Vendor Financial Summary
Payables Management Sample Reports	Vendor Setup List
Payables Management Sample Reports	Aged Trial Balance with Options
Payables Management Sample Reports	Historical Aged Trial Balance
Payables Management Sample Reports	Payables Currency Summary Aging Report
Payables Management Sample Reports	Cash Requirements Report
Payables Management Sample Reports	Vendor Summary
Payables Management Sample Reports	Vendor Check Register Report
Payables Management Sample Reports	Computer Check Register
Payables Management Sample Reports	Void Open Payables Transactions Posting Journal
Payables Management Sample Reports	Payables Scheduled Payments Posting Journal
Payables Management Sample Reports	Transaction Distribution History
Payables Management Sample Reports	Reconcile Balances Report
Payables Management Sample Reports	Vendor Mass Delete Report
Payables Management Sample Reports	Year-End Closing Reports
Payroll Sample Reports	Detailed Employee List
Payroll Sample Reports	Employees Without Pay Codes List
Payroll Sample Reports	Employee List by Department
Payroll Sample Reports	Employee List by Location
Payroll Sample Reports	Employee List by Supervisor
Payroll Sample Reports	Vacation/Sick Time Available List
Payroll Sample Reports	Earnings Register
Payroll Sample Reports	Employee Pay History Report
Payroll Sample Reports	Check Register
Payroll Sample Reports	Department Posting Journal
Payroll Sample Reports	Vacation/Sick Time Accrual Register
Payroll Sample Reports	Company Benefits List
Payroll Sample Reports	Department Codes List
Payroll Sample Reports	Supervisor Codes List
Payroll Sample Reports	Benefit Summary
Payroll Sample Reports	Payroll Summary
Payroll Sample Reports	Position Summary
Payroll Sample Reports	FUTA Summary
Payroll Sample Reports	Quarterly 941 Preparation Report
Payroll Sample Reports	Calculate Checks Report
Payroll Sample Reports	Year End Employee Wage Report
Payroll Sample Reports	W-2 Statement
Payroll Sample Reports	Direct Deposit (detail list)
Purchase Order Processing Sample Reports	Back-Ordered Items Received Report
Purchase Order Processing Sample Reports	Blanket Purchase Order Delivery Schedule
Purchase Order Processing Sample Reports	Completed PO Removal Report
Purchase Order Processing Sample Reports	Distribution Detail History Report
Purchase Order Processing Sample Reports	Expected Shipments Report
Purchase Order Processing Sample Reports	Invoice Cost Variance Journal
Purchase Order Processing Sample Reports	Purchase Order
Purchase Order Processing Sample Reports	Purchase Order Analysis Report
Purchase Order Processing Sample Reports	Purchase Order History Report (Detail)
Purchase Order Processing Sample Reports	Purchase Orders Generated
Purchase Order Processing Sample Reports	Purchasing Invoice Distribution Detail
Purchase Order Processing Sample Reports	Purchasing Invoice Edit List
Purchase Order Processing Sample Reports	Purchasing Invoice Posting Journal
Purchase Order Processing Sample Reports	Received/Not Invoiced Report
Purchase Order Processing Sample Reports	Receivings Posting Journal
Purchase Order Processing Sample Reports	Receivings Trx History Report (Detail)
Purchase Order Processing Sample Reports	Reconcile Purchasing Documents
Purchase Order Processing Sample Reports	Suggested Purchase Orders Report
Receivables Management Sample Reports	Customer Setup List
Receivables Management Sample Reports	Salesperson List
Receivables Management Sample Reports	Aged Trial Balance with Options
Receivables Management Sample Reports	Receivables Currency Summary Aging Report
Receivables Management Sample Reports	Accounts Due Report
Receivables Management Sample Reports	Sales Analysis Report
Receivables Management Sample Reports	Receivables Posting Journal
Receivables Management Sample Reports	Receivables Voided/Waived/NSF Transaction Posting Journal
Receivables Management Sample Reports	Receivables Scheduled Payments Posting Journal
Receivables Management Sample Reports	Transaction History Report
Receivables Management Sample Reports	Commission Distribution List by Salesperson
Receivables Management Sample Reports	Reconcile Customer Balances
Receivables Management Sample Reports	Year-End Closing Report
Sales Order Processing Sample Reports	Allocation/Fulfillment Exception Report
Sales Order Processing Sample Reports	Deposits Removal Report
Sales Order Processing Sample Reports	Inventory Sales Report
Sales Order Processing Sample Reports	Order
Sales Order Processing Sample Reports	Picking Ticket
Sales Order Processing Sample Reports	Packing Slip
Sales Order Processing Sample Reports	Sales Document Inquiry Report
Sales Order Processing Sample Reports	Sales Document Status Report
Sales Order Processing Sample Reports	Sales Edit List
Sales Order Processing Sample Reports	Sales History Register
Sales Order Processing Sample Reports	Sales Open Order Report
Sales Order Processing Sample Reports	Sales Order Setup List
Sales Order Processing Sample Reports	Sales Process Holds Setup List
Sales Order Processing Sample Reports	Sales Transaction History Report
Sales Order Processing Sample Reports	Sales Transfer Log
System Manager Sample Reports	Check Links Report
System Manager Sample Reports	Company Access Report
System Manager Sample Reports	Company Addresses Report
System Manager Sample Reports	Fiscal Periods List
System Manager Sample Reports	Payment Terms Report
System Manager Sample Reports	Posting Accounts Report
System Manager Sample Reports	Internet Information Report
System Manager Sample Reports	User Security Report
System Manager Sample Reports	Tax Detail ID Report
Value-added Tax Sample Reports	EC Sales List
Value-added Tax Sample Reports	VAT Report
Value-added Tax Sample Reports	Intrastat Trade Report
Value-added Tax Sample Reports	Country Code List
Value-added Tax Sample Reports	Transport Mode List
Value-added Tax Sample Reports	Transaction Nature List
Value-added Tax Sample Reports	Value Basis List
Value-added Tax Sample Reports	Process Type List
Value-added Tax Sample Reports	Commodity Code List

Dynamics GP - Integrating to Dynamics GP-Salesperson ID on SOP line item detail does not integrate

SOP Line Item Salespersons require a Commission Record, or else GP will automatically remove the SRID from the Line Item.

Ensure that you setup an integration to add a corresponding commission line item for the Salesperson you are trying to integrate to the SOP Line Item.
There is a field in the sop header mapping for "Create commissions". Ensure it is set to "True"

Dynamics GP - eOne Smartconnect - tapmtransactioninsert tax table detail does not equal the tax amount

Everything works correctly, your data is wrong.

• Check all of your fields and ensure you are using the correct transaction numbers for the Add Tax Detail Window
• Populate the Purchases Tax Amount in the Add Tax Detail window

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