Sign Up Now!Log In
cbolinas 8/8/2007 10:59:52 AM

eConnect SOP Analytical Accounting

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


.DOCNMBR = fDocNumber

.AMOUNT = Math.Round(Math.Abs(Reader1(
"ItemCost")), 2)

.DistSequence = 16384 * fDistributionLineCtr

.ACTNUMST = Reader1(

.aaTrxDimID = 1

.aaTrxDimCode = Reader1(


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?



Version: Unknown or N/A
Section: eConnect