I have written a front-end application for sales invoices and its transferring data to Great Plains using eConnect. Everything looks okay including the creation of AA entries in AAG20000, AAG20001, AAG20002, and AAG20003 tables. The AAG20003 table's aaTrxCodeID fields are 0. I need to populate it with aaTrxCodeID using this code:
'Insert AA for expense
fDimensionLineCtr += 1
Dim SOPDim As New taAnalyticsDistribution_ItemsTaAnalyticsDistributionWith SOPDim
.DOCTYPE = fSOPType
.DOCNMBR = fDocNumber
.AMOUNT = Math.Round(Math.Abs(Reader1("ItemCost")), 2)
.DistSequence = 16384 * fDistributionLineCtr
.ACTNUMST = Reader1("GLCode")
.aaTrxDimID = 1
.aaTrxDimCode = Reader1("CostCenter")
End With
SOPDimension(fDimensionLineCtr) = SOPDim
However, I get an error message: Error Number 9469 stored procedure taAnalyticsDistribution Error Description = Cannot find a distribution amount on input values.
I still get the same error message even if I include .AMOUNT = fExtendedAmount. Is there a way to do this?
Thanks