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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]