DynamicsGP.ie

Implementing Landed Costs in mid stream

DynamicsGP.ie — Sun, 07 Mar 2010 18:44:33 GMT

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...(read more)

Localisation of Dynamics GP

DynamicsGP.ie — Sat, 27 Feb 2010 14:50:03 GMT

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...(read more)

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

DynamicsGP.ie — Sun, 21 Feb 2010 12:14:11 GMT

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...(read more)

International Enhancements in Dynamics GP 2010 from Mariano Gomez

DynamicsGP.ie — Sun, 21 Feb 2010 11:55:08 GMT

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...(read more)

Account is part of an unposted transaction and cannot be deleted

DynamicsGP.ie — Sun, 21 Feb 2010 11:16:17 GMT

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...(read more)

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

DynamicsGP.ie — Wed, 03 Feb 2010 12:27:50 GMT

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...(read more)

Belgian VAT Numbers not recognised in Enhanced Intrastat

DynamicsGP.ie — Mon, 01 Feb 2010 18:19:34 GMT

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

DynamicsGP.ie — Mon, 18 Jan 2010 19:37:03 GMT

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...(read more)

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

DynamicsGP.ie — Wed, 06 Jan 2010 14:37:01 GMT

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...(read more)

NSF – Non Sufficient Funds explained

DynamicsGP.ie — Mon, 04 Jan 2010 20:50:05 GMT

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...(read more)

Clear activity on Bank Management doesn’t.

DynamicsGP.ie — Sat, 19 Dec 2009 14:47:31 GMT

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...(read more)

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

DynamicsGP.ie — Fri, 11 Dec 2009 23:00:29 GMT

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...(read more)

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

DynamicsGP.ie — Thu, 10 Dec 2009 09:52:53 GMT

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...(read more)

EU VAT Legislation – coming 2010 – GP Readiness

DynamicsGP.ie — Tue, 08 Dec 2009 21:43:38 GMT

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...(read more)

Your previous transaction-level posting session has not finished processing

DynamicsGP.ie — Thu, 03 Dec 2009 17:43:42 GMT

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...(read more)

Dex.ini – punches above its weight

DynamicsGP.ie — Sat, 17 Oct 2009 22:27:44 GMT

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...(read more)

Support for GP 8 Ends in two days time!

DynamicsGP.ie — Sun, 11 Oct 2009 22:17:23 GMT

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...(read more)

Update on Fourth Schedule VAT

DynamicsGP.ie — Fri, 04 Sep 2009 21:22:00 GMT

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...(read more)

Business Portal – Invalid Object Name errors

DynamicsGP.ie — Wed, 26 Aug 2009 11:58:00 GMT

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...(read more)

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

DynamicsGP.ie — Tue, 25 Aug 2009 11:26:00 GMT

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

DynamicsGP.ie — Tue, 18 Aug 2009 22:00:00 GMT

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

DynamicsGP.ie — Fri, 14 Aug 2009 10:34:00 GMT

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

VIES – VAT Information Exchange System.

DynamicsGP.ie — Thu, 13 Aug 2009 17:01:12 GMT

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...(read more)

Intrastat Module – Intrastat explained

DynamicsGP.ie — Fri, 07 Aug 2009 11:20:06 GMT

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...(read more)

Witholding Tax Currency Limitation

DynamicsGP.ie — Sun, 02 Aug 2009 10:48:46 GMT

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...(read more)