Integrating AIT with eConnect in the General Ledger

AIT provides unique integration capabilities via stored procesures you can call from eConnect.  These procedures can be called to handle all of the complexity that accomanies creating an AIT Journal Entry.

Tips:
– Due From/Due To accounts are assigned automatically, so you can leave them empty.

GL Stored Procedures:

itwsGLSaveAITHeader

Use this procedure to create a header record for an AIT Journal Entry.  If you don’t need to do this, the itwsGLSaveAITDistribution procedure will automatically create a header.

* This parameter exists only in AIT 2010m125 or higher.  This does not need to be called unless you want to assign an originating company when using SPARC or internal companies.

itwsGLSaveAITDistribution

Use this procedure to create distribution records.  When creating distributions, include only the ultimate distribution and do not try to create any GP distributions, such as non-intercompany or the due from/due to distributions: the stored procedure will take care of that for you. Always assign a default value to each parameter: never use a null value.  If using eConnect, use this procedure instead of the GP procedure.  You will need to create the GP Header record before creating any distribution rows in order to assure data integrity and proper calculation of transaction details.

itGLSummarizeDistributions

Use this procedure to summarize any due from/due to distributions.  This can be run only once per transaction and must be run after the last distribution has been created.