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

.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

 

Version: Unknown or N/A
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3