Home » Listing Details
Top Websites
- Mark Polino's DynamicAccounting.net
Over 3700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 700 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 600 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 400 resources listed. - Microsoft Dynamics Partner Community Blog
Over 400 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Dynamics GP Help
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 200 resources listed. - About Dynamics, Development and Life
Over 200 resources listed. - eOne Business Solutions Blog
Over 200 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 200 resources listed. - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics CPM
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed. - Rose Business Solutions Blog New
Over 100 resources listed. - Microsoft Dynamics GP UK Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
99 resources listed. - Michael Johnson at MBS Guru
96 resources listed.
Useful Dynamics GP Links
| ID: | 9837 |
| Title: | Automatic Aging for GP |
| URL: | http://mbsguru.blogspot.com/2009/04/automatic-aging-for-gp.html |
| Description: | The question came up on the Public GP Newsgroup about automating customer aging in GP. I recalled doing this for some customers in the past and found this method works well. GP calls a stored procedure called rmAgeCustomer to execute the Receivables Aging Process. You can do the same and schedule this to run periodically without user intervention. Run a DEXSQL.log when running that routine to trap this yourself. Below is the SQL that will age all customers, all statement cycles, and all balance types as of the current date. I recommend you test this before deploying in a production environment. DECLARE @O_iErrorState int, @I_dAgingDate datetime select @I_dAgingDate = convert(varchar(10), GetDate(), 102) EXEC dbo.rmAgeCustomer 0, '', 'þþþþþþþþþþþþþþþ', @I_dAgingDate, 127, 0, 0, '', @O_iErrorState OUT SELECT @O_iErrorState http://mbsguru.blogspot.com/atom.xml  |
| Category: | TIPS AND TRICKS BY MODULES: RM (Receivables Management) |
| Link Owner: | |
| Date Added: | June 17, 2010 05:10:22 AM |
| Number Hits: | 19 |
Latest links
- To reconcile employee records in payroll (User Snippet) - Accidental Administrator
- How to change SQL Collation for SQL Server 2008 R2
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- Creating Consolidated Financial Statements using Management Reporter – Consolidating with multiple Dynamics AX 2009 instances (AOS) and/or if currency translation and eliminations are required (Part 4 of 7)
- Learning the Building Blocks of Life through Lego
- Creating Consolidated Financial Statements using Management Reporter – Consolidating with multiple Dynamics AX 2009 instances (AOS) and/or if currency translation and eliminations are required (Part 4 of 7)
- Down Under
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.