Dynamic Code Blocks (Page 9)

Fix sending graphics to Zebra Thermal Printer with GW command -corrupts images

Attempting to print from the RPi over serial RS232 interface using the GW command, I was getting image corruption. Some of the image would appear to wrap, or the image would just not print unless some extra line feeds were added to the end of the command. This was even

Project “Madeira”– Microsoft tackle cloud ERP threat

The big announcement this week was Project Madeira, a new Cloud based ERP solution in Office 365, running as a multi-tenant, from and managed by Microsoft. It is odd that this came a week after the Envision conference and perhaps the fact that the project has not yet got a

Microsoft Dynamics GP

Upgrading GP Addin Mods to use EF6

After adding the configuration sections to Dynamics.exe.config <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> <entityFramework> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.

Windows IoT

UWP Serial Port Missing Bytes, Bytes Written Windows IoT

Whilst writing a PCX format, 1 bit per pixel (1bpp) byte array to a serial port FTDI USB serial adapter using WinRT/UWP, on a Laptop (using for developing before deploying to RPi2), it kept failing to work correctly. The serial port was going to the RS232 input of a

Microsoft Dynamics GP

Dynamics GP window forms flickering-redrawing during Network Group Policy update

Rolling out Windows 10 to our estate has caused an issue with Dynamics GP interacting with Group Policy updates. The users are experiencing the form windows in Dynamics GP vigorously flickering/updating for about five seconds, at regular, but random intervals through the day. Group policy is a set of

Windows IoT

Serial Port null from SerialDevice.FromIdAsync(dis[0].Id) with windows UWP & FTDI adapter

Whilst on a laptop the following code fails whereas it is working on the RPi2. The serial port is provided by a USB to serial adapter, a USB FTDI adapter. var aqsFilter = SerialDevice.GetDeviceSelector();var dis = await DeviceInformation.FindAllAsync(aqsFilter);serialPort = await SerialDevice.FromIdAsync(dis[0].Id); serialPort is null

Microsoft Dynamics GP

Hacking the suggested items feature in GP to create a flexible sales scripting system

In telesales, and ecommerce we have three common directions to take a sale: * Cross selling * Down selling * Up selling The Suggest Sales Item window by default design is intended to suggest other items that could be added to the sales order, on the basis of a trigger item being added

Microsoft Dynamics GP

Installing both msi & msp package together for Dynamics GP “R2” versions

For those with network deployment to consider, around one hundred machines we do, then Dynamics GP has a neat feature to “Create Installation Package”, which does just that. By selecting the option from the installation media it will package up the local fully configured GP client into an msi installer

Microsoft Dynamics GP

Dynamics GP Visual Studio Tools SDK download

I am used to downloading developer resources from MSDN subscriber downloads or MS Dynamics Customer source I lost the SDK for Visual Studio add-in creation with Dynamics GP. After trying to web search for it I didn’t find anything but the links to the GP2013 version downloads. Visual Studio

Windows IoT

Note the missing SPI1 on the new revision of the Windows IoT pinouts for Raspberry Pi

It seems the SPI1 (pins11,35,38,40/GPIO 19,20,21,17) have been assigned to GPIO on the latest pin out. Apparently there are five alternatives for the use of the pins, see:http://elinux.org/RPi_BCM2835_GPIOs Only two SPI devices seems quite constrained when I’

Windows IoT

Windows IoT Core 10 & Raspberry Pi missing Gpio reference

Error CS0246 The type or namespace name 'GpioPin' could not be found (are you missing a using directive or an assembly reference?) Problem that you don't appear to be able to have the Gpio namespaceor spinamespace orI2Cnamespace in your project? Started looking at the Samples for

Microsoft Dynamics GP

SQL Calculate Customer Balance & On Order amount for Dynamics GP

The values in the Customer summary table RM00103 keep drifting from what they should be. This causes issues with our pick list printing service that was using them in a complex credit checking routine. Sometimes the on order amount could be minus thousands of pounds, leading to goods being despatched

Microsoft Dynamics GP

test company, test database, live company in test database, test company in live database…

How times have changed. Now we have a SAN and ESX Hypervisors hosting our servers, virtualisation and new hardware platforms have made managing enterprise infrastructure so much easier. For developers this had made possible the cloning of live environments, yes webservers, databases, ERP and various integrations can all be plucked

Microsoft Dynamics GP

Dynavistics acquire rights to Trinity (m-hance) source code

The news article linked below reveals that Dynavistics have acquired rights to develop the Myridas products that were acquired themselves by m-hance when they absorbed Trinity Computers during the m-hance acquisition run that achieved a 45% sales growth for the m-hance in 2012. Dynavistics Acquires the Right to Develop Trinity

Microsoft Dynamics GP

Enabling Dynamics GP Modules

It can be confusing where in the GP user interface that functionality in GP is enabled from. It can seem like there is no consistent place to go in order to enable functionality. In this post I’m quickly just going to show some examples and leave it at that…

Visual Studio 2015 Licence Error (0x00000002): Unable to save downloaded online licence

I just experienced this error in Visual studio with a sole button to “close visual studio”. It happened on opening projects. I ended up having to log out of my MSDN account on that same error window and back in again before it would allow me forward. Clicking the “Check

Microsoft Dynamics GP

Solution to eConnect Requester SOP Transaction trigger not creating output records

eConnect uses a Document Requester system to allow database activity in GP to be tracked, say for the creation of sales orders. It also allows the database to be queried via the eConnect API, without any logging to output tables. Steve Endow has written up here on his blog, 8

Microsoft Dynamics GP

eConnect fails to update field ITMVNDTY (IV00103) from field PRIMVNDR (IV00102)

Why does eConnect not update the IV00103 ITMVNDTY field when changing the primary vendor, PRIMVNDR of IV00102? Table IV00102 item-site This table relates items to sites, including what stock is at each site and which primary default vendor should be used for that site. The default vendor is held in

Microsoft Dynamics GP

Custom links example in Dynamics GP

A post on the Dynamics GP community forum reminded me of something I set up way back, custom links for linking to an item on a website from GP. Dynamics Community Forum for GP Custom Links Custom links are supported for a limited number of prompts within GP; * Chequebook * Credit

Microsoft Dynamics GP

Dynamics GP Fix “Amount Remaining” incorrect on receivables transaction payment apply

For the following Debtor, the GP client server connection was interrupted whilst payments were being applied. This left the apply in an inconstant state. Subsequently the payment was unapplied, leaving the “amount remaining” for the payment double what it should be. This is because removing the apply has “credited” the

Microsoft Dynamics GP

Custom eConnect XML Node–Procedure or function expects parameter, which was not supplied

Custom XML nodes error with parameters It is possible to run your own custom stored procedures from eConnect, by passing in parameters via a custom XML nodes. I have explained this technique in a previous post, there is more information on MSDN too: * This Blog: Using custom nodes in eConnect

Microsoft Dynamics GP

SalesPad Mobile Installer

I love the “View Update SQL” button on the SalesPad mobile server installer. This button generates the SQL that is about to be executed against your GP database into a notepad window for inspection. It was reassuring to see and understand what was about to be done to the database.

Microsoft Dynamics GP

Server drop down in Dynamics GP login not showing DSN connection 64bit machine

We have all been there, tired and forget that if the machine is running on 64bit, the WOW64 process is looking after you and the ODBC connection for GP needs setting up in the 32 bit version of the ODBC manager. This catches me out from time to time as

SQL Server

SSMS locked / frozen after network disconnect or computer sleep

When both the following are true: * the machine is woken from sleep or the network connection has been interrupted to SQL server * SQL Server Managment Studio Activity Monitor was open on a tab somewhere in the editor deck in SSMS. -then It will be no longer be possible to interact

Microsoft Dynamics GP

Developing against Dynamics GP Multiple Bins, tables used

Quick guide to data flow when working with Dynamics GP and multiple bins. Inventory levels As is normally the case, stock levels are maintained by IV00102, in fields QTYONHND (quantity on hand) and ATYALLOC (quantity allocated). When multiple bins is enabled (see post: TSQL determine inventory MultiBinning is enabled in