Support for GP 8 Ends in two days time!

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.

Update on Fourth Schedule VAT

I discovered yesterday that you can add a negative sales tax percentage to a Tax Schedule ID in GP!…how long has this been a feature? You learn something new every day.

Business Portal – Invalid Object Name errors

Took me a while to resolve this one. Probably very straight forward for those in the know, but while my front end skills with BP are good, when it comes to the technical back end I probably have a bit to learn!!…anyway, this came about due to a new company being created in an existing GP/BP install. Everything was fine untill the user tried to use the company with Business Portal (to create purchase requisitions). Up front, the install is BP 2.5 with MSSQL 2005 – which is not supported – and first off I had to change compatibility levels…

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

Ever wonder what Dynamics GP is really doing when you press a button on a form? Most Dynamics GP users are already familiar with the Dex SQL Log where you can see the SQL statements that get sent to the SQL Server. But Dynamics GP also offers the ability to log the scripts that are being processed within the Dexterity run-time environment. This article will show you how to use this powerful feature.

Trial Balance from FRx – Nice approach from Victoria Yudin

A customer recently asked me how to export a GP trial balance to Excel. To me there were two options, FRx or modify the GL Trial Balance report to suit Excel..and print it to file. The Frx option was OK, except every time you run it you would need to make sure any new accounts were added to the row format…not so!!!…simple and clever solution from Victoria Yudin…read on!

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

Good Techknowledge I came across today when trying to complete this exact issue:

VIES – VAT Information Exchange System.

Basically Sales Tax reporting. Within the EU, VAT registered traders exporting to other VAT registered traders, charge Zero Rated VAT (SalesTax)…but they must report all such activity to their home country tax authorities.

Intrastat Module – Intrastat explained

A uniquely european module, intrastat.

Witholding Tax Currency Limitation

Witholding Tax calculation only available for functional currencies.

Updating Inventory Decimal Places through SQL

Recently I had to do this. Always best to use standard functionality where available (Tools >> Utilities >> Inventory >> Change Decimal Places)..but the following did the trick for a decimal increase…

update iv00105 set decplcur = 3 where itemnmbr = ‘insert Item Number’
update iv00101 set decplcur = 3 where itemnmbr = ‘insert Item Number’

Remember, you can’t change currency or quantity decimal places if there are any unposted transactions (SOP, POP, Inventory) for an item. Eithre delete or post these first.

 

If you’re decreasing the number of decimal places, all receipts are rounded, and all item records, purchase receipts, quantities, vendor information, and kits are updated. I you are increasing the decimapl places, zero’s get added to all amounts.