Blogs

 
As stated back in April of this year , the IRS will begin enforcement of the Affordable Care Act (ACA) any day now. They have now published a draft of the soon to be sent Employer Shared Responsibility Payment (aka “Penalty”) notification letter. While some employers have received “non-filing” letters from the IRS already, this letter will be the first notification of employer penalties associated with not complying with the requirements of the Affordable Care Act. In addition, the IRS has updated questions 55-58 in the “ Questions and Answers on Employer Shared Responsibility Provisions Under the Affordable Care Act ” on IRS.gov (details ...
0 comments
Microsoft Dynamics 365, Dynamics AX, Dynamics CRM, Dynamics GP and Dynamics NAV users are encouraged to attend Collaborate Canada , an educational opportunity taking place this November in Canadian cities: Montreal, Toronto, Calgary, and Vancouver. Each city will host a one-day event that will provide access to premium content designed by industry experts. Attendees can look forward to the following highlights at each event: Access to Dynamics MVPsand Product Experts Microsoft General Sessionwith Technical Roadmap Five Sessionsacross functional and technical tracks by User Group Networking and Collaboration with your Dynamics Peers Third ...
0 comments

Cost Averaging Concerns

We do a majority of our shipping through drop ship orders.  We do have some inventory that we ship to our customers and those items are costed by average costing.  We had originally thought that GP was only averaging what was in inventory at that time , but it appears that it may be averaging on a larger basis.  Recently, we noticed that if we return and re-bill an order that was originally a drop ship, it is being cost averaged on the re-bill only.  When we return an item, we do return it through our inventory.  The cost may have been $2,000 forever, but if it is returned and re-billed for any reason the return is $2,000, but the re-bill will be costed ...
0 comments
Our company assesses internal costs at the sales order level in order to assess our sales reps internal costs to calculate commissions.  We currently bill these items through the sales order process as inventory “parts.”  Is there a way to assess these costs by the hour (such as loaded labor costs) or as a flat fee or percentage (such as an order or credit card fee) at the sales order level without the cost impacting the income statements? We are concerned about “double dipping” on expenses.  Does using a Service Item or other non inventory item type make a difference?  Are there any suggestions you might make?  Or, is there a different way that you are currently ...
0 comments
Join us for an upcoming Power BI Boot camp designed to get students up to speed on building and deploying custom analytics and reporting solutions using Microsoft's rapidly evolving Power BI platform. Whether you are a Business User, Data Professional or Software Developer, we have a workshop that's right for you! "Ted was an excellent trainer. Easy to listen to and follow, exceeded my expectations." - Angela Wentz Nov 20 | Academy - Deep Dive into Power BI 2 Day Workshop Course Modules: 1.Introduction to the Power BI Platform 2.Extracting and Transforming Data using Power BI Desktop 3.Building a Data Model using ...
0 comments
The class will start out assuming attendees know nothing about SQL or programming and will quickly progress them to a point where they can effectively ask a complex question of their Dynamics GP database, as opposed to waiting for someone else to ask it for them.  Although it may look like gibberish to you today, SQL is one of the most logical languages there is and we intend to make it easy for you to read and write it! Through interactive lectures and hands on examples, attendees of this class will learn: What is SQL and how can it be used in relation to Dynamics GP The components of an SQL Select query Different ways to ...
0 comments
As the holiday season kicks into high gear, planning around GPUG Amplify 2018 as well as the partner-only event beforehand for those working in sales & marketing disciplines has, too.   The “holidaze” are hectic in and of themselves, then year-end and next-year budget planning begin to kick in.   That stated, we decided to get going on GPUG Amplify planning and get some ideas into the various hoppers by compiling two brief, separate surveys for your consideration: For the main event, GPUG Amplify 2018, we’re looking for both end users and partners to submit their session ideas.   GPUG Amplify is a smaller, more intimate, GP-only event geared ...
0 comments
Upon further review with a UK-based colleague of mine and more than one partner organization north of the English Channel, we’ve decided to hold a #GPUG event in London during the spring instead of joining our UG brethren in Dublin during www.summitemea.com this April (our events in Dublin will focus on Dynamics 365, primarily).  This is quite a pivot for us, but it has been one that was made with careful consideration. The bottom line here is that there are simply more Microsoft Dynamics GP end users in both mainland UK, and specifically London and the South East, than in Ireland.  The pool of end user companies across the pond is not like ...
0 comments
Did you recently attend Summit Nashville and miss being surrounded by peers, eager to learn like you? Or were you unable to attend Summit this year? Either way, you're in luck! Upcoming  Collaborate Canada  events will provide a mini Summit–like experience. These one-day events will be the best investment of your time and resources to ensure you go into 2018 fueled with the knowledge to take your business far.  Collaborate Canada  will provide opportunities to  see your product evolve  with Microsoft Dynamics 365, Power BI, Power Apps & Flow,  network with the best and the brightest  people in the Microsoft Dynamics community, and ask  Microsoft Dynamics ...
1 comment
I’m excited to invite you to attend our ‘Collaborate Canada’ events, educational opportunities taking place this month in four Canadian cities: Montreal, Toronto, Calgary, and Vancouver. Dynamics GP end users are encouraged to attend one of these full-day events that will provide unprecedented access to premium content designed by industry experts. Attendees can look forward to the following highlights at each event: Access to Dynamics MVPs and other product experts My friends Jen Kuntz & Rod O’Connor will present in each city! Mon ami Beat Bucher présente à Montréal! A Microsoft General Session with Technical Roadmap ...
0 comments
Greetings GPUGers! What a month we had in October - Summit Nashville was definitely a highlight that brought together the best and the brightest to share, learn, connect and just have an incredible time among GP peers.  The unique event had record-breaking attendance and hopefully many returned to offices with new GP solutions and knowledge, a stack of business cards to add to emails and phones and a deep sense of community that our lively, collaborative and energetic GPUG group instills.  GPUG - Winner of Most Successful Community Whether you attended Summit Nashville or not - one thing we all have in common is being an integral part of this dynamic group. ...
2 comments
We are implementing GP 2016 R2 with the new year. This version allows you to offer users the opportunity to customize the look and feel of their home page. For some users, that might be a nice feature. However, what about those users you don't want to give that feature to? In our case, that would be something self-service users simply don't need. With some help from several GPUG members, I identified a process to assign a default home page for these users and manage what content was visible on that page. Keep in mind that the copy settings process is for existing users; you can assign a home page when initially creating a user in GP. First, I created a generic ...
0 comments
Do you want to develop and expand on your Dynamics GP skills?  GPUG Academy  has upcoming distance learning classes that can help you build your skills through in-depth training from the comfort of your own desk!  These hands-on training courses dive into specific modules and functions within the Dynamics GP environment and allow you to explore these concepts beyond regular day-to-day training.  Upcoming Distance Learning Classes: November Academy - HR - Let’s Learn It Together! - Part I Wednesday, November 1, 2017 (12:45 PM) to Wednesday, November 1, 2017 (5:00 PM) (ET)   Academy ...
0 comments
Did you recently attend Summit Nashville and miss being surrounded by peers, eager to learn like you? Or were you unable to attend Summit this year? Either way, you're in luck! Upcoming  Collaborate Canada  events will provide a mini Summit–like experience. These one-day events will be the best investment of your time and resources to ensure you go into 2018 fueled with the knowledge to take your business far.  Collaborate Canada  will provide opportunities to  see your product evolve  with Microsoft Dynamics 365, Power BI, Power Apps & Flow,  network with the best and the brightest  people in the Microsoft Dynamics community, and ask  Microsoft Dynamics ...
1 comment
As we gathered in Nashville last week for the GPUG summit event, I had mentally prepared for another big conference; making certain we have everything for the booth, meetings scheduled, logo wear packed, and goals set. As an event sponsor/exhibitor with a hefty investment in the event, we centered much of our focus in preparation around the potential for new sales and a satisfactory ROI on the event. The Expo Reception kicked off the event and the sessions went into full swing. We interacted with Dynamics GP and Integrity Data customers to answer questions, provide insight, direct to other solutions, clarify Microsoft terminology, and share helpful ...
0 comments
The GDPR is at the forefront of a lot of people's minds, as it should be. The regulation deadline will be here in May 2018, which feels far away though it really isn't considering how much work there is to be done to prepare for it. Here at DATABASICS, we're gathering paperwork, attending information sessions, and spreading the work at about the GDPR. It's a new regulation that tells companies how to responsibly manage the personal information of any citizen in the European Union, with Britain included. The regulations are broad on purpose so that more companies are careful about the information they manage and transfer. Even though we're a company based ...
0 comments
This week of GPUG Summit has been a fantastic example of the power of the GPUG community. A record-breaking 6,600 Microsoft Dynamics users and partners from around the world descended onto Nashville and gathered together at the Gaylord Opryland Resort for authentic networking and energetic knowledge-sharing in a lively environment. From the individual user to the overall conference, the quality of education attained will propel careers, organizations, and industries forward. Today, attendees wrapped up with a final day of breakout sessions and Expo exploring. The hum of Dynamics users and partners in the building slowly quieted as everyone began making their ...
0 comments
A powerhouse of idea exchange and energy, GPUG Summit is the best chance to connect with fellow industry experts and share insights that will bring you big returns for years to come. Couldn’t make it this year? Read on to see some highlights of onsite happenings: GPUG Community General Session + Award winners GPUG Summit attendees had a hootenanny of a time celebrating the biggest contributors in the community and learning the future direction of the user group. Congratulations to the 2017 All-Star Award recipients: Bert Green , Berger Transfer & Storage, Inc., Steve Burney , Nissan Trading Corporation Americas, and Leslie Vail , Accounting Systems ...
0 comments

Reporting Tools

​We are preparing to upgrade from GP2013 R2 to GP2016R2 and would like to take better advantage of our reporting tools. We have both Power BI and Management Reporter and would like to know which of these tools works better for budget reporting and which for financial reporting. Any insights or user thoughts would be appreciated. Thank you! Michele
1 comment
GPUG proudly announces the 2017 All Star, Chapter of the Year, and Richard Whaley Academy Award recipients at GPUG Summit Nashville. ALL STAR 2017 WINNERS This year’s All Star award recipients are: Bert Green, Berger Transfer & Storage, Inc.; Steve Burney, Nissan Trading Corporation Americas; and Leslie Vail, Accounting Systems Consulting, Inc. The highest award given to our GPUG community, the All Star Award program recognizes GPUG members, who have a passion for Dynamics GP and have made significant contributions of their time and expertise to the GPUG community. Once an individual has achieved this award, their All Star status does not expire. ...
0 comments