Integrating AIT with Dynamics GP Payables Management

AIT SPARC provides unique integration capabilities because it is not dependent on any specific user interface integration. SPARC allows you to integrate transactions into AIT and GP if you are using eConnect, custom integrations that directly update GP SQL tables, Integration Manager or other products that utilize eConnect.

SPARC utilizes SQL triggers that call specific AIT stored procedures to update AIT work tables. To take advantage of these triggers and stored procedures, you need only configure SPARC in AIT. SPARC will take care of the rest. However if you have more specific integration requirements that do not fit into SPARC configuration, you can utilize the AIT stored procedures to add AIT distributions.

Tips:
Always assign a default value to each parameter: never use a null value. If any value is null, error 22001 is returned in the Result output parameter.
Decimal Places are sometimes 1 less than value in the GP table.
Due From/Due To accounts are assigned automatically, so leave them 0.
Use the IC00100 table in the DYNAMICS database to lookup cross-company GL Account Indexes.
Multicurrency information can be assigned defaults if MC is not registered. If it is registered, they are required.
SPARC is available in AIT for GP 2010 (build 11.0m68 or higher) and AIT 10.0 (build 10.0m121 or higher).

PM Stored Procedures:

itPMSaveAITHeader
Use this procedure to create a header record for an AIT Payables Voucher. This should be executed before any AIT distributions are created.

Parameter
Data Type
Required
Direction
Notes
Batch Number
char(15)
Yes
in
Same as GP Voucher
Batch Source
char(15)
Yes
in
must be ‘PM_Trxent’
Voucher Number
char(20)
Yes
in
Same as GP Voucher
Document Number
char(15)
Yes
in
Same as GP Voucher
Vendor ID
char(15)
Yes
in
Same as GP Voucher
Transaction Amount
numeric(19,5)
Yes
in
Same as GP Voucher
Originating Transaction Amount
numeric(19,5)
No
in
Same as GP Voucher
Description
char(30)
No
in
Additional Reference
Sequence
int
No
in
Last Distribution Sequence Used
Currency ID
char(15)
No
in
Same as GP Voucher
Currency Index
datetime
No
in
Same as GP Voucher
Originating Company ID
char(5)
No
in
This must be a company internal to the current database