I want to bulk-create sales invoices in Exact Online using the following statement, where the table temp_invoices@sql is a table containing invoice data:
use DIVISIONCODE@eol
begin transaction
insert into ExactOnlineREST..SalesInvoices@eol
( InvoiceTo
, InvoiceToContactPerson
, DeliverTo
, OrderedBy
, YourRef
, Description
, Currency
, InvoiceDate
, Journal
, Type
)
select pie.InvoiceInvoiceToId
, pie.InvoiceToContactPerson
, pie.InvoiceDeliverToId
, pie.InvoiceOrderedBy
, pie.InvoiceYourRef
, pie.InvoiceDescription
, pie.InvoiceCurrency
, pie.InvoiceDate
, pie.InvoiceJournal
, pie.InvoiceType
from temp_invoices@sql pie
identified by pie.InvoiceIdentifiedBy
insert into ExactOnlineREST..SalesInvoiceLines@eol
( StartTime
, EndTime
, Item
, Quantity
, Description
)
select to_date('${NEXT_YEAR}0101', 'YYYYMMDD')
, to_date('${NEXT_YEAR}1231', 'YYYYMMDD')
, itm.Id
, pie.InvoiceQuantity
, pie.InvoiceLineDescription
from temp_invoices@sql pie
join ExactOnlineREST..Items@eol itm
on itm.Code = pie.InvoiceItemCode
attach to pie.InvoiceIdentifiedBy
commit
The transactional insert on ExactOnlineREST..SalesInvoices fails with:
itgensql697
Missing expression name.
with call stack:
InvantiveSystemException
at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Nullable1 isRecoverable, String poolIdentityId, String url, Nullable1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId) at Invantive.Basics.InvantiveSystemException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Boolean isRecoverable, String poolIdentityId, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
at Invantive.Sql.V1.ProjectionIterator.<>c__DisplayClass2_0.b__0(AggregationMetadata , Int32 )
at System.Linq.Enumerable.d__52.MoveNext() at System.Linq.Enumerable.<ConcatIterator>d__591.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext() at System.Linq.Buffer1..ctor(IEnumerable1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable1 source)
at Invantive.Sql.V1.FirehoseResultSet.QualifyFields(GlobalState owner, ExecutionOptions executionOptions, String scope, IEnumerable1 fields) at Invantive.Sql.V1.ProjectionIterator..ctor(GlobalState owner, ExecutionOptions executionOptions, IProviderManager manager, FirehoseResultSet sourceFirehoseResultSet, AggregationMetadata[] selectParts) at Invantive.Sql.V1.SelectStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SparseArrayPool sparseArrayPool, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.InsertStatementTree.<Fetch>d__37.MoveNext() at Invantive.Data.CompressedEnumerable1.d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.d__71.MoveNext()
…
This did work under 24.0, but apparently no longer in 25.0.141.
How do I fix this?