DynamicsGP.ie

Implementing Landed Costs in mid stream

2010-03-07T18:44:33Z

Please be careful with this one. I’ve tested it thoroughly and can’t find an issue…but it does involve editing tables through SQL. It is possible that custom reports etc. that are taking data from different tables may not like these changes…so test thoroughly in a test enviornment. But…it worked for me and saved a lot of hassle. Landed Costs Module for Microsoft Dynamics GP really is a superb piece of software – one of those modules that does exactly what it says...(read more)

Localisation of Dynamics GP

2010-02-27T14:50:03Z

Dynamics GP is localised for Australia, Canada, Ireland, Latin America (Andean, Caribbean, and Central America, Mexico, South Cone), Middle East (East Mediterranean, Egypt, Gulf Region, Saudi Arabia), New Zealand, North West Central and East Africa, South Africa, Southeast Asia, United Kingdom, United States, Europe. The international nature of GO thus established, the rest of this post will deal with Europe issues (not just European Union Member Countries) GP has been supporting business in Europe...(read more)

How to identify idle GP sessions – when you’re trying to manage your users!!

2010-02-21T12:14:11Z

One of those great blog posts that solves a request we’ve all been asked at some stage, this one comes via Frank Hamelly , Ron Wilson and Sivakumar Venkataraman and the Dynamics Community ( https://community.dynamics.com/forums/32.aspx ). Check out Frank’s post here: http://gp2themax.blogspot.com/2010/02/gptip42day-track-user-inactivity.html...(read more)

International Enhancements in Dynamics GP 2010 from Mariano Gomez

2010-02-21T11:55:08Z

Vat Daybook is now available to all countries (Hooray!!), ACCON and ETAFI financial report uploads for Belguim and France, and German Tax information extractions. No mention yet of the rolling out of all functionality to all countries? Especially EFT…works great in Europe, seriously reducing the investment required to develop specific file formats for electronic payments. http://dynamicsgpblogster.blogspot.com/2010/02/microsoft-dynamics-gp-2010.html...(read more)

Account is part of an unposted transaction and cannot be deleted

2010-02-21T11:16:17Z

The first port of call was a checklinks on the financial series. Made no difference. I then ran a reconcile on the financial series and repeated the checklinks for good measure. No difference. I then had the idea that maybe the fact that the accounts were entered in the default postings window ( Tools >> Setup >> Posting >> Posting accounts), was causing problems, so I deleted them from this window…made no difference. Racked my brain thinking where else general ledger accounts...(read more)

Audit Trail codes – different prefix’s in different companies Microsoft Dynamics GP

2010-02-03T12:27:50Z

Seemed like a straightforward enough request. Microsoft Dynamics GP 10. Log into the US server, back up the company, create a new company on the Irish server, and force restore the back up into it. However when we started transacting in the US company once it was restored into the Irish server, we encountered problems posting transactions. The transaction posting process would fail as the audit reports were being printed. (If we suppressed printing of audit reports…the posting process completed...(read more)

Belgian VAT Numbers not recognised in Enhanced Intrastat

2010-02-01T18:19:34Z

Came across this one today. Fairly cut and dry solution- download and apply service pack 4! Its a known issue…just wish I had know that before I spent all day trying to figure it out!...(read more)

A Save operation on table GL_Account_MSTR (45) & Dynamics.dbo.aagGetCompanyStatus…when trying to add a new GL account code

2010-01-18T19:37:03Z

To resolve, install a fresh instance of GP on a different mchine and choose to install Analytical Accounting. Then run utilities, added the sample company data (even though I don’t think this is required), and close out of utilities. Then go to MSSQL Management Studio, expand the DYNAMICS database, clicked on Programibility, and then Stored Procedures. Here you will find the aagGetCompanyStatus stored procedure. Right click on this and select ‘Script stored procedure as’ >>’Create...(read more)

DYNSA cannot add / update users or reset passwords in Dynamics GP

2010-01-06T14:37:01Z

You need to add both the ‘dbcreator’ and ’securityadmin’ roles to the DYNSA user ID in MSSQL. Log into System Manager in MSSQL. Expand the ‘Security’ section and then expand ‘Logins’…search down through the list of logins for the DYNSA user. Right click this, and select ‘Properties’. When the ‘Login Properties -DYNSA’ window appears, click on ‘Server Roles’ in the top left hand corner, and tick both ‘dbcreator’...(read more)

NSF – Non Sufficient Funds explained

2010-01-04T20:50:05Z

You receive a cheque from a customer, lodge it to your bank and enter and post it in Dynamics GP. 3 days later you get notice that the cheque has bounced. Its time to post an NSF. An NSF transaction will: Unapply the Receipt and mark it as ‘Voided’…that asterisk we all know and love! Back out the original General Ledger distributions. If you’re using Bank Reconciliation, payments are unapplied, any distributions are reversed. The customers balance is updated to reflect the bounced...(read more)

Clear activity on Bank Management doesn’t.

2009-12-19T14:47:31Z

When you get this message in Bank Management, usually first noticed in the Chequebook Maintenance window, its normally caused by a network error or as the result of a workstation or system crash. The first port of call will always be to clear the Bank Management activity using the standard routine – Tools >> Routines >> Financial >> Bank Management >> Clear Activity. However in some cases this will not actually clear the activity file, presumbly down to the nature and...(read more)

Switched to GP from Sage MAS and achieved 6 month ROI?

2009-12-11T23:00:29Z

Every now and again I find it very interesting, and at times even eye opening, to browse through our extensive library of case studies profiling customers that have moved to Microsoft Dynamics GP from a number of different ERP vendors. Today I decided I would refresh myself on the case studies highlighting customers who migrated from a Sage solution. One in particular that caught my eye was for Winncom Technologies , a former Sage MAS 90 customer that has experienced some VERY significant benefits...(read more)

Update to Dex.ini – this one’s a cracker!

2009-12-10T09:52:53Z

Thanks to Vaidy , I visited Leslie Vails Dynamics Confessor Blogspot and found this little gem. New in version 10, you can now tell the dex.ini where to create reports and forms dictionaries for exploding chunks. No need to explode your chunk and then edit your dynamics.set anymore. Make the pathname a central shared folder and away you go. Copied straight from Leslie’s blog – no apologies!! FormDictionaryPath=pathname ReportDictionaryPath=pathname These are new for version 10 and welcomed...(read more)

EU VAT Legislation – coming 2010 – GP Readiness

2009-12-08T21:43:38Z

The EU 2010 VAT Legislation introduces changes in the following key areas ‘Place of supply’ rules for services. EU Intrastat reporting obligations. Inter EU VAT refund procedures. Introduction of a one stop shop for VAT reporting. Microsft Dynamics is prepared for these changes. Details in the whitepaper listed below: Partnersource Whitepaper download here Customrsource Whitepaper download here...(read more)

Your previous transaction-level posting session has not finished processing

2009-12-03T17:43:42Z

Trying to open a document in SOP and you get told the following? Your previous transaction-level posting session has not finished processing. Please allow time for it to finish. Second most asked question in support…this occurs when posting routines were interrupted for some reason. Back up your Dynamics and company databases. Note down the GP user ID of the session that is getting the error message. Then get everyone out of GP. Go to MSSQL and open a new query window. Run the following query...(read more)

Dex.ini – punches above its weight

2009-10-17T22:27:44Z

For years I laboured away in ignorance until I found a simple solution to a big problem by editing the dex.ini. This whetted my appetite for more! The list of settings below is not exhaustive but hopefully gives you some idea of the power of this little file. To stop the date change dialogue box appearing at midnight – SuppressChangeDateDialog=TRUE Increase / Decrease the number of log in attempts before GP exits – SQLNumLoginTries = number To stop all print dialogue boxes appearing –...(read more)

Support for GP 8 Ends in two days time!

2009-10-11T22:17:23Z

Mainstream support for Microsoft Business Solutions – Great Plains 8.0 will end October 13, 2009 per the Microsoft Support Lifecycle Policy. There has never been a better time to upgrade. We have customers successfully operating GP V10 and MSSQL 2000 if you don’t want to take the big bang approach. If you are on 8, there really is no excuse but to upgrade to 10 at this stage....(read more)

Update on Fourth Schedule VAT

2009-09-04T21:22:00Z

To enable this feature you need to select the ‘Enable Reverse Charge Taxes’ option in Company Set up – (Microsoft Dynaics GP >> Tools >> Set Up >> Company >> Company…and click the Options button). Depending on your set up, you may also need to review the ‘Require Tax Detail Totals to Match the Pre-Tax Amount’ option in the same window. This opens up interesting possibilities for accounting for European 4th Schedule VAT (or indeed any Sales Tax recording where you need to include...(read more)

Business Portal – Invalid Object Name errors

2009-08-26T11:58:00Z

When the user launched the Business Portal website, and navigated to enter a purchase requisition for this new company, they could create the requisition header just fine. They clicked on the Add Item field to open the item selection window. Did a look up on the item numbr field, to display a list of the available items in GP…all fine so far. However, once they selected an item and clicked Select, they got the following message: The multi-part identifier “T2.Null.[CMPTITNM]6″ could no be bound. ORDER...(read more)

Logging scripts in Dynamics GP – from Dan Sionov’s blog – plus update from Mariano Gomez on the support debugging tool

2009-08-25T11:26:00Z

Dan Sionov: http://accountingbot.com/wordpress/?p=61 Mariano’s first look at the support debugging tool: http://dynamicsgpblogster.blogspot.com/2008/08/first-look-at-support-debugging-tool.html...(read more)

Trial Balance from FRx – Nice approach from Victoria Yudin

2009-08-18T22:00:00Z

http://victoriayudin.com/2009/07/17/dynamics-gp-trial-balance-in-excel-using-frx/...(read more)

How to use smartlists to re-create the outstanding transaction report after you have clicked Reconcile

2009-08-14T10:34:00Z

Partnersource: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYKORSXPPNNWUNVVRWRTOXTUNUNPMQQOTSYWSXRXTVLYNPOZXR...(read more)

VIES – VAT Information Exchange System.

2009-08-13T17:01:12Z

The EU established the VAT Information Exchange System (VIES) to deter abuse of the zero-rate sales tax provisions for goods traded in the EU by EU member traders. Each Member State must collect and store specific information about traders and their trades. Basically, if an Irish based trader sells goods to another Irish based trader, then the sales invoice includes VAT (currently say 21.5%). If the same trader sells to a VAT Registered trader in another EU member State, then Zero VAT can be charged...(read more)

Intrastat Module – Intrastat explained

2009-08-07T11:20:06Z

Background. Up to end 1992, all imports and exports of goods between EU (European Unoin) countries were recorded on the SAD (Single Administrative Document)…This had to be completed by companies for each and every consignment of goods they imported or exported to and from other EU countries. In 1993, the Single Market was introduced in the EU, and part of the removal of barriers to trade that this heralded, was the removal of the SAD document requirement. The SAD was a key statistics and Sales...(read more)

Witholding Tax Currency Limitation

2009-08-02T10:48:46Z

The witholding Tax functionality originally designed for Australian Pay as you Go Tax collection is applicable to Irish companies operating Witholding Tax in Ireland. However, it will not operate with non functional currency transactions. This became apparent to me lately whereby a customer who sells the majority of its products in the US, has US subsidiaries, and files in the US, for ease of consolidation made their Irish concern a US Dollar denominated company. When it came to witholding tax on...(read more)