What Really Happens When Someone Clicks Your … – Buffer Blog

After all these options are chosen, the post will show up at the very top of the News Feed on a profile page, and in the News Feeds of all one’s friends (depending on the Facebook algorithm, of course). Facebook share box news feed …. any time soon +1). 2. MOST IMPORTANTLY, you can add a comment to the ‘Liked’ or ‘Recommended’ article (Example: http://i.imgur.com/wIW08ZC.png… if you have the latest Like Button Social Plugin implemented for your site/blog.

Taken from:
What Really Happens When Someone Clicks Your … – Buffer Blog

August 6, 2014 · Kevan Lee · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 66

Modified RM Aged Trial Balance–Summary

The RM summary aged trial balance is too busy. Too many lines per customer. If you just want one line per customer, this is the report for you.

The modified AGED TRIAL BALANCE WITH OPTIONS – SUMMARY:

image

The original AGED TRIAL BALANCE WITH OPTIONS – SUMMARY:

image

I know it’s hard (perhaps impossible) to read the images, but you can clearly see how much cleaner the modified report looks.

You can download the modified version of this report here:
Modified RM Summary ATB-1 line per customer

Until next post

Leslie

View original post here:
Modified RM Aged Trial Balance–Summary

August 6, 2014 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 637

Modified Payables Transaction Entry Distribution

I modified the Payables Transaction Entry Distribution window so the Account Number appears on the first line of the scrolling window. I also added the Currency ID field to the second line of the scrolling window because the second line looked pretty desolate and  needed something else. There were no other fields in the distribution table (PM10100) that looked interesting.

image

This modification was done on GP 2013 R2. You can download a package file for this modified form here: Modified Payables Transaction Entry Distribution

Enjoy!

Leslie

More:
Modified Payables Transaction Entry Distribution

August 6, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 505

Modified GL Transaction Entry Window

Forever I’ve wanted the account description on the first line of the GL Transaction Entry window. Well now I have it! It took me all day to create, but at least now it exists. I shouldn’t be the only one who benefits from my labor, so I’m going to make it available to you.

NEW GL Transaction Entry window:

image

Changes Made to GL Transaction Entry window:

Fields added to the upper right-hand quadrant:

      • Last User ID
      • Last Date Edited
      • Originating Document Information
      • Series
      • Originating Posting Date
      • User Who Posted

Fields added to the third line of the scrolling window: 

      • Originating Master ID
      • Originating Master Name
      • Transaction Type
      • Original Voucher/Payment Number
      • Original Document Number

The screenshot below shows the new window with the changes highlighted:

image

This modification was done on GP 2013 R2. If you want a copy of this window for yourself, you can download the package file here: Modified GL Transaction Entry window

Until next post!

Leslie Vail

Read More:
Modified GL Transaction Entry Window

August 5, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 298

Using a different name on the 1099 forms

I like clients who plan ahead! This company wants to use a different name on the 1099s other than the ‘Check Name’. You could use this technique on any modern version of Dynamics, but GP 2013 actually has a dedicated address ID for 1099s. That’s where the 1099 address comes from. Sadly, the Vendor Contact is not a field included on the 1099 table.

There was one more twist to this request, they didn’t want to use this alternate name for all 1099 vendors, just for some exceptions. No problem. Here’s what we did:


First, we need a way to determine which 1099 name should be printed. There are several ways to do this. The easiest way is to pick a field on the vendor master and use it as a switch that will tell us if the alternate name should be used. You could use any field, but we normally hijack a field not used for something else. Some likely candidates are:
    • Payment Priority
    • FOB
    • Country
    • Phone 3
    • UPS Zone
    • Tax Registration Number
    • Comment 1
    • Comment 2
    • User Defined 1
    • User Defined 2
    • Payment Priority
    • Revalue Vendor (this only works if you will NEVER use Multicurrency)
    • Country Code

You can use any field on the Vendor card, but the above fields are some of the fields I’ve hijacked over the years.

For this example, I’m going to use the Revalue Vendor checkbox field. Often I use this field because it’s a checkbox and it’s easy to work with. You must be sure your never going to want to use multicurrency, but that’s easily managed by switching fields. There are many we can use.

You need to use Modifier and change the prompt, but it’s an obvious choice if multicurrency is out. I changed the checkbox prompt to “Use Default 1099 Check Name”.


Once you’ve decided on the field, it’s time to decide on criteria. I’m going to keep this example easy, but it can be complicated, so long as it’s something Report Writer can calculate. Payment Priority is a checkbox so it’s value is 0 if false and 1 if true. The checkbox defaults to checked, so we need to use ‘unchecked’ to mark an exception vendor. I also make the revaluation radio group invisible. My Vendor Options window looks like this:

Preview of Modified Vendor Options


We now need to create a new relationship in Report Writer between the ‘1099s To Print Temporary File’ and the ‘PM Vendor Master File’.

image 


With that relationship set up, you need to add the PM Vendor Master Fie to the report’s tables, and then add the PM Address Master. The Tables window would look similar to the following:

image


Next, we’re going to add a restriction to the report such that it only selects records from the PM Address MSTR if the Address Code is equal to ‘1099’, or whatever ID you choose. Just keep it consistent.

image


Now you need to decide which field on the Address window you want to use as the alternate 1099 name. I am going to use ‘Contact Name’. I used modifier to change the field prompt to read ‘Alt 1099 Name’. My modified window looks like this:

image


Now we need the conditional calculated field. I’m going to call it Alternate 1099 Name. We are testing for the value of the ‘revalue’ checkbox. If it is 1, we print the check name, if it is 0, we print the alternate name. The formula will look like this:

image


Finally, modify the report layout and replace the Vendor Check Name field with your Alternate Check Name calculated field. Keep in mind as you do this, that you may have to modify this report each year to keep up with the IRS form layout. My modified report looks like this:

1099 Report LayourI

I know it’s hard to see, but there’s a red box around the new calculated field.

I welcome any other workarounds you all have come up with. Also, please let me know if you have any trouble following this article and I’ll modify it for the better.


Until next post!

Leslie Vail

Visit site:
Using a different name on the 1099 forms

August 5, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 360

Implementing a Windows Azure Site-To-Site VPN

Hi everyone! I’m back! The past few months have seen an increase in projects here at Intelligent Partnerships so I have been shouldering some very challenging projects involving some very complex integrations. Thank goodness for eOne Business Solutions’ SmartConnect and SmartPost products which have made for some very happy customers and some extremely robust integrations. In addition, I’ve been working on quite a bit of customizations migration from Visual Basic for Applications (VBA) to some cool hybrid solutions using Microsoft Dexterity and Visual Studio Tools (VST) for Microsoft Dynamics GP. If you remember, I was one of the pioneers of the technique to replace VBA customizations for hybrid Modifier and Visual Studio Tools. You can read more about this technique in the articles:

Hybrid development for the Managed Code developer
Hybrid development for the Managed Code developer (cont.)


Well, today I wanted to talk about Microsoft Azure Virtual Networks and specifically, the steps needed to setup a Site-to-Site VPN between your Windows Azure virtual network and your Local Area Network.

As you may recall from previous articles I’ve written on the subject of deploying Microsoft Dynamics GP on Windows Azure, a pre-requisite step before provisioning the VMs that will host SQL Server and your Microsoft Dynamics GP application is to provision and configure a Virtual Network, to be used to communicate the VMs. Also, if you are not going to have your Azure virtual network talk to your on premise LAN, chances are you also need to provision a VM to run Active Directory Services and Domain Name System (DNS) for name resolution – I guess, the typical networking stuff.

As with everything else, life is never this ideal, and most organizations have an on premise AD DC and DNS already in place, so the question is “Why can’t we simply use Azure as an extension of our network without having to provision these additional services?” The answer is, of course, you can!

To make the setup process happen smoothly, you must first have the following information at hand:

1. IP address and name of your DNS server
2. Internet facing address of your VPN server or appliance
3. Address space and subnet masks for your local area network (in layman’s terms, the range of IPs covered by your TCP/IP network)
4. Optional: Address space you want to use to setup your Azure virtual network.
5. An AD account with privileges to join computers to the domain

To get started, logon to the Windows Azure management portal (http://manage.windowsazure.com). Once in the management portal follow these steps:

1. The first task at hand is to identify our on premise network. Click on the Network Services and Local Network to define your on premise network. Once on the page, click on Add a Local Network.



On premise Network (LAN) setup

2. For this example, we will call the network CONTOSO-ONPREM. You will be asked to enter the public IP address for the VPN. For this example, our CONTOSO-ONPREM network’s can be reached at 200.100.50.1. Click the checkmark to proceed to the next screen.

LAN details

Note that this is simply an Azure identifier for your on premise network and not necessarily the actual physical name of it.

3. Now, you must define the range of valid IPs of your on premise LAN. Particularly important here is to know the starting IP address of the on premise network and the Classless Inter-Domain Routing (CIDR) method use for IP address allocation.

Address space

We will assume the CONTOSO-ONPREM routing prefix is 192.168.1.1 and that the usable address range is anywhere from 192.168.1.0 to 192.168.1.255 which gives us a subnet mask of 255.255.255.0 (or 24 “1” bits). Please consult with your on premise network administrator if unsure.

4. Once the on premise network has been defined, you can proceed to register the DNS server for by clicking on the DNS Servers option or clicking the +NEW action button on the lower left corner of the portal.

DNS Server registration

In our example, the CONTOSO-ONPREM DNS server can be found at 192.168.1.20. My preference is simply to assign the FQDN name of the DNS server, though, again, this is just used in Azure to identify the object and rather not necessarily related to the domain name of the machine.

5. Provision virtual network. For our example, we will call this network CONTOSO-AZURE.



CONTOSO-AZURE network provisioning

We can the click next to continue. In the next page of the network provisioning, you will be asked to identify the DNS server and establish the VPN connection to the on premise network.

Azure does a pretty cool job at showing a graphical representation of what you are configuring. In the next page, you can pretty much setup your address spaces and subnet masks. However you must add a subnet mask for your Azure gateway, by clicking the Add Subnet button.

For the purpose of our example, our Gateway IP address will be 10.32.0.0.

Click ok to continue.

6. Azure will now provision the network and make the setup based on the choices you selected. Once the network is provisioned, you can now go to the Dashboard and should see the following:

7. Next steps now involve setting up the VPN tunnel on your firewall to communicate to the Azure gateway.  For this you have a choice of downloading a number of ready to go VPN device scripts (supported devices include Cisco, Juniper, and software-based as Microsoft’s). If you cannot find your specific device, it’s always good to do a search over the Internet as someone has probably already figured out some configuration for the specific model you have. Important as well is to record the Azure network key, which you will need when setting your VPN.

Once you have established connectivity with your on premise VPN, you can begin provisioning your VMs, making sure you select your virtual network in the process.

Hopefully you found this article useful now that Azure is becoming more and more a choice for hosting Microsoft Dynamics GP.

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

Original post:
Implementing a Windows Azure Site-To-Site VPN

August 4, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 395

Reporting on a blank dimension – Dynamics Financial … – MSDN Blogs

Blog Home · Email Blog Author · Share this · RSS for comments · RSS for posts · Atom … attributes · building blocks · Consolidations · CU6 · currency translation · Dynamics AX · Dynamics GP · Dynamics NAV · Dynamics SL · Forecaster · formatting · how to · learning · Management Reporter 2012 · Planning/Budgeting/Forecasting · report design · report viewer · reporting tree · tips … MSDN Blogs > Dynamics Financial Reporting > Reporting on a blank dimension …

Read the article:
Reporting on a blank dimension – Dynamics Financial … – MSDN Blogs

August 1, 2014 · April Olson · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 230