Unable to load data AX VendorInvoiceLine

(0) Share

Report

Posted on by Community Member

I am trying to insert data to "VendorInvoiceLine" using Integration services. I have mapped several field but i got error below.

Reason: BadRequest, Detailed Message: {
"error": {
"code": "",
"message": "An error has occurred.",
"innererror": {
"message": "Write failed for table row of type 'VendorInvoiceLineEntity'. Infolog: Warning: Item or category must be specified.; Warning: validateWrite failed on data source 'VendInvoiceInfoLine (VendInvoiceInfoLine)'.",
"type": "Microsoft.Dynamics.Platform.Integration.Services.OData.AxODataWriteException"
}
}
}) (SSIS Integration Toolkit for Microsoft Dynamics 365, v10.1.0.6932 - DtsDebugHost, v12.0.2000.8)System.Net.WebException

0882.1.png

Categories:

Connected Field Service

All responses (2)

Answers (0)

Sort by

Suggested answer

Adrian Begovich 1,032 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Pubudu De Silva,

You will need to map both Item and Category to fix this error.
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

There is no column called Item or Category. Could you please specify the column? I am not clear about that column.

Thanks