Microsoft Dynamics GP Enterprise Software Podcast If you are involved in ERP software, no matter what vendor, then the Enterprise Software Podcast is a good aggregator of news and views on the ERP software market. Informative and usually quite light-hearted.The content is product agnostic and is provides an easy way to keep in touch with
General Technology Interest Visual Studio menu font size stuck after presenter mode Presenter mode in visual studio (accessed via the quick launch at top right), allows VS to switch into a larger font layout, ideal for LCD projector presentations. Whilst I had this mode on I had a crash in visual studio and had messed with other settings One of these meant
Microsoft Dynamics GP Bug with Address Name in SOP Entry of Dynamics GP 2015R2 We found on this issue, setting the ship to address from the main SOP entry window in our production Dynamics GP does not pull the correct field from the Ship To Address Name of the address book record into the order Ship To Field. Instead the company name of the
Microsoft Dynamics GP Dynamics GP Drill Down Protocol Handler error When using drill-downs in Dynamics GP the following error message may occur, A error has occurred trying to process your url. To fix this error and solve the problem read on… The error is displayed in the following basic error dialog. There is no information as to what the root
Microsoft Dynamics GP GP Report Writer still gives me nightmares People who have had to set invoice, order, purchase order and every other customer facing document layout to meet the company style guidelines using Dynamics GP report writer will curse when its name is used. It has limitations on image sizes, multiline text formatting, to difficulties in getting data from
Microsoft Dynamics GP Dynamics GP Word Templates does not give option for “Template” in Report Destination Window It all started when I went to do some work on Word Templates in Dynamics GP after a long absence from them (thankfully). This involved setting up a new template, I lost lots of time and then realised my whole Word template experience was broken. Other users were using word
Microsoft Dynamics GP Dynamics GP– Process to invoice only fulfilled and shipped items for scheduled, drop-ship or call off sales orders What are call off orders and scheduled orders? If a customer wants to order 12km of cable supplying for a long running project, but only wants it supplied in 1km despatches over the next twelve weeks, perhaps to different sites. Then this is a call off or a scheduled order.
Microsoft Dynamics GP UK visitor to USA for conference, GPUG summit If you are visiting the USA for a conference there are a few things to remember: Passport Obvious? – well amazing how many people realise at the last moment that the passport is expired. Check it early and get it renewed if its nearly at end of life. Visa Once you
Microsoft Dynamics GP flocking character encoding from a PDF to eConnect In Dynamics GP SOP line detail entry we have a custom helper window whose task it is to automatically create a new inventory item for our sales staff, when they need one for special orders. The work flow is that the details (as shown in screenshot) of the item to
Microsoft Dynamics GP ReIMAGINE 2016 - GP 2016R2 Preview of possible new features The professional GP community are all converging on Fargo, ND in US as I write this for the partner only conference, ReIMAGINE. We are all anticipating more detail on some of the teaser features for Dynamics GP 2016R2 that were released earlier in the year at the Amplify conference in
Visual Studio Duplicate Menu Items Launching Visual Studio with a full drive caused the menus to duplicate, even after restart and making space they remained. I had to use a Visual Studio reset to clear the problem, be warned it messes up your config, you will need to reinitialise your VS extensions. Devenv.exe /resetuserdata
Microsoft Dynamics GP Dynamics GP eConnect taIVCreateItemPriceListHeader & item pricing defaults in IV00101 It should be noted that creating/updating a price list header record using eConnect updates the following item card default field values; * Price level, * Pricing method * Price group * Default selling unit of measure These fields are reflected in the GP GUI here: The taIVCreateItemPriceListHeader is not the clear name for
General Technology Interest Why I find Microsoft One Note handy for blogging UI stuff There are many instances where there are UI elements on screen that you wish to include in a blog post as text content as well as an image, usually for SEO reasons. It can be laborious and error prone to retype from the image into the blog post, so I
Microsoft Dynamics GP Using Visual Studio Database project Dynamics GP & source control Source control of all aspects of a Dynamics GP solution is essential to deliver a reliable, consistent software product or system to the end users. Getting life cycle control of custom objects in the SQL database can be a challenge, even more so when looking at a typical Dynamics GP
Microsoft Dynamics GP Dynamics GP Multiple Bins SOP10203 allocation corruption duplication 1. When a SOP sales order is fulfilled, a record of the bin allocation to the sales order line is made in SOP10203. 2. When the sales order is subsequently converted to a sales invoice, the bin allocation changed to the SOPNUMBE of the newly created invoice. The Bin allocation
Microsoft Dynamics GP GP2016 new feature - Visual Studio SDK Project Template support for VS2015 I blogged about Visual Studio 2015 & Dynamics GP Addin Project Templates “install” in a previous post, but thankfully GP2016 Visual Studio SDK brings the installer of the Dynamic GP Add-In project templates to Visual Studio 2015 without any of that hard work. Something I was thankful of when I
Microsoft Dynamics GP Using Excel to dynamically generate flexible SQL script, fast Sometimes there is a need to quickly “hack” some SQL for updating many records. Using Excel as a tool to do this allows the power of Excel formulas and filtering to achieve quick generation of SQL. Often it can be quicker to use this method to generate lots of simple
IIS Information Manager Microsoft.Web.Configuration.AppHostFileProvider could no load file or assembly If you have this error when clicking on a site or app pool in IIS manager, ensure you are launching the correct version! Using Start menu search and clicking 7 by habit or not paying attention, rather than 10 as it should be for Windows 10… This runs 7 from
General Technology Interest WinDirStat Reminder to self: WinDirStat is a great way to visualise your storage use on a drive http://windirstat.sourceforge.net/
SQL Server SQL bucket filling example permalink I’m frightened that one day this sample disappears, its from a SQL Server Central.com thread, Filling Bucketsoriginally posted by “ChrisM@work.” -- Originally from: -- http://www.sqlservercentral.com/Forums/Topic568498-338-1.aspx DECLARE @AmountToAllocate INT = 21 ;WITH Calculator AS ( SELECT BucketID, TotalSize, Amount, AmountLeftToAllocate = CASE WHEN @AmountToAllocate >
Alternative way to “open command prompt here”–windows hint I was shown this at an MSDN event and use it regularly since. You can open a CMD prompt at the current location from windows explorer, simply by typing in the folder address bar, then hit return. Navigate to location Type “cmd” into the address bar as shown below The
Microsoft Dynamics GP Is eConnect Integration Service Multi-threaded? Personally I have not experienced performance issues with eConnect, so the question to as if the integration service is multi-threaded or now had not crossed my mind before, so here are my thoughts so far after the question popped up. What is the integration service? The eConnect integration service is
Microsoft Dynamics GP Get the System Database name for Dynamics GP To get the system database name (used to be known as the DYNAMICS database) from any GP company, use the following SQL: SELECT TOP 1 DBNAME FROM SY00100 (NOLOCK) When issued in the context of a company database, this will tell you the name of the system database that manages
Microsoft Dynamics GP Prefix “B:” in Dynamics GP script logs When logging operations to script log in GP, sometimes I see “B:” prefixing sections of the script log. Out of curiosity I asked the community what the B: represents. David Musgrave kindly let me know. It turns out to mean that those parts of the script are running on the
Microsoft Dynamics GP Determining when inventory reconcile is running in Dynamics GP If like me you find yourself writing a lot of integrations with Dynamics GP, then you will know that you really should not be messing with data related to inventory whilst the inventory reconcile is processing. Inventory reconcile is responsible for checking that everything tallies up, on summary records. Changing
