I am attempting to post a new AP transaction with a few line items to CenterPoint and I am receiving an error. On the post using API.TransactionPresenter.PostNewTransaction(), I receive this exception:

Index was out of range. Must be non-negative and less than the size of the collection.

For the transaction I am only assigning a company, transactiondate, datedue, and transnumber. For each line item I am assigning an account, amount, creditamount, and debitamount.

Any idea what this error message means or what I can do to post my transactions successfully?

[img=https://imgur.com/jEOSq3K]Example Data[/img]

This is the example data I am working with. I have made adjustments per your suggestions and still receiving the error.

I am not 100% certain what you mean by "you should only need to set the Amount field as the credits and debits are taken care by the post". The numbers are not negative in the data, so how will CenterPoint know whether it's a credit/debit if I only include the amount per line? I am guessing I will have to handle when to add it into the detail line as a positive negative in response to it being a debit/credit?

Here is my current code for building the AP Item and detail lines:

For Each apit As cpAPObject In apItems
Try
With API.TransactionPresenter
.Company = API.LookupId(LookupFields.Company, LookupColumns.Name, "Ringneck Energy")
.Name = API.LookupId(LookupFields.Vendor, LookupColumns.Abbreviation, Trim(apit.vendorID))
.TransactionDate = apit.docDate
.DateDue = apit.dueDate
.TransNumber = apit.docNo
.NewTransaction(TransactionTypeTypes.ApInvoice)
For Each ln As cpLineItem In apit.lineItems
If (ln.credit <> 0) Then
.AddAccountLine(API.LookupId(LookupFields.Account, LookupColumns.AccountNumber, ln.distAcct), ln.credit)
Else
.AddAccountLine(API.LookupId(LookupFields.Account, LookupColumns.AccountNumber, ln.distAcct), ln.debit)
End If
' line.LineValues.AddReplace(InputFieldTypes.TaxAmount, ln.taxAmt)
Next
.MemoLine1 = apit.poNo
.PostNewTransaction()
End With

Oh I was unaware that I needed to set the account for the entire transaction. From the data I have, there is only 1 account field, the Dist Acct, and it differs from line to line. Can the account be looked up in some way based on defaults? Or are you confident that APs will all have the default account # of 2000-00? Or should I input each of these as a separate transaction with the account # listed?

Oh it's quite alright. So an update: I was able to get the AP records to transfer correctly. I am now working on getting the General Journal Entries to transfer over. I followed the example from the TestTransactionPresenter project to add 4 lines to the GeneralJournalPresenter object, the credit/debit amounts are changing successfully, but if I try to post the transaction I receive the error "You must have at least two journal entry rows in the grid before you can continue".

I added the rows using .AddLineItem(AccountID, Amount, true/false) but the only collection that might be correct inside the GeneralJournalPresenter is "TransactionLinesKeys" which even after adding new line items still turns up with 0.

The data I am inputting are 2 different entries with 2 offsets. Do I need to ignore the offsets, I'm guessing?

Edit:

Nevermind I have figured it out. I was doing a .NewTransaction after adding the line items which was deleting the line items. Both the AP and GL entries are now showing up in CenterPoint correctly! Thanks so much for your help!

Edited by user Wednesday, November 14, 2018 10:52:40 PM(UTC)  | Reason: Not specified