HELP ARTICLES

Help Articles

You do not have security privileges to publish this report when publishing an Excel report.

  Wednesday, March 3, 2010   /     David Youngquist
Trying to publish an Excel report from Excel Report Builder, but as soon as the publish button is pushed, receiving an error that says,  "You do not have security privileges to publish this report".In GP 10 and prior only the sa user can publish an Excel report.  In Microsoft Dynamics GP 2010 and… [Read More]

Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))

  Thursday, December 8, 2011   /     Kevin
Opening an Excel template provided from eOne. A message box saying that "Excel found unreadable content in '<ExcelFileName>.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes. After clicking yes, one of the following error… [Read More]

Tech Tuesday: Using ODBC Connection to Query Data from an Excel File

  Tuesday, August 23, 2016   /     Jared Dux
Most often when a user needs to use an Excel file for their source data in SmartConnect they choose Microsoft Excel as their Data Source and then choose the Sheet that contains the data they need. This sample pulls all the records from the selected sheet. Another option that will allow more… [Read More]

Lot Numbers SmartList Builder Template

  Tuesday, June 14, 2016   /     Nicole Albertson
The Lot Numbers SmartList Builder setup is built to give you a list of the inventory lot numbers setup in Microsoft Dynamics GP.  The setups for Excel Report Builder and Navigation List Builder are duplicates of the SmartList Builder setup.ID: IV_LOTName: Lot NumbersTables Involved: Item Lot… [Read More]

Contacts Template for Extender

  Thursday, June 4, 2015   /     Nicole Albertson
Form Name: Contacts Form ID: CONTACTS_TMP Solution: Contacts Template The Contacts Form will track contacts for you. It will track such data as their company information, address, and phone numbers. The Notes button will open a Notes extra window to track Notes on the contact for you. Form… [Read More]

Bill of Materials Components SmartList Builder Template

  Tuesday, June 14, 2016   /     Nicole Albertson
The Bill of Materials Components SmartList Builder setup is built to give you a list of the inventory bill of materials components setup in Microsoft Dynamics GP.  The setups for Excel Report Builder and Navigation List Builder are duplicates of the SmartList Builder setup.ID:… [Read More]

Sales Line Items SmartList Builder Template

  Tuesday, June 23, 2015   /     Nicole Albertson
The Sales Line Items SmartList Builder setup is built to mimic the default Sales Line Items SmartList/Excel Report in the Sales Series. … [Read More]

Bill of Materials SmartList Builder Template

  Tuesday, June 14, 2016   /     Nicole Albertson
The Bill of Materials SmartList Builder setup is built to give you a list of the inventory bill of materials setup in Microsoft Dynamics GP.  The setups for Excel Report Builder and Navigation List Builder are duplicates of the SmartList Builder setup.ID: IV_BILL_MATName: Bill of… [Read More]

Tech Tuesday: Extender Filter Lookups

  Tuesday, July 19, 2016   /     Mark Anderson
Within Extender you can create lookups to look up data from an Extender form. It would be nice to be able to filter that list to exclude let's say inactive codes for an example, or filter based on a value on the extender form or window you are using the lookup. Let's start with creating a form with… [Read More]

SmartPost Tables

  Wednesday, August 16, 2017   /     Lorren Zemke
I am looking for a list of SmartPost tables … [Read More]

SmartList Builder Table Finder selections are blank

  Thursday, September 7, 2017   /     Lorren Zemke
When going to Table Finder, the product drop down lists are blank. I have exited Dynamics GP and logged back in without success. … [Read More]

Setting Dynamics 365/CRM Record (Entity) Owner

  Tuesday, September 5, 2017   /     Lorren Zemke
Not all Dynamics 365 Entities honor setting the owner on an entity mapping but there is an additional message available to be able to map the owner for any entity (or record). … [Read More]

Extra Purchase Distribution for Accounts Payable Transaction

  Thursday, August 17, 2017   /     Lorren Zemke
We are importing Dynamics GP Accounts Payable transactions and there is an extra Purchase distribution showing up in our transaction with a blank account number. We are mapping our own distributions using the Add Distribution Node. … [Read More]

SmartPost Tables

  Wednesday, August 16, 2017   /     Lorren Zemke
I am looking for a list of SmartPost tables … [Read More]

Tech Tuesday : Connecting to Shopify with SmartConnect

  Tuesday, August 15, 2017   /     Jared Dux
This week we are going to take a look at Shopify and how we can use SmartConnect’s REST Connector to integrate with Shopify.  To get started you will need the following: … [Read More]

eConnect error 9498 – Creating Employee Pay Code

  Tuesday, August 8, 2017   /     Lorren Zemke
Trying to create a Dynamics GP Employee Overtime Pay Code, basing the Pay Rate amount based on the employee's standard wage but I keep receiving the error 9498 – The Pay Type is Overtime or Doubletime and the Pay Factor multiplied by the Based On Rate does not agree with Pay Rate Amount… [Read More]

Error in Key2Act (WennSoft) Job Master Create

  Wednesday, August 2, 2017   /     Lorren Zemke
We are running an integration using SmartConnect into Key2Act's Job Master using the wsiJCJobMaster node and getting the error 10003 for stored procedure=taFSRMALineSerial. Since the stored procedure is encrypted, we are not sure what value is missing. … [Read More]

Tech Tuesday: Error when attempting to export SmartList data to Excel

  Tuesday, August 1, 2017   /     David Youngquist
I have run into issues in support where people are attempting to use the “Export to Excel” feature in SmartList, and receiving an error that says something like, “We found a problem with come content in “My File Name.XLSX”.  Do you want us to try and recover as much as we can?  If you… [Read More]

Login failed for User SmartConnect

  Tuesday, August 1, 2017   /     Lorren Zemke
When trying to log into SmartConnect we receive an error stating, Login failed for user 'SmartConnect'. This may occur trying to log into SmartConnect, running a map, trying to start the SmartConnect Windows Service. Basically, the error could occur anywhere in SmartConnect. … [Read More]

How to completely start over with Extender

  Friday, July 21, 2017   /     David Youngquist
I have a test company that I use for testing Extender objects.  I want to completely delete all Extender objects and data in that company and start over with a clean slate, what is the easiest way to do that? … [Read More]
BY PRODUCT
BY DATE
open all | close all