Configuring Tungsten AP Essentials for use with Microsoft Dynamics AX 2012
This topic describes the settings you must adjust in Tungsten AP Essentials in order to process invoices with Microsoft Dynamics AX 2012.
Company mapping
The organizational hierarchy in Tungsten AP Essentials corresponds to the customer organization. Keep in mind:
- A Dynamics AX company belongs to the lowest Tungsten AP Essentials organization in the hierarchy.
- The lowest Tungsten AP Essentials organization must contain the Dynamics AX company code as an external ID.
In other words, if an Tungsten AP Essentials customer has buyers, the buyers correspond to Dynamics AX companies. If customer does not have buyers then customer is the lowest level and that means the customer belong to the AX company.
Extraction service settings
The Extraction service settings deal with fields that are captured and interpreted on the invoices. Do not confuse these fields with coding fields, which are covered later in this guide. You can specify these custom fields, if you want to give workflow operators more control
Approver field
The integration configuration proposes a default approver that is used for invoice registration and approval; however, you can override this value using a custom field. This way, you can modify the approver during verification.
To utilize this feature, add a custom field to the document type and use these settings in the Add header field view:
Type name | Approver |
Name | Approver |
Display name | Any value |
Type | String |
Accept empty value | Selected |
Enforce validation | Selected |
Use master data to suggest field values | Selected |
User master data to validate the field values | Selected |
Field format | .* |
When Accept empty value is selected and the field is empty (during verification), the integration uses the value specified in the Default approver setting.
Sales tax group field
The integration configuration proposes a default sales-tax group that is used for invoice registration; however, you can override this value using a custom field. This way, you can modify the sales-tax group during verification.
To utilize this feature, add a custom field to the document type and use these settings in the Add header field view:
Type name | SalesTaxGroup |
Name | SalesTaxGroup |
Display name | Any value |
Type | String |
Accept empty value | Selected |
Enforce validation | Selected |
Use master data to suggest field values | Selected |
User master data to validate the field values | Selected |
Field format | .* |
When Accept empty value is selected and the field is empty (during verification), the integration uses the value specified in the Default sales tax group setting.
Item sales tax group field
The integration configuration proposes a default sales-tax group that is used for invoice registration; however, you can override this value using a custom field. This way, you can modify the sales-tax group during verification.
To utilize this feature, add a custom field to the document type and use these settings in the Add header field view:
Type name | ItemSalesTaxGroup |
Name | Item Sales Tax Group |
Display name | Any value |
Type | String |
Accept empty value | Selected |
Enforce validation | Selected |
Use master data to suggest field values | Selected |
User master data to validate the field values | Selected |
Field format | .* |
When Accept empty value is selected and the field is empty (during verification), the integration uses the value specified in the Default item sales tax group setting.
Posting date
By default, the Dynamics AX integration uses the Dynamics AX system date as the posting date; however, you can override this value using a custom field. If you leave the custom field empty, or if you do not create the custom field, the Dynamics AX system date is used as the posting date.
To utilize this feature, add a custom field to the document type and use these settings in the Add header field view:
Type name | PostingDate |
Name | PostingDate |
Display name | Any value |
Type | Date |
Accept empty value | Selected |
Enforce validation | Not selected |
Use master data to suggest field values | Not selected |
User master data to validate the field values | Not selected |
Field format | n/a |
When Accept empty value is selected and the field is empty (during verification), the integration uses the value specified by the Posting date custom field. If the Posting date field is missing or not set, the current system date is used.
Voucher description field
The Dynamics AX integration configuration specifies a default voucher description template; however, you can override this value using a custom field. This way, you can modify the voucher description during verification.
To utilize this feature, add a custom field to the document type and use these settings in the Add header field view:
Type name | Text |
Name | Text |
Display name | Any value |
Type | String |
Accept empty value | Selected |
Enforce validation | Selected |
Use master data to suggest field values | Not selected |
User master data to validate the field values | Not selected |
Field format | .* |
When Accept empty value is selected and the field is empty (during verification), the integration uses the value specified in the Journal description template setting.
Master data service settings
Master data on customer level and Let users update supplier data when verifying invoices cannot be selected in the Master data settings.
Process control service settings
The Keep batch together setting cannot be selected.
Storage service settings
You can adjust the Storage service settings to suit your needs.
- If the Storage service is disabled, you can choose to save images to a local folder that you can specify in Tungsten AP Essentials Connect.
- If the Storage service is enabled and the Create image link settings is selected, the integration creates a shortcut in the Dynamics AX archive folder, which links to the storage image.
- If the Storage service is enabled and the "Create image link" setting is not selected, the integration configuration can save the image in a shared folder that you can specify in Tungsten AP Essentials Connect.
Target system service settings
The target system settings for the Dynamics AX target system vary, depending on whether you use the embedded target system or AP Essentials Connect to configure the integration.
- If you use the embedded target system to configure the integration, you can configure these target-system settings.
- If you use AP Essentials Connect to configure the integration, you can configure these target-system settings.
Verification service settings
The Allow account coding during verification setting cannot be selected.
Workflow service settings
This topic describes settings that are specific to the Dynamics AX integration.
Account types
The Dynamics AX integration supports invoice coding for these types of invoices:
- General Ledger - for invoices that require account coding.
- General Ledger with projects - for invoices that require account and project coding.
You must specify an Account type for each invoice type you want to process. You do not need to specify an account types that you do not use.
General ledger
Use this account type for coding general-ledger invoices. Users who code general-ledger invoices specify the account number and the other information such as the sales tax group, item sales tax group, dimensions etc.
When you add and account type for general-ledger invoices, use these settings in the Account type view:
Name | Any value. |
Internal name | GeneralLedger |
General Ledger with projects
Use this account type for coding general-ledger invoices with projects. Users who code general-ledger invoices specify the project number and the other information such as the sales tax group, item sales tax group, dimensions etc.
When you add and account type for general-ledger invoices, use these settings in the Account type view:
Name | Any value. |
Internal name | Project |
Coding fields
The Workflow service settings described in this section deal with coding fields. Do not confuse these fields with invoice fields.
The Dynamics AX integration supports coding fields such as:
Sales Tax Group
The Dynamics AX integration configuration proposes default sales-tax groups. The default value can be overridden for approval on a specific coding row using a coding field. This way, you can modify the sales-tax group for a specific coding row during approval.
This coding field can be used for general-ledger coding and general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | SalesTaxGroup |
Available for account types | Ledger and Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Item Sales Tax Group
The Dynamics AX integration configuration proposes default item sales-tax groups. The default value can be overridden for approval on a specific coding row using a coding field. This way, you can modify the item sales-tax group for a specific coding row during approval.
This coding field can be used for general-ledger coding and general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | ItemSalesTaxGroup |
Available for account types | Ledger and Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Coding dimensions
A standard Dynamics AX integration supports three dimensions: Department, Center and Purpose. If you require additional dimensions that correspond to other dimensions in Dynamics AX, you can add a coding field for each dimension that you require using the settings in the Coding field dialog described below.
This coding field can be used for general-ledger coding and general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | The internal name of the dimension (Department, Center, Purpose etc.) |
Available for account types | Ledger and Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Text
The Dynamics AX integration configuration specifies a default voucher description template that is used during invoice registration; however, you can override this value on a specific coding row using a coding field. This way, you can modify the voucher description on a certain coding row for approval during coding.
This coding field can be used for general-ledger coding and general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | Text |
Available for account types | Ledger and Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Not selected |
When Accept empty value is selected and the field is empty (during approval), the integration uses the invoice registration value that is created from the configuration template.
Project Category
The Dynamics AX integration can set the project category for a specific row. In Tungsten AP Essentials, the value can be defined on a specific coding row using a coding field. This way, you can specify the project category for a specific coding row during approval.
This coding field can only be used for general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | ProjectCategory |
Available for account types | Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Project Employee
The Dynamics AX integration can set the project employee for a specific row. In Tungsten AP Essentials, the value can be defined on a specific coding row using a coding field. This way, you can specify the project employee for a specific coding row during approval.
This coding field can only be used for general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | ProjectEmployee |
Available for account types | Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Project Line Property
The Dynamics AX integration can set the project line property for a specific row. In Tungsten AP Essentials, the value can be defined on a specific coding row using a coding field. This way, you can specify the project line property for a specific coding row during approval.
This coding field can only be used for general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | ProjectLineProperty |
Available for account types | Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Project Sales Currency
The Dynamics AX integration can set the project sales currency for a specific row. In Tungsten AP Essentials, the value can be defined on a specific coding row using a coding field. This way, you can specify the project sales currency for a specific coding row during approval. If you do not specify a value for the project sales currency during approval, the default value from the currency field is used.
This coding field can only be used for general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | ProjectCurrency |
Available for account types | Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Project Sales Price
The Dynamics AX integration can set the project sales price for a specific row. In Tungsten AP Essentials, the value can be defined on a specific coding row using a coding field. This way, you can specify the project sales price for a specific coding row during approval. If you do not specify a value for the project sales price during approval, the default value from the amount field is used.
When coding, the value must be formatted using a period as the decimal separator. For example: 0.00
This coding field can only be used for general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | ProjectSalesPrice |
Available for account types | Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Not selected |
Project Sales Tax Group
The Dynamics AX integration can set the project sales tax group for a specific row. In Tungsten AP Essentials, the value can be defined on a specific coding row using a coding field. This way, you can specify the project sales tax group for a specific coding row during approval. If you do not specify a value for the project sales tax group during approval, the default value from the sales tax group field is used.
This coding field can only be used for general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | ProjectTaxGroup |
Available for account types | Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Project Item Sales Tax Group
The Dynamics AX integration can set the project item sales tax group for a specific row. In Tungsten AP Essentials, the value can be defined on a specific coding row using a coding field. This way, you can specify the project item sales tax group for a specific coding row during approval. If you do not specify a value for the project item sales tax group during approval, the default value from the item sales tax group field is used.
This coding field can only be used for general-ledger coding with projects.
To use this feature, add a coding field and use these settings in the Coding field view:
Display name | Any value. |
Internal name | ProjectTaxItemGroup |
Available for account types | Project |
Show coding field as a sub line | Any value (Selected recommended) |
Accept empty value | Selected |
Use coding-field master data | Selected |
Coding lines
Coding lines are required must be selected to make sure the user codes at least one row.
General
Allow balancing against total amount must be selected to enforce coding amount validation and enable amount-split assistance.
The balancing amount field depends on the Approval journal configuration in Dynamics AX. The approval journal setting, Amount includes sales tax, in the Sales tax section of your coding, determines whether you balance against the net or gross amount:
- If Amount includes sales tax is not selected (recommended), you balance against the net amount.
- If Amount includes sales tax is selected, you balance against the gross amount.