This document provides an in-depth description of how to configure and administer the DynamicPoint AP Automation application for Microsoft Dynamics. Its target audience is the set of individuals tasked with the initial installation, configuration and ongoing maintenance of the application.
2 Settings
When installed, the application creates its own group of configuration pages. These pages are used to configure system-level settings that impact how the application functions within the client environment.
Accessing Settings
To access Settings, complete the following steps:
Access the SharePoint site where the AP Automation App has been installed.
Select site contents and the DynamicPoint AP Automation app.
Select the gear icon
Currencies
The Currencies page is used to configure those applicable currencies for which invoices will be received
Fields
ISO Code ISO Code as found in GP. Required
ERP Code The currency ID (This is specific to integration with Dynamics GP and only required with use of MEM)
Culture Code Culture Code for Currency. Required
Categories
Categories define the building blocks of what is used to create an invoice. They will most often be related to general ledger segments or dimensions or company values, but this is not required.
Fields
Title The name of the category.
Is Active Denotes if this category is active or not.
Type Varies based on the ERP integration selected.
The following options are available:
Dynamics GP:
Company – Category values will be assigned on the header of the expense and correspond to the database the invoice will be integrated with. One Category with this type is required.
MEM-Entity – Category values will be assigned on the header of the expense. One Category with this type is required if using MEM.
MEM-Entity – Category values will be assigned on the header of the expense. One Category with this type is required if using MEM Department functionality.
Account – Category values will be assigned on the allocation items. Required if assigning the GL accounts by category.
Workflow – Category values will be assigned on the header of the expense. This type of category can be used to configure workflow when a 1-1 relationship with an invoice and an approval path is desired.
Dynamics BC/NAV:
Company – Category values will be assigned on the header of the expense and correspond to the database the invoice will be integrated with. One Category with this type is required.
Account – Category values will be assigned on the allocation items. One Category with this type is required.
Dimension 1-8 – Category values will be assigned on the allocation items. Assignment of such will integrate with the corresponding Dimension fields in BC/NAV
Workflow – Category values will be assigned on the header of the expense. This type of category can be used to configure workflow when a 1-1 relationship with an invoice and an approval path is desired.
Invoice Grid Denotes if this category is optional or required in the invoice grid. (MEM and Company type categories default to hidden)
Auto Creation and Template Denotes if this category is optional or required on the templates. (MEM and Company type categories default to hidden)
Order Allows you to arrange the order in which the categories are found on the invoice grid and allocation templates
Relationships Allows you to assign parent/child relationships between the categories
Delete Allows you to delete a category
Category Options
Category Options is used to manage the creation of category options. Prior to this configuration occurring, the categories must exist in the Category page as described in the related section in this document. Categories should not be edited or deleted after configuring Category Options.
Fields
Title The name of the category option.
Value The associated GL account code for the given option. This will only be available for Account and MEM category types.
Active Denotes if this category option is active or not.
General Settings
The General Settings page is used to configure the desired display of the AP Automation web part within the application.
Fields
App Title Define the title of your application.
Grid Header BG Color Defines the background color of the heading row of the parent and child grid. Not required.
Grid Row BG Color Defines the background color of the rows of the parent and child grid. Not required.
Grid Alt Row BG Color Defines the background color of the alternating row of the parent and child grid. Not required.
Grid Hover BG Color Defines the background color of the row over which is the mouse pointer of the parent and child grid. Not required.
Grid Header Font Color Defines the font color of the heading row of the parent and child grid. Not required.
Grid Row Font Color Defines the font color of the rows of the parent and child grid. Not required.
Grid Alt Row Font Color Defines the font color of the alternating row of the parent and child grid. Not required.
Grid Hover Font Color Defines the font color of the row over which is the mouse pointer of the parent and child grid. Not required.
Logo Image Add an icon to the application. Not required.
Attachments Library Select the SharePoint library where invoices will be stored prior to upload to the AP Automation app.
Default tab in attachments dialog Defines the default attachment location when selecting an attachment in the AP Automation app.
Attachment file size limit (KB) Defines the file size limit.
ERP Type Select GP.
ERP Document Date Select what date will be passed as the GP Payable Invoice Date
Invoice Date
Integration Date
Link Back Mode Select what the link back to SharePoint on the GP Payable Invoice will show
Invoice
Review Page
Enable PO Match Select if PO matching is desired.
Disable Invoice Amount Update on PO Match Select if automatic update of the invoice total upon addition of PO items is not desired.
Validate GL Accounts upon Submit If selected the invoice will not be able to be submitted until valid GL accounts are assigned to all allocation line items.
Validate Duplicate Invoice Number If selected an invoice will not be able to be submitted if an existing invoice with the same vendor and invoice number exists. Additionally a warning will appear on the invoice informing the user of the existence of a duplicate.
Invoice Description Required If selected the invoice will not be able to be submitted without populating the Invoice Description on the additional details tab.
Validate Vendor Selection Upon Submit If selected the invoice will not be able to be submitted without assignment of a vendor
Assign Accounts by Category Select if assigning the GL accounts by category association and define the account structure by adding separators, Categories and/or Constants.
Auto Create Invoice Select if auto creation of an invoice from the defined SharePoint library to the AP Automation App is desired.
Template Assignment Column (applicable only when Auto Create Invoice is selected) Select the library column where the template assignment is defined
Enable Currency Selection Select to enable users to pick a currency.
Enable Line Item Description Select to add an available description field to the allocation line items
Enable Vendor Address Selection Select to enable selection of Vendor Address on an invoice. Default will always be the Remit To address.
Allocation Decimal Places Enter the number of decimal places available for the percentage of a given allocation amount on both the In App Templates and Auto Crete Templates
ERP Settings
The ERP Settings page is used to designate the ERP settings used to retrieve data from the integrated ERP. The options will vary based on the ERP selected.
Dynamics GP
Fields
Security Settings
Endpoint Address URL of the path to the DynamicPoint Service (Only the server and potentially port should differ from what is shown above).
GP Server Name Name of the Server where Dynamics GP web services have been installed.
Web Service Domain This is the domain for the account that will be used when interacting with the Dynamics GP Web Services.
Web Service User This is the domain account that will be used when interacting with the Dynamics GP Web Services. This account must be configured with a Role Assignment in the Dynamics Security Console.
Password This is the password of the domain account that will be used when interacting with the Dynamics GP Web Services.
Common Settings
Use GP Voucher Number If this option is selected when creating a payable transaction the next GP voucher number will be determined by GP. If it is not selected then a date/time stamp will be used.
Enable AA This will enable the analytical accounting integration.
MEM
MEM Settings Select the appropriate setting if utilizing MEM in Dynamics GP
Company Settings
Category Option A drop down of all company defined category options will be available. Required.
Company ID The Company ID of the database the invoice will integrate with. Required.
SELECT CMPNYNAM, CMPANYID, INTERID FROM DYNAMICS.dbo.SY01500
Inter ID The Inter ID of the database the invoice will integrate with. Required.
SELECT CMPNYNAM, CMPANYID, INTERID FROM DYNAMICS.dbo.SY01500
Payables Account Enter the payables account. Required.
Default Currency Select currency to default if not defined on the vendor card. Currencies must be configured in the Administration Links in order to be available in the drop down. Required.
Dynamics NAV/BC
Fields
Security Settings
Credential Type Specify the method that will be used to authenticate to NAV or Business Central.
Account The integration account that will be leveraged to connect to the ERP.
Password The password for the integration user.
Client ID The client ID of the Azure App Registration.
Common Settings
Unit of Measure Unit of Measure will be assigned on purchase order line items for non-PO match invoices.
Payload Format The format of the integration file that will be passed to the Business Central API.
You will also have to install the applicable BC extensions which instructions can be found here.
Company Settings
Category Option A drop down of all company defined category options will be available. Required.
Company ID This can be obtained by navigating to the My Settings Page within Business Central. From there go to Help -> Page Inspection.
Inter ID To find your inter ID, follow these steps:
– Log in to your Business Central account and navigate to the Companies tab
– Click the company you want to use
– Click the question mark button on the top right corner and select Help & Support
– Under the troubleshooting section, click Inspect pages and data
– Enter ID in the search field and the first field contains your company ID
Payables Account Enter the payables account. Required.
Default Currency Select currency to default if not defined on the vendor card. Currencies must be configured in the Administration Links in order to be available in the drop down. Required.
In App Templates
In App Templates are used to create invoice templates available to manually select within the app. Prior to this configuration occurring, the categories options must exist in the related section in this document.
Header Fields
Title The name of the template. Required
Vendor Allows selection of a vendor. This is a live query of Vendors from the ERP
Line Item Fields
Percentage Percentage of an invoice total to be assigned to the applicable category options
Additional Fields will be available on the template header and allocation line item based on the category fields configured and can be populated by selecting the appropriate category option from the drop down available for that category.
Auto Creation Templates
Auto Creation Templates are used to automate the creation invoices in the AP Automation App from the Invoice Library. The field, Auto Create Templates, found in General Settings must be selected to use this functionality. Prior to this configuration occurring, the categories options must exist in the related section in this document.
Fields
Title The name of the template. Required
Invoice Number Can leave blank or assign to column in the invoice Library (Relevant with use of OCR). Not required
Invoice Date Can leave blank or assign to column in the invoice Library (Relevant with use of OCR). Not required
Invoice Amount Can leave blank or assign to column in the invoice Library (Relevant with use of OCR). Not required
Description Can leave blank or assign to column in the invoice Library. Not required
Company Allows selection of a Company. Not required
Vendor Allows selection of a vendor. This is a live query of Vendors from GP. Not required
Contributor Allows assignment of a user or group who will be granted contribute rights. Can leave blank or assign to column in the invoice Library. Not required, but lack of population will default to the AP Automation Members group
Auto Assignment Key When assigned in the designated Invoice Library template column, will automate the creation of an invoice in the AP automation application
Percentage Percentage of an invoice total to be assigned to the applicable category options
Additional Fields will be available on the template header and allocation line item based on the category fields configured and can be populated by selecting the appropriate category option from the drop down available for that category.
Webhooks
The Webhooks page is used to enable connection to Microsoft’s Power Automate in order to set up approval workflow if desired. This functionality is not required if submitting an invoice directly to GP where no workflow is required.
Fields
Name The name of the webhook. Required
Action The following options are available. Required
None
Create
Edit / Save
Submit
Type The following options are available and define what type of invoice the web hook applies to. Required
Not Defined
Invoice
PO Invoice Match
PO Receipt Match
Trigger URL This will be the HTTP post url supplied in the flow
User Defined Fields
User defined fields can be added to the Additional Details tab on the AP Automation home page:
Fields
Title Enter the text of your user defined field. Required
Field Type The following options are available. Required
