Integration Manager with Analytical Accounting

(0) Share

Report

Posted on by Community Member

Hi,

I understand that IM 10 SP3 has incorporated the destination mappings for analytical accounting via econnect adapter. I have tried many times but and yet still not able to get the AA Code information imported into a GL transaction.

Kindly advice with some sample steps and/or sample files to integrate AA transaction.

Thanks and regards,

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

callen 4,595 on at

Like (0)

Report

Send me an e-mail and I'll send you examples. It's not that hard but the documentation is less than stellar.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks allen for the sample file. But is there any alternative way whereby if i do not want to have the journal number being setup in the source file? i tried once i remove the journal number mapping, system gave me the following error message and the integration fail.

DOC 1 ERROR: System.Data.SqlClient.SqlError: Procedure or function
'taAnalyticsDistribution' expects parameter '@I_vDOCNMBR', which was
not supplied.

Was this reply helpful? Yes No
callen 4,595 on at

Like (0)

Report

This is really just an integration manager how-to question. You can use default as the mapping for the journal entry number. You need to read the user guide to understand how to create mappings.

Was this reply helpful? Yes No
callen 4,595 on at

Like (0)

Report

You also need to have a field that is used to join the header to the line items. It doesn't have to be the journal entry number. But you need something that would be in common, like a date. You don't have to map the field but it needs to be in the file for your queries and to establish a relationship between them.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Allen,

I have followed the exactly relationship linkage as per your attached file. The only different is the mapping, whereby i map the DocNo into General Journal Reference field, and let the journal# field to be default.

When i run the IM file, the following error message prompt. Do you have any idea of it?

DOC 1 ERROR: System.Data.SqlClient.SqlError: Procedure or function 'taAnalyticsDistribution' expects parameter '@I_vDOCNMBR', which was not supplied.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear All,

It has been confirmed by Microsoft Support Center whereby the journal entry number is not able to use DEFAULT
when integrating transaction with AA.

Therefore, i'm thinking of using VB script to generate / assign the journal number instead.
Can anyone share with me the sample scripts i can use?

Thanks in advance.

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

You can add the following script to your Journal Number fields script:

' Created by Mariano Gomez, MVP
Const adUseClient = 3
Const adCmdStoredProc = 4
Const adSmallInt = 2
Const adInteger = 3
Const adTinyInt = 16
Const adChar = 129
Const adParamInput = 1
Const adExecuteNoRecords = 128

Dim oCn
Dim oCmd
Dim bCheckWorkFiles, iSpid, iJournal, iOK, iErrorState

set oCn = CreateObject("ADODB.Connection")
oCn.ConnectionString = "database=" & GPConnection.GPConnIntercompanyID
oCn.CursorLocation = adUseClient
GPConnection.Open(oCn)

With oCmd
   .ActiveConnection = oCn
   .CommandType = adCmdStoredProc or adExecuteNoRecords
   .CommandText = "dbo.glGetNextJournalEntry"
   'Set parameters
   set bCheckWorkFiles = .CreateParameter("l_tINCheckWORKFiles", adTinyInt, adParamInput, 4, 1)
   .Parameter.Append bCheckWorkFiles

   set iSpid = .CreateParameter("I_iSQLSessionID", adInteger, adParamInput, 8, 1)
   .Parameter.Append iSpid

   set iJournal = .CreateParameter("IO_iOUTJournalEntry", adInteger, adParamOutput, 8, 0)
   .Parameter.Append iJournal

   set iOK = .CreateParameter("O_tOUTOK", adTinyInt, adParamOutput)
   .Parameter.Append iOK

set iErrorState = .CreateParameter("O_iErrorState", adInteger, adParamOutput)
   .Parameter.Append iErrorState

   .Execute
End With

If iErrorState.Value <> 0 Then
    CurrentField = iJournal.Value
End If

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mariano,

I'm sorry as my knowledge in scripting is not that good.

What i did was, i copy and paste your script exactly into the IM mapping > Journal# field's script.

When i run, hit the following error:

"DOC 1 ERROR: Object required: 'oCmd'"

Did i do anything wrong or left out any changes required?

Thanks and best regards,

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

set oCn = CreateObject("ADODB.Connection")
set oCmd = CreateObject("ADODB.Command")

This script is provided "AS IS" with no warraties expressed or implied.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Good Day Mariano,

I have amended the script accordingly but hit the following error. Do you have any idea what did i do wrong?

"DOC 1 ERROR: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

Thanks in advance.

Was this reply helpful? Yes No