-->

Wednesday, July 22, 2015

Dynamics GP - Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

I have been doing a fair bit of explanation around Cashbook Management and Bank Reconciliation modules in GP over the past few weeks. I found the explanation from Brian Wick below was pretty good. To add on to his excellent explanation – here are a few additional items -

Cashbook Management -

  • Cashbook has support for more Multicurrency transactions. They can do bank transfers in as many as four currencies at the same time for instance whereas Bank Rec allows just two
  • Easier to track Tax with Bank Transactions (However, you should typically be using AR/AP modules in GP and let tax flow from there) . I’ve heard the argument from some customers that they have been told that this is the only way to track tax when accounting for GST or VAT. That is NOT correct! 
  • Support for more transaction types such as GL Checks and RM Checks with don't really have a counterpart in the Ban Rec product
  • No eConnect Import Interface

Bank Reconciliation

  • More commonly Used, better and easier to support 
  • Works well and meets most requirements other than the 4 currency bank transfer requirement discussed above.
  • Has eConnect Import Interface

Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

(Bank Management (BM) refers to both CBM and EBM)

The major difference between Bank Management and the Bank Reconciliation is that the Bank Reconciliation receives most of it transactions from other modules. Debtors and creditors cash transactions are captured in RM and PM and Bank Reconciliation is updated accordingly.

You can capture all your cash transactions in Bank Management and RM, PM and GL will be updated accordingly. The windows updated in Great Plains are RM Cash Receipts, RM Transaction Entry (payments to debtors), PM Manual Payments, PM Transaction Entry (receipts from creditors) and GL General Entry.

However in the CBM transactions captured in PM transaction entry, RM transaction entry, SOP, invoicing and PM computer cheques also update CBM in the same way that Bank Reconciliation is updated.

The reconcile functions in CBM and Bank Reconciliation are very similar so the major difference between CBM and Bank Reconciliation is that Bank Reconciliation receives transactions from other modules and Bank Management is a single point of entry for all cash transactions. All other differences are in functionality: Batch processing, full multicurrency, Electronic Reconcile Management (Auto Bank Recon), Intercompany Payments and Deposits, Intercompany many to many Bank Transfers, Payments to Debtors and Receipts to Creditors ext.

The difference between the CBM/Bank Reconcile and EBM is due to the fact that in EBM you do not have any source documents (Cheque counterfoils, Deposit slips ext.) as 90% of the transactions are done via electronic transfer. So the first time we find out about a transaction is when it appears on the bank statement.

In CBM and Bank Reconciliation we capture our transactions from source documents (Cheque counterfoils and deposit slips) and then reconcile the transactions that are on the bank statement to the transactions that we have already captured.

In EBM we capture our transactions from the bank statement and then post the transactions to RM, PM and GL. As the source document is the bank statement there is no need to do a separate reconcile so the post and the reconcile is one process.

In EBM we do however allow for transaction that originate form counterfoils and deposit slips. When this happens the user will capture these transactions in RM and PM but instead of posting to the Bank Account the transactions will post to a Holding account. When the transactions appear on the Bank Statement they will be captured as normal and then matched to the original transactions in the Holding Account. Regardless of the type of the transaction (GL, AP or AR) EBM will create GL transactions moving the money from the Holding account to the Bank Account. Thus the Bank Account will only be affected by transactions that have appeared on a bank statement. By doing this the Bank Account will always have a true balance.

So the difference between CBM/Bank Reconcile and EBM is that CBM/Bank Reconcile are driven by source documents and EBM is driven by the Bank Statement.


Best regards,
Brian Wick
Partner Online Technical Community

Wednesday, April 8, 2015

Kinect 2 Tutorial on Tracking Strategies


Microsoft has published a set of great tutorials for making applications with Kinect 2. http://kinect.github.io/tutorial/ These detailed hands on Lab/Tutorials for V2 were published last month.

I highly recommend the tutorial on tracking strategies - for keeping the application accurate when multiple people are in the room.

http://kinect.github.io/tutorial/lab14/index.html

This lab will explain the following:

Tracking a user who is the first to be seen.
Tracking the user who is the closest to the Kinect 2.
Tracking a user who is the most active in the scene.
Tracking several people simultaneously.

Monday, April 6, 2015

Microsoft Virtual Conference Sessions–May 14 & 15

As part of the MVP Virtual Conference – there are a range of sessions from Azure, to BI that you can attend for free. Register here - http://mvp.microsoft.com/en-us/virtualconference-sessions.aspx

Here are some I am keen on attending -

Detecting Facial Expressions with Azure Machine Learning and Kinect for Windows

Speaker: Dwight Goins

Moderator: Gian Paolo Santopaolo

This session is about learning how to use Microsoft Azure Machine Learning with the Kinect for Windows in order to detect Facial expressions. This session will cover an introduction to Machine Learning, and different algorithms used to detect data patterns. The algorithms discussed will be nearest neighbor, probabilistic learning, decision trees, and neural networks. It will also cover an introduction to the Kinect for Windows device, such as explaining the features and capabilities of the device and SDK. The session will show basic demos and data coming from the device. The session will then drill down into HD Face and describe the data which is generated from Face and HD Face tracking. Lastly the session will show a demo and provide steps on how to incorporate Azure Machine Learning features into a Windows 8.1 Kinect enabled application to detect facial expressions in real time.

Microsoft Azure Infrastructure Automation with PowerShell

Speaker: Trevor Sullivan

Moderator: Anil Desai

Many IT Pros in the industry have begun their virtualization training with VMware, but as the market shifts in other directions, a lot of administrators are finding themselves managing multi-hypervisor environments. Many businesses are now in the process of migrating some or all of their virtual workloads to the Microsoft Hyper-V platform for a number of reasons including, cost savings, scalability, and ease of management. While managing a Hyper-V cluster is somewhat similar in concept to ESXi, there are some fundamental differences. This session will cover Hyper-V clustering, management differences, and the migration of VMs from ESXi to Hyper-V. The entire session will be geared towards VMware administrators who are looking to broaden their horizons by adding Hyper-V know-how to their toolbox.

10 New Things for Developers on Windows 10

Speaker: Colin Melia

Moderator: Mark Schramm

It's in the title. If you didn't have time for Build or you just want to get a summary of 10 new features for developers from the new and/or updates APIs, tools SKUs and/or languages, from devices to the cloud, this is your chance to get on board.

Resolving Conflicts in Collaborative Occasionally Connected Mobile Apps

Speaker: Michael Perry

Moderator: Bryan Hunter

In collaborative apps, a change made on one device appears on another. Data flows seamlessly across devices. But those devices aren't always connected. And even when they are, users don't want to wait for a network connection before they can see or work with their data. So data needs to be stored locally, and synchronized in the background.

Monday, March 30, 2015

GP 2015 R2–What’s coming and GP’s roadmap

With Convergence all wrapped up – David Musgrave has started his series of posts covering his experience at his blog. A couple of slides from the general session are worth checking out if you haven’t seen them already. One of the exciting things on the roadmap is the HTML5 Web client on the roadmap for R3.



Monday, March 16, 2015

Free Windows 10, IoT and Azure Technet event by Microsoft in Sydney

Microsoft is running Technet Update at Australian Ballroom and Exhibition Room 14 Carrington Street, Sydney on the 16th of April, 2015. Register for this event here, should be worth your time.

 

Agenda

9:00am – 10:00am

Keynote - Getting to the value of the Internet of Things

Lee Hickin - IoT Commercial Lead, Microsoft Australia 

The Internet of Everything has become a catch-all phrase to describe adding connectivity and intelligence to just about every device in order to give them special functions, from tiny devices that might travel in our bloodstream to fully automated large scale mining operations. Billions of sensors will be shipped each year and the possibilities are endless. But what should be connected? and Why? Come along to this session and hear why businesses should care about the internet of things…….and learn where the real value lies. Microsoft will lay out its vision for how businesses can best take advantage of this growing trend and how it’s cloud and Windows technologies will offer a complete end to end solution

10:00am – 10:30am

Break

Stream 1 – Windows 10

Stream 2 – Microsoft Cloud OS

10:30am – 11:30am

Windows 10 – What does the new OS mean for Enterprises?

Foundation for the Software Defined Datacenter

11:40am – 12:40pm

Windows 10 Security – What’s new?

Extending Enterprise Networks to Azure using ExpressRoute

12:40pm – 1:30pm

Lunch

1:30pm – 2:30pm

Windows 10 – Deployment

Windows Azure Pack Overview

2:40pm – 3:40pm

Windows 10 for Mobile Devices: What’s Next?

Getting started with Microsoft Azure IaaS

3:40pm – 4:00pm

Break  (Close and Prize Draw)

4:00pm – 5:00pm

Networking drinks

Wednesday, March 11, 2015

Using the new Dynamics GP 2015 REST Services in SBA (Service Based Architecture)

If you have been following my blog, you probably know how excited I am about this feature. Unfortunately, the documentation can be a little hard to find. The important thing to remember is that as this is a part of the web client – that is where you will find the relevant documentation. 

Paul Haag at InterDyn has just written a great post summarizing the steps he followed.  Using the Dynamics GP Service Based Architecture (Paul Haag) 

Additionally as you are stuck(and its okay if you are, this is Version 1 of the SBA) – you might find the following notes and resources helpful.

  • There are three logs you can look to for information on requests that fail, the GP Service log, Dexterity Service Log and the Request Log.  All logs are located in ProgramData\Microsoft Dynamics\GPSvc\Logs. The Dexterity Service log will tell you if the request made it to the Dexterity instance and is in the Inst_DefaultInstance\DexterityService directory. All requests tie together with a correlation ID. Read more at Debugging in the Dynamics GP 2015 Service Based Architecture
  • You need to place the new Application.PRODUCTNAME.dll in your GP runtime folder.  After restarting your services, a good way to see if your endpoint is available is by using discovery (url below).  That will show all the dictionaries that have been DAG'ed and have available service endpoints. https://<MachineName>/GPService/Tenants(DefaultTenant)/Companies(Company Name)/Help/

Read more at Service Based Architecture and Custom Procedures  (Thanks Rob Bernhardt)

  • When creating service procedures in the service based architecture one of the key steps is to define service metadata including setting the Service Enabled switch to TRUE. We also add a Service Procedure Metadata property which contains the relevant information for the GP Service to wire the procedure calls up to their URI endpoints. In addition to this, the procedure’s class definition will now contain a third invoke method which the service uses for parsing the request and building up the response. Read more at - DAG (Dictionary Assembly Generator) – What’s New in GP 2015

Tuesday, March 10, 2015

Chance to Fix a Bad Name

David Musgrave has just announced that he has completed the exclusive agreement with Microsoft to obtain the Support Debugging Tool source code.

He’s now looking at community feedback to fix the horrible name which always took a few tries to explain to people. “Why do I need a debugging tool ?” – most people I recommended the tool to asked me.

Go Vote for a new name that makes sense here - Where is the Support Debugging Tool for Microsoft Dynamics GP 2015?

PS – It was a good thing the tool was named the support debugging tool. With a slightly better name, and consequently even more popularity David would have had much more difficulty getting the source code !