Posts Tagged ‘Accounting’

You are not allowed to have negative actual quantity importing Project Accounting Timesheets

Importing Project Accounting Timesheets using SmartConnect and receiving an error that says, “Error Number = 1256 Stored Procedure= taPATimeSheetLineInsert Error Description = You are not allowed to have negative actual quantity”What typically causes this is importing a batch of timesheets, deleting the batch, and then importing them back in again.  In order to resolve the…

[Read More]

Journal Entry on line 12 is not a valid line.

When running the Excel template named GL Journal Entry – V2013.1.xlsm receiving an error that says “Journal Entry on line 12 is not a valid line”, followed by a second error that says “Journal Entry on line 13 is not a valid line”.  The error message pops up in Excel and looks like the following.…

[Read More]

Creating Payables Transaction with Analytical Accounting (AA)

One of the most confusing pieces of data to integrate into Dynamics GP is anything with Analytical Accounting. The main confusion comes from the fact that the field naming conventions don’t necessarily match the main module. For example, the Document Number field on the AA distribution is not the Payables Document Number but the Payables…

[Read More]

Budget vs Actual SmartList Builder Template

The Budget vs Actual SmartList Builder setup is built to give you a list of the budget amounts compared to the actual amounts in General Ledger.  The setups for Excel Report Builder and Navigation List Builder are duplicates of the SmartList Builder setup.ID: GL_BDGTVSACTLName: Budget vs ActualTables Involved: Budget Summary MasterBudget MasterAccount MasterAccount Current Summary Master Screen shot of Setup…

[Read More]

A Business Manager’s Perspective on The Ease of SmartView

Upon being employed as the Business Manager at eOne, I realized my most valuable tool was SmartView. Not only for fast reporting, but because it was extremely easy to learn.  I had never used GP, only other accounting software like Quickbooks. When learning GP, one of the most frustrating parts for me was to see…

[Read More]

Requirements for Analytical Accounting source files

Outlines the requirements for getting Analytical Accounting maps running in SmartConnect.Analytical Account maps can be one of the more difficult items to create using SmartConnect. The issue is not in the mapping, which is fairly simple, the issue is with generating a source file that can be used for Analytical Accounting information. As an example,…

[Read More]

Tips for constructing and troubleshooting maps that include Analytical Accounting.

Explains the best processes and tips to use when constructing and troubleshooting SmartConnect maps with Analytical Accounting (AA) information.An AA map will either have 3 or 4 levels.1. Header Mapping2. Line Item Mapping3. Distribution Mapping4. AA mapping. General Ledger (GL), Accounts Receivable (AR), and Accounts Payable (AP) will only have levels 1,3, and 4. Sales…

[Read More]


Use the REST Connector to parse nested Value Arrays
SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site



open all | close all


Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training