-
recent posts
- Reconcile Receivable/Payable agings to the general ledger and voids
- Export Payables Detail Historical Trial Balance to excel from reporting services
- Keeping the header rows visible in SQL reporting services
- FRx launcher run-time error 9 subscript out of range
- In Dynamics GP 2013 R2 you can copy/paste a GL entry from excel directly to the transaction entry window
-
most read posts
- Export group name in SSRS 2008 to worksheet tab name in excel
- Change fixed assets from fiscal to calendar year end
- Export the Dynamics GP Payables or Receivables Historical Aged Trial Balance to Excel
- General Ledger Year-End Close
- Specify connection error in Management Reporter 2012 FRx Migration wizard
- MSXML error after installing FRx 6.7 sp9 on Windows 7
- Projects
- Management Reporter Export Report Definition Listing to Excel
- Importing to Dynamics GP without integration manager or SQL
- Consolidations (of multiple currencies) in FRx
resources
Category Archives: Dynamics GP
Reconcile Receivable/Payable agings to the general ledger and voids
Voiding receivable or payable transactions can create differences when reconciling your subledgers to the GL. On the void windows for receivable or payables there are two date fields, one refers to the general ledger and one refers to subledger so … Continue reading
Export Payables Detail Historical Trial Balance to excel from reporting services
Microsoft provides an accounts payable detail historical aging report in SQL report services that I have modified to easily export to excel, here’s what the output looks like: This report originates from the standard report Dynamics GP provides when you … Continue reading
Posted in Dynamics GP, SQL reporting
Leave a comment
In Dynamics GP 2013 R2 you can copy/paste a GL entry from excel directly to the transaction entry window
You’ll need the following columns set up in excel, just copy them to your clipboard (Ctrl+C), be sure to exclude the header row. The column names do not matter but the column order does matter. Open up the GL transaction … Continue reading
Posted in Dynamics GP
Leave a comment
Deletion of GL accounts during the year-end close process
In Dynamics GP when users run the general ledger year-end close some GL accounts may be deleted if the following criteria is met. • No balance• No activity for an open period• No account history amounts• Not part of an … Continue reading
Posted in Dynamics GP
Leave a comment
How do I remove a budget password in Dynamics GP 2010
A client forgot the password for her Dynamics GP budget, here’s a SQL update statement to blank out the password, be sure not to put quotes around the password because it’s not a text field. It should be run against your … Continue reading
Posted in Dynamics GP
Leave a comment
Change fixed assets from fiscal to calendar year end
After changing the GL year end from fiscal to calendar on GP10sp2 by reopening all the history years with Microsoft support we found that fixed assets would not depreciate correctly because it was in the middle of a fiscal year … Continue reading
Posted in Dynamics GP
4 Comments
eConnect error when adding a new Dynamics GP company
During the creation of companies in Dynamics GP version 10 I came across the following error: The following SQL statement produced an error: set nocount on declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for select DOCTYPE from … Continue reading
Posted in Dynamics GP
1 Comment
New features – Dynamics GP 2012
Here are some of the new features slated for Dynamics GP 2012 which is scheduled to be released in 2012. 1. Select a printer after viewing a report onscreen. 2. Print SSRS reports from a GP window (GP report writer’s … Continue reading
Posted in Dynamics GP
Leave a comment
Interview with Ryan Zweng
Ryan Zweng from accountingsoftwaredeals.com interviewed me about Dynamics GP and its usage. Here’s the interview: Microsoft Dynamics GP Overview with Steve Reese In order to expand our coverage of available accounting software options, ASD sought out Steve Reese, an expert … Continue reading
Posted in Dynamics GP
Leave a comment
Export the Dynamics GP Payables or Receivables Historical Aged Trial Balance to Excel
This is a modified Dynamics GP report (see download) I’ve provided to my clients for years that can be exported to a text file and imported into excel that includes the customer ID, name, and the aging columns. Through GP … Continue reading
Posted in Dynamics GP
125 Comments