Page 1 of 17112345678910...2025303540...Last »

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

See the article here:
Dynamics GP – Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

July 23, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 15

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.

Read More:
Microsoft Virtual Conference Sessions–May 14 & 15

April 7, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 79

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

Phew! How about that OneRepublic concert?

Day 4 is finally here and with it, all good things must come to an end. For a change, today David and I managed to make it down to the GWCC on time and had a fairly relaxed breakfast at the Meal Hall to then move over to the Phillips Arena for one very interesting closing keynote.

As customary, an energetic Judson Althoff, President Microsoft North America welcomed the crowd to the event and proceeded to recap the week and what will be seen from Microsoft in the coming months.

Judson Althoff, President Microsoft North America

The first thing in his opening was to remind the audience how Convergence is becoming the premier event for business and that Microsoft, at its core, is “the productivity and platform company for the mobile first, cloud first world” and how the company is thinking about innovation and technology.

Althoff then introduced the upcoming events, Microsoft Ignite which is geared to showcase innovations for IT professionals, the Dynamics User Group Summits hosted by Dynamic Communities.

Microsoft Ignite

Dynamics User Group Summits

Althoff then zeroed in on the upcoming Convergence events and announced the dates and locations for Convergence 2015 EMEA and Convergence 2016 New Orleans. The latter received a round of shouts from the audience.

Convergence next stops

Then came the topic of the day: Cyber-security and the work being conducted by Microsoft and its Digital Crime Unit to counter the effects of online criminal activity.

After a short intro video (above), David Finn, Executive Director Microsoft Digital Crimes Unit who then introduced the work of the new division opened just 16 months ago and located in Redmond, Washington. The unit fights two types of crimes: Technology-facilitated crimes which targets vulnerable population such as children and the elderly, and Malware and reduction of digital risk.

David Finn, Executive Director Microsoft Digital Crimes Unit

Finn then presented a number of grim statistics around the children victimization and introduced Microsoft PhotoDNA, a new cloud based solution that can be licensed by anyone to detect awful images and report them to law enforcement organizations around the world.

Microsoft PhotoDNA

David Finn then addressed the topic of malware and cyber criminal activity using botnets and how Microsoft assisted with the Citadel Malware case, which involved the infection of over 91 million PCs and the hijack of close to half a billion dollars ($500M). The case had a particular focus on using visualization and big data to analyze infection patterns across the world.

The Citadel Case

Citadel Infection Pattern

As a result of these efforts, Microsoft is experimenting with new visualization and sonification techniques to understand infection patterns. One such technique is dubbed the Specimen Box and was presented during the session.

Specimen Box – Live Mode


After the closing session, we returned to the GWCC to do some walk around the Expo. I stopped at the booth of my friends and partners at FieldOne to congratulate them for their new achievement. Microsoft has named them a Dynamics CRM Global ISV which shows their commitment to developing the channel and producing quality products.

The FieldOne team

From the Expo, I went to Mark Polino’s session CS15G003-R2 Microsoft Dynamics GP: New 50 tips in 50 minutes, a jammed pack session filled with bite size tips on Microsoft Dynamics GP functionality. Mark had a full room and as the rock star he is, he commands quite the attention from the attendees. I have to admit I picked up a few good tips for my toolbox.

Up next, I had to complete the repeat of my upgrade session, CS15G002-R2 Microsoft Dynamics GP 2015: Upgrading and deploying. I had been assigned the last slot on the last day of the event, which I have been doing for the past 6 years now. While I did not have the same amount of attendees as with my first bout at this session, 85 people were still pretty good, considering that a lot of people left to catch their flights early in the morning.

After my repeat session, it was time for some relaxation and the famous Tim Tam Slams. Earlier, I had sent out a tweet to a number of people to meet up at the Omni Hotel bar for what has become a tradition among a select few of us. Before the slams though, I managed to meet with a group of friends from Colombia to explain some good ol’ fashioned Microsoft Dynamics GP architecture and deployment options for their company and how the web client and Microsoft Azure have revolutionized the way Microsoft Dynamics GP is deployed.

I then moved over to the bar with my friends Olga Acosta and Eddie Yepes to grab a drink before sitting down for Tim Tam Slams.

Olga Acosta does the Tim Tam Slam

Eddie Yepes does the Tim Tam Slam (and fails miserably!)

The final stretch of the evening would have me doing dinner with my good friends and fellow MVPs Belinda Allen, John Lowther, and of course David Musgrave at Dantanna’s Downtown location, inside the CNN Center. We spent the evening chit-chatting from one thing to another and enjoying John’s vicious appetite for Thousand Island dressing on his salad.

After a wonderful meal and excellent service we proceed to leave, not without running into the Njvity folks.

Chris Dobkins, Mariano Gomez, Emily Roen, and David Musgrave

The event was now over for good and it was time to leave. I really could use some sleep… but wait, still more to come.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Read more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

April 2, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 91

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1 Continued

Day 1 – Afternoon

After the Keynote and General Session, it was time for lunch and trying to catch up with friends. It never ceases to amaze me the logistics required to sit and feed 12,000 people at any giving time. Just making sure everyone has a place to sit or even the kind of food they like is got to be an incredible task.

Crowd heading for lunch at the Meal Hall

After getting my food, I went to sit at the table with some very distinguished folks in the community – in the meantime, David was off trying to get something that won’t upset his tummy. As you may or may not know, my good friend troubles with MSG intolerance (and associated flavor enhancing glutamates), which makes his daily food intake an exercise in patience and careful negotiation with restaurant staff and chefs.

From left to right: Beat Bucher (Forensic Technology), Kim Peterson (GPUG), Mark Huff 

From left to right: ?, Frank Heslin, and MVP Belinda Allen

After lunch, it was time to go visit some of my ISV friends. I had really been looking forward to get out to the Expo and pass by some of the booths to talk to some of the folks I normally run into at these events. Their work also serves to improve the lives of the Microsoft Dynamics GP community of users at large.

Rockton Software (Caption: Can’t you count? I only have 2, Beat!)

Ethotech: Stephanie Rasmussen, John Stulak, Kevin Rasmussen

FieldOne Systems (CRM Global ISV)

After walking around the Expo, it was time to go and work on last minute refinements for my upcoming CS15G002-R1: Microsoft Dynamics GP 2015: Upgrading and Deploying session. I had the 5:00 PM slot, so I knew by that time I would get a weary crowd.

Tim, Therese Jardine, and Ace Martin

All presenters are usually working on last minute deck improvements and catching up on emails before their sessions. Not to mention, the room is well equipped with coffee, snacks, and lunch for those choosing to avoid the crowd in the Meal Hall.

The Presenters’ Room

It was time to go and locate room A305. I arrived about 30 minutes before to do the customary tech check. As the crowd began to arrive, I figured I would begin asking random questions and entertain the group a bit before the 5:00 PM kickoff. I also managed to capture this picture (on David’s camera).

CS15G002-R1 Microsoft Dynamics GP 2015: Upgrading and deploying

My session had over 201 attendees and received the highest mark for any Dynamics GP session presented. The session also came in at 29 among the 265 delivered throughout Convergence.  Once the session was over, it was back to the Expo for a quick bite to eat and a drink while walking around saying hi to all friends.

Back at the Expo

 David and I decided to stop at the Microsoft Dynamics GP booth to say hi to our Microsoft friends.

Brian Roney, David Musgrave, and Alice Newsam

It was time to put this day away and get ready for another which would bring the Rock & Rave event and David and I delivering the first of our two sessions together.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

More:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1 Continued

March 31, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 79

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

Keynote and General Session

I know, it’s been over a week since Microsoft Convergence 2015 closed its doors, however, I did not want the time to go by without reliving some of the things I personally experienced throughout the event. With early mornings and late evenings it became impossible to write blog posts as things were happening, considering my own involvement with quite a few of the activities and presentations at Convergence.

Day 1 started out with David and I rushing through Atlanta’s traffic to get to the Georgia World Congress Center. From there we would head over to the Phillips Arena for the Opening Keynote Speech. We got there at the tail end of the presentation of Dance 411. The Dance 411 Foundation’s mission is to foster the well-being of urban youth and young adults through self-expression. They provide a quality education and exposure to the discipline of dance, drama and music. Judson Althoff, President Microsoft North America was in the middle of interviewing JJ Crampton and Sindy Scheider, both directors of the Foundation and requesting everyone filled out the Convergence event evals, for which Microsoft would make a donation to the Foundation.

Dance 411

Once the dance group completed their presentation, Althoff was once on stage to talk about the Atlanta Youth Project and Truly Living Well Center for Natural Urban Agriculture and the volunteering work done in conjunction with the Convergence attendees who signed up for community outreach, now a staple of these events. The community outreach video was accompanied by an original song by The Groove Merchants.

Upon the conclusion of the community outreach video, Althoff was back on stage to describe the upcoming days at Convergence and some of the guest speakers that attendees would have a chance to experience. He also alluded to the fact that the event itself, Convergence, is also evolving and changing, just like the businesses present at the event. He also noted that Convergence used to be a Dynamics only event. Microsoft has expanded the event and evolved it to actually incorporate all of its innovations. Convergence has become the Premier Business Event.

Without further due, Satya Nadella was on stage to talk about how Microsoft is empowering every person and every organization on the planet to achieve more, via the “systems on intelligence”.

Satya Nadella on Microsoft’s Vision

The systems of intelligence interact with the systems of record to make sense of the data collected. Microsoft is focusing on the automation of the systems of intelligence, with the richness of its cloud infrastructure. To further talk about how other industries are taking advantage of the technologies that drive the systems of intelligence, Satya welcomed Seattle Seahawks’ Russell Wilson.

Seattle Seahawks Russell Wilson

Russell described how he uses OneNote to track all his activities on and off the field and how the National Football League (NFL) leverages Microsoft Surface during the games to analyze team formations, plays, and players in near real time – Microsoft is a sponsor of the NFL.

The rest of the presentation focused around the use of other technologies such as Yammer within Microsoft itself. Also there was a cool case study on how AccuWeather is leveraging Microsoft Azure to deliver custom and personalized weather to both consumers and businesses.

AccuWeather

After the case studies, it was time for Mark, Belinda, and I to head over to the GWCC to wire up for the Microsoft Dynamics GP General Session, to be held at the Sydney Marcus Auditorium. Upon arrival, I went back stage to check in and had a chance to capture this picture with the engineering team at work.

Video and Audio Engineering Room

This year, the Microsoft Dynamics GP General Session featured a number of info-bites showing what each of the presenters were doing at different stages during the 90’s and various terminologies born from that time.

Little bits of information before session

This year’s Dynamics GP General Session would focus on product strategy and roadmap, and as customary, it began with with Errol Schoenfish welcoming all attendees and discussing the Microsoft Cloud for Business strategy, which features Office 365, Azure, and the business applications, including Microsoft Dynamics GP. Errol went on to demo a Time Management app (#IfErrolCanDoIt) showing how it would work on various device platforms.

Then came the highlight of the event (ehem!): The MVP Duel featuring Mark Polino and I, with a special guest, Belinda Allen. Our presentation, showcasing a number of new features in Microsoft Dynamics GP 2015, went very smooth and features were well received by the audience.

The MVP Duel – From left to right: MVPs Mark Polino, Belinda Allen, and Mariano Gomez

Up next was the customer story featuring Rural Renewable Energy Alliance (RREAL), a non-profit dedicated to make solar energy available to low income families.

Next up was Jennifer Ranz to demo a day in the life of a RREAL employee. Jenn showed the dashboards released for Office 365 and PowerBI. Jason Edens from RREAL came on stage to talk about how their company is leveraging Microsoft Dynamics GP to run their business.

The session went on with other demos and a glimpse into the future of Microsoft Dynamics GP. First up was Jeff Trosen to talk about the evolution of the Microsoft Dynamics GP roadmap. Chad Sogge came up next to talk about the new HTML 5 interface and provide a demo of how this new web client technology will allow for a better user experience across browsers and devices.

Errol Schoenfish and Chad Sogge on the Future of Microsoft Dynamics GP Web Client

I had to finally get a shot of the audience.

Microsoft Dynamics GP General Session Attendance

Well, in my next post, I will talk about the sessions we delivered throughout the rest of the event.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

See more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

March 30, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 78

Tech Tuesday: SmartList Builder, GP Web Client, and the GP January Hotfix

We wanted to make everyone aware of an issue that we have come across in recent weeks.

There is an issue in the January Hotfix for Microsoft Dynamics GP that is causing SmartList Builder issues when used in the Web Client. Because of the issues in the hotfix, the Table Finder feature in SmartList Builder cannot load and it causes GP in general to fail loading. If you remove SmartList Builder

View article:
Tech Tuesday: SmartList Builder, GP Web Client, and the GP January Hotfix

March 17, 2015 · Nicole Albertson · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 88

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

See the article here:
Free Windows 10, IoT and Azure Technet event by Microsoft in Sydney

March 17, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 91