tag:blogger.com,1999:blog-68944181254577894912024-03-13T08:33:58.816-07:00RBS Microsoft Great Plains BlogUnknownnoreply@blogger.comBlogger10125tag:blogger.com,1999:blog-6894418125457789491.post-18178743130220453552009-08-03T14:14:00.001-07:002009-08-03T14:14:43.383-07:00<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3Cz_TwZAPeLNXW00MKgWvO1IWV2RxagWEZqTzQKsqxu3127AxUpLq8dbiDv7EDWwv7SWO6WKUplVVx4FE51jK0z1V6GK3rLpNYmhD70OGA1QFsTJr2bXX-iJi29nhnl_YqsrLRX6xnjs/s1600-h/HandsOnSeminar.bmp"><img id="BLOGGER_PHOTO_ID_5365848982092309538" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 305px; CURSOR: hand; HEIGHT: 400px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3Cz_TwZAPeLNXW00MKgWvO1IWV2RxagWEZqTzQKsqxu3127AxUpLq8dbiDv7EDWwv7SWO6WKUplVVx4FE51jK0z1V6GK3rLpNYmhD70OGA1QFsTJr2bXX-iJi29nhnl_YqsrLRX6xnjs/s400/HandsOnSeminar.bmp" border="0" /></a><br /><div></div>Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-6894418125457789491.post-41196542409937659462009-04-24T07:53:00.000-07:002009-04-24T08:00:37.766-07:00Great Plains Payroll Round 5 Tax UpdateMicrosoft has released the Round 5 tax update. The update includes new state income tax tables for New York, Arizona and California (you don't get any quesses as to whether the tax rates went up or down). The new rates go into effect on May 1st, so don't install the update until all of your payroll checks with an April date have been processed. The update is a tax table update only, so it is installed on one workstation, one time. You can obtain the update at Microsoft Customer Source as well as documentation. You can also use the automatic update to load the new tax tables from within Great Plains. As in previous tax updates for 2009, Version 8 is not supported.Mike Feorihttp://www.blogger.com/profile/15940360558726089666noreply@blogger.com0tag:blogger.com,1999:blog-6894418125457789491.post-64198530328678930722009-04-23T12:37:00.000-07:002009-04-24T08:06:08.902-07:00Great Plains Payroll Round 5 Tax UpdateMicrosoft has released the Round 5 tax update. The update includes new state income tax tables for New York, Arizona and California (you don't get any guesses as to whether the tax rates went up or down). The new rates go into effect May 1st, so don't install the update until all of your payroll checks with an April date have been printed. The update is a table update only, so it is installed on one workstation, one time. You can obtain the update at Microsoft's Customer Source as well as documentation or go to the link provided below. As in previous updates for 2009, Version 8 is not supported.<br /><br />(<a href="https://mbs.microsoft.com/customersource/support/downloads/taxupdates/">https://mbs.microsoft.com/customersource/support/downloads/taxupdates/</a>)Mike Feorihttp://www.blogger.com/profile/15940360558726089666noreply@blogger.com0tag:blogger.com,1999:blog-6894418125457789491.post-90084638431078500932008-02-13T16:23:00.000-08:002008-02-13T16:31:02.139-08:00Reconcile to GL EasilyHave you used this yet? In GP 10 there’s a routine (Microsoft Dynamics GP menu >> Tools >> Routines >> Financial >> Reconcile to GL) that will assist you in reconciling Payables Management and Receivables Management to the General Ledger. This routine matches transactions in RM & PM, to GL and shows the results in Excel.<br /><br />From the GP 10 documentation:<br /><br />During normal business operations, thousands of transactions can be processed. When working with this volume of transactions, standard processes might be inadvertently changed or unintended entries made and posted. As a result, the payables or receivables balances on a General Ledger trial balance report might not match the corresponding balance on trial balance reports printed in Payables Management or Receivables Management. Some specific examples might include the following :<br /><br />• A transaction is posted to—but not through—General Ledger and is deleted before it’s posted in General Ledger.<br /><br />• A transaction is posted to General Ledger, but the amounts are changed before it’s posted in General Ledger.<br /><br />Use the Reconcile to GL window to generate a Microsoft Excel spreadsheet that can help you match transactions in General Ledger with the originating transactions in Payables Management and Receivables Management. This spreadsheet can provide information that helps you enter adjusting transactions that reconcile any discrepancies.<br /><br />Transactions are displayed on the spreadsheet using the functional currency. To be included in the spreadsheet, transactions must be posted and exist in either an Open or History table. Transactions also must include distributions to either the Accounts Payable account or Accounts Receivable account, or the Discount Available account in Payables Management or Receivables Management.<br /><br />The results are categorized as follows:<br /><br /><br /><br /><br /><br /><br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghc97vsF2R5MSns_BiFBx2guVcdisZdorfQUy_oYIwhsGK57MurSmDntexLXssAGKtNIcxNo_GVMcImn4pLbGBMpLtXNpPJ32NhDP2ltwhQaAdLLmEGx0ptNsZoOmWXFQhfqAni16YOWI/s1600-h/GLRecon.bmp"><img id="BLOGGER_PHOTO_ID_5166626620907289138" style="DISPLAY: block; MARGIN: 0px auto 10px; CURSOR: hand; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghc97vsF2R5MSns_BiFBx2guVcdisZdorfQUy_oYIwhsGK57MurSmDntexLXssAGKtNIcxNo_GVMcImn4pLbGBMpLtXNpPJ32NhDP2ltwhQaAdLLmEGx0ptNsZoOmWXFQhfqAni16YOWI/s400/GLRecon.bmp" border="0" /></a><br /><br /><div></div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6894418125457789491.post-40813402905079326742008-01-07T07:51:00.000-08:002008-01-07T07:53:25.542-08:00Got Cubes?“Dimensions, measures, slicers? What are you talking about?” If you are licensed for Dynamics GP Advanced Management, you have access to a powerful analytical reporting tool; Analysis Cubes. Analysis Cubes has been part of the Great Plains systems for several years. It allows you to quickly access information and analyze it in ways that you previously may have not considered. It also provides a strong link to live data through Excel, so you can create reusable reports and refresh the data with one click.<br /><br />Analysis Cubes is easy to install. You just need to install Analysis Services on your SQL Server, if you have not already done so. Then install the Analysis Cubes software (there’s a server piece, and a client piece). When you install Analysis Cubes, the installation wizard will install the DTS packages automatically and will offer to set up a SQL Job to regularly transfer data from the Dynamics GP database, to the Analysis Services database, and “process” the cubes.<br /><br />To use Analysis Cubes, you launch the Create Pivot Table Reports screen within Dynamics GP. This allows you to select one of six cubes from which to draw information, and then export it to Excel. Simple. From there you need to draw on your Excel Pivot Table skills to create the report you want or analyze the data you’re after.<br /><br />There are a few advantages to using Analysis Cubes over just pulling the data into Excel using an ODBC connection. First, as the data is transferred to Analysis Services, additional attributes are created for the data; the most important is that various time values are associated with each transaction, such as month, quarter, year. Second advantage is that the connection to Excel is made for you when you “send” the data to Excel. This makes it a lot easier for end users to get the data into Excel. Additionally, if you want to use other OLAP reporting tools, such as ProClarity, you already have the cubes available for analysis.<br /><br />Certainly if you are already licensed for Analysis Cubes, it is worth your time to try it out. It’s fairly simple to install and adds a whole other reporting and analysis tool you can use to manage your business.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6894418125457789491.post-56338550361182793472007-12-24T08:23:00.000-08:002007-12-24T08:25:33.415-08:00Fear Not. It’s Only Great Plains 10.0<a href="http://www.microsoft.com/dynamics/gp/product/10.mspx">Microsoft Dynamics GP</a>. That’s what they call it now. The name’s slightly different, but most of the underlying functionality is the same; if not improved. So why are business users reluctant to embrace the new version? I suspect it’s because of a few new features that make the product look different and an escalation in technology.<br /><br /><em>New Feature:</em> <strong>Action Panes</strong> add another way to view and act upon data in Great Plains. In the developer’s own words, “a graphical, RoleTailored command bar—inspired by the Ribbon in the 2007 Microsoft Office system. Action Pane allows Microsoft Dynamics GP users to perform actions on multiple records on list pages, enabling users to preview and filter data—without the need to open multiple windows.”<br /><br /><em>New Feature:</em> <strong>Area Pages</strong> put all the transaction, card, inquiry, and report screens in one place. This is one of my favorites. Now you can view and select all the screens of your target series without having to fumble through the menu system.<br /><br /><em>New Feature:</em> <strong>Workflow</strong> functionality was added; but probably not in the way many had expected. Microsoft decided to use existing workflow functionality in it’s SharePoint Server product and extend it to Great Plains. So Dynamics GP 10 comes with six “out-of-the-box” workflow mechanisms tied to existing screens, e.g. Sales Transaction Entry, Purchase Order Entry, Payables Batch Entry. In order to take advantage of this functionality one needs to license and deploy Microsoft SharePoint Server (MOSS) – Enterprise Edition. So this functionality is not for the casual GP installation. But if an organization is committed to implementing automated workflow processes into their operation, this is a very good step to take, because the workflow functionality can be tailored and expanded as required. Plus MOSS includes a robust intranet portal, content management functionality, and enterprise search, that would be a big benefit to many organizations.<br /><br />Really I have not discovered or heard of a decent reason for not embracing Dynamics GP 10, solely on its differences from previous versions. Any user familiar with previous versions, will quickly adapt to version 10, and find at least one thing they like better; probably more.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6894418125457789491.post-88674176580624603422007-11-20T16:29:00.001-08:002007-11-20T16:37:24.889-08:00Time to reorder checks?<span xmlns=""><p>Looking to order :<br /></p><ul><li>Computer check stock?<br /></li><li>Tax Forms?<br /></li><li>Invoice Stock?<br /></li><li>And other forms fully compatible with Microsoft Dynamics GP?<br /></li></ul><p><span style="font-size:130%;">Try: </span><a href="http://www.microsoftbusinesschecks.com/"><span style="font-size:130%;">http://www.microsoftbusinesschecks.com/</span></a><span style="font-size:130%;"><br /></span></p></span><p><span>Be sure to use <strong>Priority code MR4135</strong></span></p>Joe @ Rosehttp://www.blogger.com/profile/15161379599242694649noreply@blogger.com1tag:blogger.com,1999:blog-6894418125457789491.post-49473014921660497342007-11-19T15:44:00.001-08:002007-11-19T15:53:12.725-08:00Dynamics GP 10.0 Service Pack 1 NOW AVAILABLE<span xmlns=""><p>The first service pack for Dynamics GP 10.0 was released on Nov 17, 2007.<br /></p><p>If you are considering upgrading to this version and/or service pack, <strong>we strongly recommend</strong> that you contact your RBS Consultant or CSM for assistance in evaluating whether it is the right time for your business to update Dynamics GP V10 Service Pack 1.<br /></p><p>Considerations to make prior to updating your service pack include testing of any software customizations for compatibility and verifying updates for any 3<sup>rd</sup> party software solutions.<br /></p><p>Listed below are fixes included in Dynamics GP v10 SP1 by selected modules.<br /></p><p><br /></p><h3>Analytical Accounting<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">When you assess finance charges in the Receivables Management, Analytical Accounting distributions are not updated.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">New codes are randomly placed in the budget tree.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When entering a recurring, reversing batch that includes assignments for Analytical Accounting, the assignments are not included after the first time the recurring batch is posted.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When you mark the Post Cash Receipt deposits automatically in BR option in the Analytical Accounting Options window, the posting of the cash receipt creates a deposit automatically. If you check links for the Financial series, all cash receipts are shown to be deposited again in the Bank Deposit Entry window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Analytical Accounting link is removed when editing a purchase order line item.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Copying a purchase order to a new purchase order doesn't copy Analytical Accounting assignments.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you make Analytical Accounting assignments for purchase orders that have multiple line items in the Analytical Receivings Transaction Entry window, the distribution amounts are rounded incorrectly.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you select an account segment in the Account Access to Transaction Dimension Codes window if an account contains letters in a segment.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Vendor information is tracked when the Enable Report on Vendor ID option is not marked.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Posting a transaction from the Payables Batch Entry window does not update the General Ledger posting date in Analytical Accounting.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Analytical Accounting link is removed when editing a purchase order line item.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When you are using Analytical Accounting, the accounts receivable distribution is incorrect when you apply a cash receipt.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Access to Analytical Accounting dimensions previously assigned to a user are removed if you select the user and click Save in the User Setup window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you void a Receivables Management transaction, Analytical Accounting assignments are reversed incorrectly.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you delete a transaction in the Transaction Entry window, dimension codes that were assigned to the previous transaction are removed.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Microsoft Excel® documents close when you are running a multilevel query or a distribution query. You won't have access to the document until the query is finished.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">There are performance issues when importing Analytical Accounting budgets that use 52 periods.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you attempt to access SmartList objects in a company database that you have removed Analytical Accounting from.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs if a $0.00 value is assigned to a distribution account when the vendor record is set up to require Analytical Accounting dimension code assignments for default General Ledger accounts.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you post a bank transaction in a company that doesn't have Analytical Accounting activated.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An unhandled script exception error occurs when matching an invoice to a shipment if both documents use the originating currency, but with different exchange rates.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The transaction date isn't saved correctly if you change the date in the Quick Journal Entry window and use the browse button to move to the next record.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when applying a multicurrency payables transaction.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The default Analytical Accounting values do not display if you reuse a document number that was voided on a different document type.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you run a distribution query in Analytical Accounting.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Analytical Accounting information isn't copied to General Ledger when you post an inventory adjustment.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When you are receiving against two or more purchase orders that are using the same vendor and inventory account, Analytical Accounting distributions are being recalculated.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you are posting a purchase order return when an account linked to a class assigned to purchase order return has a required dimension.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you choose the Financial button in the navigation pane and then choose Analytical Accounts.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When receiving against a purchase order, Analytical Accounting distributions are recalculated.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs if you enter a decrease inventory adjustment for an inventoried item that has more than one decimal place and then view the distribution accounts after making Analytical Accounting assignments.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Changing a user's password removes access to Analytical Accounting codes.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">A warning message should appear when the number of fiscal periods is changed.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An unhandled script exception error occurs when you change the exchange rate in the Payables Batch Entry window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Analytical Accounting information isn't posted to General Ledger after posting a Payables Management manual payment if you change the default accounts payable account that has Analytical Accounting information.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">There are performance issues when exporting a budget with 52 periods and the budget has a large amount of data.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you transfer sales orders to an invoice and then make Analytical Accounting assignments against the invoices, the Analytical Accounting assignments do not update General Ledger.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">There are performance issues with bank deposits if you are using Analytical Accounting.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">A message occurs when a purchase order that doesn't have accounts linked to dimension codes is assigned to an invoice in the Purchasing Invoicing Entry window and you save or post the invoice.<br /></span></li></ul><p><br /></p><h3>Audit Trails<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you attempt to create a purchase order from a requisition and you are auditing the SY01500 (Company Master) table.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">There are performance issues when you add new users to Microsoft Dynamics GP if you are using Audit Trails and Collections Management. Collections Management.<br /></span></li></ul><p><br /></p><h3>Bank Management<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">You can post to a closed period.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When you export transactions from the Bank Management Transaction Enquiry/Void window, transactions that have deposit dates and reconciled dates of 00/00/0000 are displayed incorrectly.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you are importing Bank Management transactions and the chequebook and corresponding bank transaction types aren't set up to use cash document numbering, the same record is retrieved continuously.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs if a sales cash receipt is voided from the Receivables Posted Transaction Maintenance window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you are using the Match to Statement option and have two deposits with the same date and amount, records aren't deleted from the Statement side of the Match Transactions window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An unhandled script exception error occurs when you add a restriction to the CB Tax Analysis query.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">A message about VAT reports occurs when attempting to post a reconcile transaction to a closed period.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When importing transactions, distribution records aren't created.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The amounts display as zero when you print a Historical Cashbook report in detail.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Duplicate deposit numbers are created in multiuser situations.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Cashbook Transaction Enquiry/Void window displays incorrect transactions based on the period selected.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Apply To button isn't available in the Cash Receipts Entry window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Voiding a Payables Management manual payment doesn't update Bank Management records after upgrading.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Cashbook balance field isn't updating after you change the transaction date in the Bank Management Reconcile window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">After upgrading to Release 10.0, bank reconciliation data is corrupt.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you attempt to recover a batch in Bank Management.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when deleting a payment that was imported.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Bank Management Transaction Enquiry/Void window displays incorrect originating amounts for multicurrency bank transfers.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Bank Reconciliation<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you attempt to open the Checkbooks list from the navigation pane if a currency isn't assigned to a checkbook.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">After selecting a date and receipt range, it takes a long time for information to display in the Bank Deposit Entry window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you print the Checkbook Balance Inquiry report.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Collections Management<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">Duplicate notes appear on the Aging Amounts with Notes report if you have entered multiple notes for multiple invoices for a customer record.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Help topics for Collections Management do not appear in Setup Checklist window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you run a query against reminder levels, the query includes all invoices, not just the invoices that have that reminder levels.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The AllInvoicesDetail function doesn't use the query date range when building letters.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An extra field is generated if you are using the @%AllReminderLevelZeroDocuments%@ function when creating Collections<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Management letters<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Field Service<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">The Monthly Price field in the Contract Maintenance – Lines window is rounded rather than displaying the correct price for an item created in the Contract Entry/Update window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you cancel a contract, the revenue amount isn't reversed correctly.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When you enter an RMA (return material authorization), the EXTDCOST and OREXTCST fields in the Sales Transaction<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Amounts History (SOP30300) table are not being updated correctly.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An unhandled script exception error occurs when searching on the Equipid field from the Equipment SmartList.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The revenue recognition period totals are calculated incorrectly.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An incorrect exchange rate is used after you change the currency ID on a service call.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when you post a shipment/invoice receipt that has a serialized item.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When creating a contract from a Sales Order Processing invoice, posting the invoice takes a long time if the invoice has a serialized line item assigned to it.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">You can enter a longer item description in Inventory Control and Sales Order Processing than in Field Service.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">You can't enter a decimal place in the QTY field in the Contract Maintenance – Lines window when the quantity doesn't have decimal places.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">A new contract does not reflect the maximum percentage increase.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">In-transit transfers don't have an account for site segments.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Fixed Asset Management<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">If you run a projection, the current depreciation is cleared for fully depreciated assets.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>General Ledger<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">There are deadlocking issues with General Ledger posting in multi-user situations.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Inventory<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">If you use the Inventory Adjust Costs window to adjust a cost that has quantities transferred to different sites, a credit adjustment is created automatically for the transfer to sites, but the cost isn't adjusted at the transfer to sites.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Average cost items are updated with a $0.00 unit cost and $0.00 current cost when there are quantity shortage overrides and cost adjustments.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The average cost is updated incorrectly because the quantities on hand are incorrect in the Inventory Purchase Receipts (IV10200) table.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you return an average perpetual inventoried item using Purchase Order Returns, the item is returned using the current<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">average cost instead of using the cost on the original receipt.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When creating an inventory transaction from a service call, the document type is not in the Inventory Purchase Receipts Detail (IV10201) table.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The in use value is a negative value or is a zero value in the Item Lot Number Master (IV00301) table even though you didn't sell the lot-numbered item. If the in use value is a negative value, records with blank lot numbers are created in the IV00301 table. If the in use value is zero, the lot attributes are removed during the inventory year-end closing.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">A new purchase receipt generated with a date prior to the date on the oldest purchase receipt for the item doesn't affect the average cost correctly.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">It takes a long time to print the Item Transaction Inquiry Report if you are using a date range and are sorting by date.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An additional cost adjustment entry is generated after receiving quantities of an item at the item's source site at a lower cost.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Manufacturing<br /></h3><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">If different sites and account segment IDs are assigned to components, the WIP (work in process) Materials account does not balance.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you mark a vendor record in the Vendors list and click Edit, the Manufacturing Order Shipments by Vendor window opens in front of the Vendor Maintenance window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Using serialized items causes negative allocations.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Position Numbers are incorrectly incremented when items are added to a super BOM using the Add Items from Option<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Category option.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Two manufacturing orders are generated for an item when the requested ship date is on a down day.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Accounts are incorrect when using a stock count adjustment for a standard cost item.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when attempting to fulfill items multiple times.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An incorrect message appears if the starting serial number is manually entered and doesn't match the serial number mask in the Manufacturing Serial Number Pre-Entry window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">You can't complete or close a job that has manual transactions linked to it.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Issue documents created from an allocate template aren't posted correctly.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Duplicate MO receipt numbers are created after opening the Component Transaction Entry window using the Go To button on the Manufacturing Order Receipt Entry window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When an item that has a phantom BOM is changed to a buy item, the picklist displays a phantom item icon. When MRP is regenerated, all picklist demand for this item is ignored.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The revenue/expense code summary totals in the Actual Job Expenses window are not updated when the revenue/expense codes on a linked transaction are changed.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when printing the Sales Order Cross-Reference report.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Employee hours aren't calculated correctly with backward scheduling in the CRP/MO Detail window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When entering items in the Sales Item Detail Entry window, the items aren't added to the sales order.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Opening the Sales Item Detail Entry window by using a shortcut doesn't update the sales line item.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The cost of the Buy item isn't correct for an archived BOM that is a Buy item and outsourcing costs are associated with the Buy item and rolled up.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">A SQL error occurs if you are running an MRP regeneration and you are using Microsoft SQL Server 2000.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The total cost of the Make item is credited in the purchases clearing account instead of the material cost.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Journal entries are out of balance when standard cost items are processed for a drop-ship invoice.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Payables Management<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">If you pay a vendor by credit card, a new invoice is created for the credit card vendor. When you void the invoice for the credit card vendor, invalid general ledger distributions are created.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you partially pay an invoice for a vendor that has 1099 amounts and then void the check, the 1099 amounts are negative amounts.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Taxes aren't calculated correctly when entering a Payables Management transaction that has tax schedules with more that 25 tax details assigned to them.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Customer Bank Maintenance window and the Vendor Bank Maintenance window are not displaying correct fields.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you change the total purchase amount in the Payables Tax Entry window, the total taxable purchase amount is rounded to the functional currency's decimal places.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Project Accounting<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">You can't build an electronic funds transfer check batch in Payables Management if you have employee expense transactions in Project Accounting.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Billings and Payment inquiry window doesn't display the apply records from the retainer billing.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you are viewing by the originating currency in the Contract Maintenance window, the contract amount is displayed as $0.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs stating that you aren't allowed to exceed the total budget quantity when you are matching an invoice to a posted shipment line item and the budget quantity hasn't been exceeded.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you are using user classes and have posting restrictions for timesheet and expense batches, you can use the Mark All button in the series post window to select all the batches regardless of the security restriction assigned to the class.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">You are not allowed to have negative actual costs.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">You can't modify the amount in the Profit Amount field for a cost category in the Budget Maintenance window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When posting by transaction date, the incorrect date is used.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The project ID and cost category aren't displayed on a Project Accounting Detail Trial Balance Report for a shipment/invoice that has a non-inventoried item assigned to it.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">After changing the quantity to return for a TM (time and materials) Return transaction, the work in progress account is incorrect.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The revenue recognition amount is calculated incorrectly when two projects with fees are billed on the same invoice.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An unhandled script exception error occurs when using the PA Reconcile Utility to reconcile posted billing transactions.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Purchase order returns aren't recognized when using the Reconcile Utility Periodic window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The fee amount calculates incorrectly when using a fee that calculates as a percentage of the baseline revenues.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you enter project information in the Purchasing Invoice Entry window, the Tax field isn't available.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When using the Reconcile Utility Periodic window for a customer that is a third party billing customer on another project, incorrect changes are made to the billing and cost information for that project.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An unhandled script exception error occurs when checking links.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">You can exceed the budget quantity and cost if the taxes are included on the purchase order.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Purchase Order Enhancements<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">An error occurs when upgrading to Release 10.0 if you are using Purchase Order Enhancements and Microsoft SQL Server 2005<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Purchase Order Processing<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">If you use a currency other than the functional currency for a receivings transaction that has an item that tracks lots, the lot splits.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If a receivings transaction has a trade discount, the distributions are incorrect because of tax included in price taxes.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When you use Tax Included in Price tax details and the item uses a periodic costing method, distributions are calculated incorrectly when receiving the item.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When attempting to print a recipient created tax invoice from the Purchasing Invoice Entry window, the report prints blank.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you enter a purchase order return, the quantity returned isn't used in the unit cost calculation when you use the Edit<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Purchase Order window to close the purchase order.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>Receivables Management<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">After changing the batch ID for a saved credit memo, you can change the document type of the document to sales/invoice.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">After changing the default next number in the Cash Receipts Entry window, the next number in the Receivables Setup<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Options window is incorrect.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">A get/change error occurs after you delete a transaction in the Receivables Transaction Entry window and then change the batch ID.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Customer Bank Maintenance window and the Vendor Bank Maintenance window are not displaying correct fields.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If the Include Unapplied Credits option is marked in the Assess Finance Charges window, finance charges are not applied to a national account.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">When reconciling a calendar year for a customer record, a sum range operation error occurs.<br /></span></li></ul><p><br /></p><h3>Sales Order Processing<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">After posting a Sales Order Processing batch, the General Ledger posting journal has additional distributions that don't pertain to the Sales Order Processing transaction.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An error about serial numbers and the item's extended quantity do not balance appears after posting.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you close Microsoft Dynamics GP while the Sales Kit Assembly window is open, data is corrupted.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you are using multiple bins and have line items with markdowns on a sales order, the sales order's extended price is a negative amount when choosing the Fulfill All button in the Sales Order Fulfillment window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The purchase order cost is not transferred to the sales order when receiving a shipment for non-inventoried items.<br /></span></li></ul><p><br /></p><p><br /></p><h3>SmartList Builder<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">If you create a Smartlist using SmartList Builder, the SmartList doesn't show any results.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">If you discard an unsaved SmartList ID, orphaned records are created in SmartList Builder.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">The Value field in the Smartlist Builder Add Restriction window doesn't display a value.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">After linking two or more tables, a SmartList Builder report prints blank.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>System<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">There are selections available for the Printer Class in Named Printers that shouldn't be available.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Named Printers is in an infinite loop when using a template user for the company series.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Taxes aren't calculated if you've marked Enable Reverse Charge Taxes in the Company Setup Options window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Security is not granted automatically to alternate Microsoft Dynamics GP forms and reports for Project Accounting.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">A General Ledger Detail Trail Balance report in Reporting Services doesn't display a date when printing by account segment.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An unhandled form exception error occurs when opening the Reporting Tools Setup window.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">An illegal address error occurs when printing a third party report from My Reports on the home page.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Pressing F1 in Advanced Security doesn't open a help topic.<br /></span></li></ul><p><span style="font-family:Arial Narrow;font-size:10;"><br /></span></p><h3>United States Payroll<br /></h3><ul style="MARGIN-LEFT: 72pt"><li><span style="font-family:Arial Narrow;font-size:10;">If you are sequencing of a tax-sheltered annuities (TSA) deductions, deductions aren't posted to General Ledger, causing transactions to be out of balance.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">You can't use the process server for any payroll task.<br /></span></li><li><span style="font-family:Arial Narrow;font-size:10;">Payroll calculation process is slow if the process includes Arizona employees.<br /></span></li></ul></span>Joe @ Rosehttp://www.blogger.com/profile/15161379599242694649noreply@blogger.com0tag:blogger.com,1999:blog-6894418125457789491.post-87363201078441092752007-11-19T13:50:00.000-08:002007-11-19T14:07:40.929-08:00Close year tips...<p>The end of the year is just around the corner. Here are some tips for preparing your GP database for the New Year:<br /><br />1) Create a backup.<br />2) Check all of your GL accounts to make sure P&L & BS accounts are set up correctly (otherwise P&L accounts won’t roll to retained earning properly).<br />3) Close in the appropriate order, generally:<br />a. Inventory<br />b. Receivables Mgmt<br />c. Payables Mgmt<br />d. Fixed Assets<br />e. Payroll<br />f. Any additional products that have close year processes. You will want to consult those product manuals for close year order (i.e., Manufacturing may have a close that occurs before inventory)<br />g. GL<br />4) Review each module for special steps related to calendar year close versus fiscal year (if different) such as generating 1099’s in AP or W-2’s in Payroll.</p>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6894418125457789491.post-74358598390787594572007-11-01T09:41:00.000-07:002007-11-01T09:42:56.390-07:00RBS Microsoft Great Plains Blog SiteUnknownnoreply@blogger.com0