Hello,
I am making a sample data set here:
List headerTableFields = new List();
headerTableFields.Add(new DataField("JournalName", "DP Journal"));
headerTableFields.Add(new DataField("Company", "dat"));
headerTableFields.Add(new DataField("OffsetCompany", "dat"));
headerTableFields.Add(new DataField("JournalNum", "DAT-000002"));
headerTableFields.Add(new DataField("Invoice", "INV-00001"));
headerTableFields.Add(new DataField("LineNum", -1));
headerTableFields.Add(new DataField("CurrencyCode", "USD"));
headerTableFields.Add(new DataField("AmountCurCredit", 499.99));
headerTableFields.Add(new DataField("AcknowledgementDate", new DateTime(2020, 09, 01)));
headerTableFields.Add(new DataField("TransDate", new DateTime(2020, 09, 01)));
headerTableFields.Add(new DataField("DocumentDate", new DateTime(2020, 09, 01)));
headerTableFields.Add(new DataField("Due", new DateTime(2020, 09, 01)));
IDataRecord headerDataRecord = new DataRecord(headerTableFields);
IDataTable headerTable = new DataTable(new List() { headerDataRecord });
I then convert this data set into an "AxdEntity_LedgerJournalTable" array as follows:
var journalName = GetStringFieldFromRecord(headerTable.DataRecords[0], "JournalName");
var fieldList = new List();
for (var index = 1; index < headerTable.DataRecords[0].DataFields.Count; index )
{
var dataField = new AxdType_DimensionAttributeValue()
{
Name = headerTable.DataRecords[0].DataFields[index].Name,
Value = GetStringFieldFromRecord(headerTable.DataRecords[0],
headerTable.DataRecords[0].DataFields[index].Name)
};
fieldList.Add(dataField);
}
var fieldSet = new AxdType_DimensionAttributeValueSet()
{
Values = fieldList.ToArray()
};
var transaction = new AxdEntity_LedgerJournalTrans()
{
DefaultDimension = fieldSet
};
var vendInvoiceJournalTable = new AxdEntity_LedgerJournalTable()
{
JournalName = journalName,
LedgerJournalTrans = new AxdEntity_LedgerJournalTrans[1] {transaction}
};
var vendInvoiceJournalArray = new AxdEntity_LedgerJournalTable[1]{vendInvoiceJournalTable};
I then pass this object into the "GeneralJournalServiceClient.create" method.
using (GeneralJournalServiceClient axInvoiceJournalClient = new GeneralJournalServiceClient())
{
var callContext = new CallContext()
{
Company = "DAT",
LogonAsUser = logonUser,
Language = "en-us"
};
axInvoiceJournalClient.create(callContext, vendInvoiceJournalArray);
}
This is when I get the error.
Please let me know if you need any more information. I tried to simplify what I provided to make reading it easier. I can provide additional details if needed.
Thank you very much!
