Check out this blog post from my www.BIBelinda.com blog.
Continue reading “Using Relative Date Filtering in Microsoft Power BI”
Belinda Allen, Microsoft MVP Business Solutions
Things I've learned from years of working with Microsoft Dynamics GP.
In this video, I demonstrate using Relative Date Filtering in Microsoft Power BI. My dataset contains unpaid Accounts Payable invoices and their due dates. I use the Filter options to restrict the visual to display only invoices that are in the next 275 weeks. My sample data is way out in the future, realistically, you would want to see what’s due this week, month, etc.
Check out this blog post from my www.BIBelinda.com blog.
Continue reading “Using Relative Date Filtering in Microsoft Power BI”
Historical Excel Reporting for Dynamics GP. Users of Historical Excel Reporting…
I’m telling you, this tools is cheaper than building it yourself.
It’s April and spring keeps trying to break through. If you aren’t thinking about vacation, you haven’t been cooped up long enough. Once you start thinking about tropical beaches and drinks with umbrellas in them, how do you find the time? One option is Historical Excel Reporting for Dynamics GP. Users of Historical Excel Reporting…
via Who needs a vacation? — DynamicAccounting.net
A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP. There were several great responses to his question, but now I want to add my two cents!
A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP. There were several great responses to his question, but now I want to add my two cents!
My Friend and fellow Microsoft MVP, Victoria Yudin has made this process a lot easier for you. She has a SQL view that will organize your open payables and age them for you.
Continue reading “AP aging in Excel thanks to Victoria Yudin in Microsoft Dynamics GP”
I noticed today the following message from a Microsoft Dynamics GP user on GPUG Collaborate:
Does anyone know how to run a trial balance or JE listing out of GP or a Smartlist that shows the date that the entry was originally recorded? For instance, all December 2012 entries that were recorded and posted after January 15, 2013.
I noticed today the following message from a Microsoft Dynamics GP user on GPUG Collaborate:
Does anyone know how to run a trial balance or JE listing out of GP or a Smartlist that shows the date that the entry was originally recorded? For instance, all December 2012 entries that were recorded and posted after January 15, 2013.
Microsoft Partner Rod O’Connor from Briware Solutions gave a great answer regarding how to have this show in SmartList.
Continue reading “When did it post in Microsoft Dynamics GP (with video)”
The Apply Date that shows in the apply window for Microsoft Dynamics GP Payables has an important role. The apply date that is used when the invoice becomes fully applied will become the “Date Invoice Paid Off.”
I frequently get asked “Why is there a separate step to age Microsoft Dynamics GP Accounts Receivable?”
Posted 4/1/2012
I frequently get asked “Why is there a separate step to age Microsoft Dynamics GP Accounts Receivable?”
Believe it or not, it’s actually a benefit to you.
I have a client who charges their customer a finance charge for all invoices 30 days or older; however experience tells them that many times they charge finance charges, only to receive the payment within a day or two causing them the extra work of writing off the finance charge.
We worked together and created a very smart plan. We change the aging periods from 1-30 to 1-45, then age and charge finance charges for invoices over 45 days old. We then change the aging period back to 1-30 and age again. This method, only ended up charging finance charges for invoices over 45 (even though their customer is expecting over 30)days old.
There are many reasons you may want or need control over aging, and with GP you have it!
Using Microsoft Dynamics GP, if you do Bi-weekly payrolls, you pay employees 26 times a year. If you have monthly deductions, like health insurance, you have a monthly amount for each employee to deduct.
Posted 2012
Using Microsoft Dynamics GP, if you do Bi-weekly payrolls, you pay employees 26 times a year. If you have monthly deductions, like health insurance, you have a monthly amount for each employee to deduct.
When you void a Microsoft Dynamics GP Payables check or transaction and you just click the box then the void button you’ll be voiding in the GL and in Payables the same date the transaction was originally posted. This may or may not work for you.
Posted in 2012
Continue reading “What the Date (in Microsoft Dynamics GP)????”
What are there 2 dates in Dynamics GP on all transaction except the General Ledger? I answer this question for you, along with the why’s and wherefores? The dates can be confusing, but this video helps you understand the difference between the 2 dates and how they are used.
What are there 2 dates in Dynamics GP on all transaction except the General Ledger? I answer this question for you, along with the why’s and wherefores? The dates can be confusing, but this video helps you understand the difference between the 2 dates and how they are used.
Continue reading “Microsoft Dynamics GP Posting Dates (Transaction vs. GL)”
This video shows the steps necessary to make sure your summaries are in the right aging Bucket using Microsoft Dynamics GP.
Posted 2-1-2011
This video shows the steps necessary to make sure your summaries are in the right aging Bucket using Microsoft Dynamics GP.