ECM - Pre-Create Datalinks return 2 x Line GL

ECM
1

My workflow loop through Pre-Create and Validate Invoice

image
image364×368 36.8 KB

This is to allow user to fix up Tax variances.

I have noticed that after the Datalink Pre-Create Invoice that there is a field that when I run it 2nd time, the AllowTaxChange will be check to true.

Here is the recorded output from the Datalink Pre-Create Invoice. The GL Analysis has duplicated. Has anyone got the same issue?


<Output Key="LineTax_DocScrReportableAmt" Name="$doc.$fieldgroups.LineTaxes.TAX_ReportableAmt" />
          <Output Key="LineTax_DocScrTaxableAmt" Name="$doc.$fieldgroups.LineTaxes.TAX_TaxableAmt" />
          <Output Key="LineTax_DocScrTaxAmt" Name="$doc.$fieldgroups.LineTaxes.TAX_TaxAmt" />
          <Output Key="LineTax_ScrDocFixedAmount" Name="$doc.$fieldgroups.LineTaxes.TAX_FixedAmount" />
          <Output Key="HdrGL_DocScrExpAmt" Name="$doc.$fieldgroups.HeaderGLAnalysis.GL_ExpAmt" />
          <Output Key="HdrGL_GLAccountDisp" Name="$doc.$fieldgroups.HeaderGLAnalysis.GL_AccountDisp" />
          <Output Key="HdrGL_GLAccountDesc" Name="$doc.$fieldgroups.HeaderGLAnalysis.GL_Description" />
          <Output Key="LineGL_InvoiceLine" Name="$doc.$fieldgroups.LineGLAnalysis.GL_InvoiceLine">["1","1"]</Output>
          <Output Key="LineGL_ExtCompanyID" Name="$doc.$fieldgroups.LineGLAnalysis.GL_ExtCompanyID">[null,null]</Output>
          <Output Key="LineGL_ExtGLAccount" Name="$doc.$fieldgroups.LineGLAnalysis.GL_ExtGLAccount">[null,null]</Output>
          <Output Key="LineGL_DocScrExpAmt" Name="$doc.$fieldgroups.LineGLAnalysis.GL_ExpAmt">["231.8","231.8"]</Output>
          <Output Key="LineGL_GLAccountDisp" Name="$doc.$fieldgroups.LineGLAnalysis.GL_AccountDisp">["01000-000-22850","01000-000-22850"]</Output>
          <Output Key="LineGL_GLAccountDesc" Name="$doc.$fieldgroups.LineGLAnalysis.GL_Description">["GRNI Accrual - SS - 000 ","GRNI Accrual - SS - 000 "]</Output>
          <Output Key="@@Exception" Name="$doc.Status" />
2

The Pre-Create and Create datalinks will populate the LineGLAnalysis and HeaderGLAnalysis field groups, as well as subgroup the LineGLAnalysis field group. If you plan to run these datalinks more than once you will likely need to clear these field groups before the second, third, n times you run that same datalink.

1 Like
3

Thanks for your help. I would like to know if there is any documentation on the predefined datalinks?

4

Not that I am aware of. You more or less go by the name of datalink, the data it returns and where in the context of the workflow process it is to determine what it is designed to do. It can be a lot of trial and error to figure out how to make them work for your needs, sometimes.

5

In my experience, this means that a field is being used twice in an output.

6

Unfortunately, Not many have documentation.

7

Check your gl in your output for duplicates.