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.
