Skip to content
+1-888-319-3663

HELP ARTICLE

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 Mapping

2. Line Item Mapping

3. Distribution Mapping

4. AA mapping.

General Ledger (GL), Accounts Receivable (AR), and Accounts Payable (AP) will only have levels 1,3, and 4. Sales Order Processing (SOP) and Purchase Order Processing (POP) maps will contain all 4 levels. When constructing AA maps, you MUST import all the distributions. It is not possible to default distributions and import AA information. If you want AA information, you must map and import ALL the debits and credits that make up your distributions. It is best to attack the process in a step by step basis. If you start off mapping all 3 or 4 levels, you do not know which level of mapping is causing the issue. It may error out on an AA mapping, but it is actually the distribution mapping that is causing the issue.

When doing GL maps, levels 1 and 3 are always required. The steps to create a map could be summarized as follows:

1. Create a basic GL transaction with debits and credits. Test the map and verify it works 100% before moving to step 2.

2. Add your AA information to the map. You may have to add and remove columns and groupings as you map the AA information. If you add or move any columns, or adjust the grouping, move back to step 1 and unmap your AA information and verify it works 100% before trying to map the AA information again.

When doing AR and AP maps, level 1 is the only item that is required. You can actually default all the distributions. The steps to create a map could be summarized as follows:

1. Create a basic AR or AP transaction and map just the header information. Default all the debits and credits. Test the map and verify it works 100% before moving to step 2.

2. Add your distributions and map your debits and credits. You may have to add and remove columns and groupings as you map the debits and credits information. If you add or move any columns, or adjust the grouping, move back to step 1 and unmap your distribution information and verify it works 100% before trying to map the distribution. Once the map works 100% and all the distributions are coming in correctly, then move to step 3.

3. Add your AA information to the map. You may have to add and remove columns and groupings as you map the AA information. If you add or move any columns, or adjust the grouping, move back to step 2 and unmap your AA information and verify it works 100% before trying to map the AA information again.

When doing SOP and POP, level 1 and level 2 are required. You can actually default all the distributions. The steps to create a map could be summarized as follows:

1. Create a basic SOP or POP transaction and map just the header information and the line item information. This will be a basic SOP or POP document with line items attached to it. Default all the debits and credits. Test the map and verify it works 100% before moving to step 2.

2. Add your distributions and map your debits and credits. You may have to add and remove columns and groupings as you map the debits and credits information. If you add or move any columns, or adjust the grouping, move back to step 1 and unmap your distribution information and verify it works 100% before trying to map the distribution. Once the map works 100% and all the distributions are coming in correctly, then move to step 3.

3. Add your AA information to the map. You may have to add and remove columns and groupings as you map the AA information. If you add or move any columns, or adjust the grouping, move back to step 2 and unmap your AA information and verify it works 100% before trying to map the AA information again.

Following this step by step guide ensures success when creating a transaction with AA information.

RECENT POSTS


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.

POPULAR POSTS


SSL Security error using OLEDB Connection
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
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

CATEGORIES

TAGS

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 SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.