SQL - How to add Thousands Separator on numbers within SQL

select replace(convert(varchar,convert(Money, @MyValue),1),'.00','')


original post here
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/49e7d563-5056-478a-921d-ec56ae3162c8

Dynamics GP - Incorrect Functional Currency Index - Incorrect Currency Indexes

Whenever you combine companies that have had separate installs and separate dynamics databases, chances are, the currency indexes across the companies are different. Even if the currency name is the same, GP uses the indexes for everything.
You will realize this problem if you are trying to install Management Reporter and you get the error

• You must set up a functional currency for the following companies before the integration can continue

Check indexes in the following tables to ensure the currency indexes in the company match the currency indexes in the dynamics db.

• MC40000 in company
• MC40200 in Dynamics

Update the MC40000 index to match the MC40200 as long as the currency id's are the same

Dynamics GP eOne Extender Standard - Microsoft Dynamics GP Extender will be disabled until it is initialized by the system administrator

1. Install the latest version of extender standard, this issue has been resolved 
2. You may need to rebuild your views manually within extender

How to Open a chm help files - Navigation to the webpage was cancelled

1. Right click chm file
2. Go to properties
3. click Unblock

Original post here
http://social.msdn.microsoft.com/Forums/en-US/devdocs/thread/ef2b95e0-4198-4e1a-b876-314a23348b5e

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