After upgrading to GP2013, do some of the field values you export to Excel display differently? We are seeing some issues when exporting the same reports used in prior version of Microsoft Dynamics GP when exporting SmartLists to Excel.
Did you know – you can rename SmartList fields in the regular SmartList - click on the columns name and type over the names in the display names portion of the window. With the information populated under the new name – drag the column heading to fit the data and save as a favorite. The Smartlist will fit across the window better
There are many, varied impressions and ideas of what electronic banking is and what it can mean to an individual or an organization. In the personal banking world, some people think about accessing a bank web portal to pay utility bills, schedule a recurring mortgage payment, or maybe schedule an amount to be transferred to a savings account each month. Others may think of having a pay check automatically deposited by an employer. Using a credit card to process a payment online is another common example.
Recently, an issue started where users at a company were receiving an error when they clicked on the View button in Metrics to display their chart or KPI in their web browser. The error message was similar to:
Many companies today must decide if they can benefit from consolidating multiple company databases that have been added through growth or acquisitions. A client of ours, a flourishing medical and healthcare company, really needed to consolidate all their databases.
A customer brought an issue to our attention with Microsoft Dynamics GP 2013 and exporting SmartLists to Excel. Using the Employee default to create a new Smartlist, if you add a column called “Vacation Accrual Amount”, in SmartList after that column is added, the values show up in SmartList just fine. However, when you export the list to Excel the values for this column are zero in Excel. If you export this to Word, the values are there.
Time is tight to generate 2012 1099s. As a Microsoft Dynamics GP user, relying on the canned 1099 Smartlist report is not recommended. 1099s generated using this canned report are not always accurate. So, how best to get 1099s generated in the next few days that you can be more confident in? Follow these detailed tips to use Smartlist Builder and check 1099 reporting off your To DO list!