DynamicAccounting.net

November 2009 - Posts

• 0 Comments 414 Views

  Tip on Applying Labor to an Inventory BOM Frank Hamelly is back with a tip on applying labor to an inventory bill of materials in Dynamics GP. Read More... Published: Monday, November 30, 2009, 02:00 AM Tags: Inventory, Manufacturing

• 0 Comments 451 Views

  SQL Code to Get the Most Recent Purchase Receipt for an Item Mariano Gomez took a break from his long Thanksgiving weekend to post a SQL Script to get the most recent inventory receipt information along with more information about on hand inventory. Read More... Published: Monday, November 30, 2009, 01:00 AM Tags: Inventory, SQL

• 0 Comments 248 Views

  Info on Project Accounting General Entries In a new tip, Frank Hamelly takes a look at general entries in Project Accounting. The title is Project Accounting Accruals and Frank uses an accrual example to demonstrate how to use Misc. Log entries. Read More... Published: Monday, November 30, 2009, 12:30 AM Tags: Project

• 0 Comments 316 Views

  Weekly Dynamic: Report Writer Exports to Excel Exporting Report Writer reports to a file for use in Excel is real pain. The headers export as well and lines wrap creating an awful lot of cleanup to make the report usable in Excel. Well the Support Debugging Tool provides an option in the Dex.ini settings... Read More... Published: Sunday, November 29, 2009, 10:00 PM Tags: Troubleshooting, Reporting

• 0 Comments 277 Views

  Information on Negative Payroll Deductions Cindy Mikeworth has a new post up at Total Accounting Solutions looking at Negative Payroll Deductions. Read More... Published: Wednesday, November 25, 2009, 04:00 AM Tags: Payroll

• 0 Comments 284 Views

  Weekly Review: Change Column Names in Smartlists Just in case you forgot this from your original GP training, it's important to note that you can change the titles of columns on Smartlists. This means that "QTY Allocated" can be changed to show "Quantity Allocated" on the smartlist... Read More... Published: Wednesday, November 25, 2009, 04:00 AM Tags: Reporting

• 0 Comments 282 Views

  Info on the Document Date Verify Tool for GP Frank Hamelly takes a look at the available Document Date Verify tool for Dynamics GP. This tool verifies that a document date falls within an existing period in Fiscal Period setup. Read More... Published: Wednesday, November 25, 2009, 03:00 AM Tags: Troubleshooting

• 0 Comments 311 Views

  Solving Win 7 font issues with Dynamics GP David Musgrave has some new insights up at Developing for Dynamics GP. He takes a look at a solution for the problem of overly large fonts displaying by default that can happen when using Windows 7 and Dynamcis GP. Best of all, he provides a fix. Read More... Published: Wednesday, November 25, 2009, 02:00 AM Tags: Troubleshooting

• 0 Comments 249 Views

  Happy Thanksgiving! Tomorrow we celebrate the Thankgiving holiday here in the U.S. so don't expect any updates tomorrow. The Weekly Review will be out later today so take a break and enjoy tomorrow! Read More... Published: Wednesday, November 25, 2009, 01:45 AM Tags: News

• 0 Comments 269 Views

  Interview with Dynamics GP MVP Frank Hamelly DynamicsWorld.co.uk has a new interview up with fellow Dynamics GP MVP Frank Hamelly . Make sure that you check it out. Read More... Published: Wednesday, November 25, 2009, 01:00 AM Tags: News

• 0 Comments 278 Views

  Creating Quick and Dirty Financial Statements in FRx Frank Hamelly's latest tip covers creating a quick and dirty income statement or balance sheet in FRx using account type. Read More... Published: Wednesday, November 25, 2009, 12:00 AM Tags: Reporting

• 0 Comments 292 Views

  GP Error Tracing from Mohammad Daoud Mohammad Daoud has a new post up on tracing errors caused by the language not being set to English in Dynamics GP. Read More... Published: Tuesday, November 24, 2009, 11:07 PM Tags: Troubleshooting

• 0 Comments 335 Views

  WSS or MOSS 2007 What's better for Dynamics GP users, Windows Sharepoint Services (WSS) or Microsoft Office Sharepoint Services 2007 (MOSS)? The answer of course it "it depends". To help you figure out what it depends on, DynamicsBlogger has a nice set of... Read More... Published: Monday, November 23, 2009, 06:02 AM Tags: System

• 0 Comments 267 Views

  Upgrading to SQL 2008 Frank Hamelly gets a little technical with his latest tip as he looks at some great new features in SQL 2008 and SSRS. Read More... Published: Monday, November 23, 2009, 05:00 AM Tags: SQL, Reporting

• 0 Comments 339 Views

  Excel Report Builder: "Wrong Number of Arguments to Replace Text" Over at DynamicsBlogger, Janakiram M.P. has put a bunch of new posts that I'll be highlighting. One of them looks at an error that occurs with service pack 4 and Excel report builder . Janakiram takes us through the issue and the current, temporary... Read More... Published: Monday, November 23, 2009, 04:00 AM Tags: Troubleshooting, Reporting

• 0 Comments 265 Views

  Dynamics Extensions On Thursday, Microsoft announced three new add on services for the Dynamics ERP products. They include Site Service, a web development application, Commerce Service, a multi-channel e-commerce solution and an enhanced version of Microsoft's payment... Read More... Published: Monday, November 23, 2009, 03:00 AM Tags: News

• 0 Comments 279 Views

  Microsoft, SAP and BI Microsoft is tapping SAP's BusinessObjects to help fill the gap after the PerformancePoint debacle. I had heard that this was coming several weeks ago so it's not a big surprise and the eweek article covering it is essentially a press release... Read More... Published: Monday, November 23, 2009, 02:30 AM Tags: Business Intelligence, News

• 0 Comments 284 Views

  Note Lines and GP Web Services Over at Dynamics GP Land, Steve Endow has coverage of formatting note Lines using web services for Dynamics GP . Hint, it doesn't work the way you think it should work. Read More... Published: Monday, November 23, 2009, 02:00 AM Tags: Development, Troubleshooting

• 0 Comments 242 Views

  Accessing a Table Buffer when it is not passed as a Parameter David Musgrave takes a look at accessing a table buffer when it is not passed as a parameter as part of his Three Trigger Technique series. Sure it sounds like something from an old west movie, the three trigger technique, but it's much cooler than... Read More... Published: Monday, November 23, 2009, 01:30 AM Tags: Development

• 0 Comments 264 Views

  Dynamics GP Testing Everyone welcome Alice from the Dexterity testing team! She has her first blog post up at Developing for Dynamics GP. In her first post, Alice tackles test environments and testing automation options . Welcome to the conversation Alice! Read More... Published: Monday, November 23, 2009, 01:00 AM Tags: Development, Troubleshooting

• 0 Comments 338 Views

  Blank Currency ID During an econnect Integration What happens when the Currency ID remains blank after an econnect integration even though the functional currency is set correctly? The DynamicsBlogger has the answer and the fix. Read More... Published: Monday, November 23, 2009, 12:30 AM Tags: Integration, Troubleshooting

• 0 Comments 284 Views

  GP Refund Checks Tim Williams of AMLLP has a new post up looking the often underused GP Refund Checks functionality. Read More... Published: Monday, November 23, 2009, 12:00 AM Tags: Sales, Purchasing

• 0 Comments 266 Views

  Slow Inventory Posting Mariano Gomez is back with a look at why inventory related transactions may be posting slowly. Read More... Published: Sunday, November 22, 2009, 11:00 PM Tags: Inventory, Troubleshooting

• 0 Comments 265 Views

  FRx Transaction Detail Codes for Dynamics GP New at DynamicsBlogger, Janakiram M.P. is providing a handy list of all of the FRx Transaction Detail codes that work with Dynamics GP. Read More... Published: Sunday, November 22, 2009, 10:46 PM Tags: Reporting

• 0 Comments 235 Views

  Weekly Dynamic: Complex Web GoTos in Smartlists Developing for Dynamics GP has covered passing complex parameters through shortcuts in the past. Similarly, I recently had a chance to pass a complex parameter to a web page through a GoTo on a Smartlist. I thought I would spend a few minutes showing... Read More... Published: Sunday, November 22, 2009, 10:24 PM Tags: Fixed Assets