Dear community,
For my client I have the requirement to add the item attributes to their sales invoice.
On the "Standard Sales - Invoice" (Report 1306) the attributes are not, by default, available and to solve this I have written a report extension:
reportextension 50108 ExtendedSalesInvoice extends "Standard Sales - Invoice"
{
dataset
{
addlast(Line)
{
dataitem("ItemAttributes"; "Item Attribute Value Mapping")
{
DataItemLink = "No." = field("No.");
DataItemLinkReference = Line;
// TABLE: Item Attribute Value (7501)
dataitem("ItemAttributeValue"; "Item Attribute Value")
{
DataItemLink = "ID" = field("Item Attribute Value ID");
column(AttributeName; "Attribute Name")
{
}
column(ValueValue; "Value")
{
}
}
}
}
}
}
After building and pushed the code to my sandbox (Run->run without debugging) I am not able to locate the new attribute fields in the word report. To verify the fields, I have exported the standard word report from Business Central, menu Report Layouts->Report 1306.
Would anyone mind pointing me in the right direction why the fields are not visible in the report, and also, how do I add the attributes into the report, below the item line?
Thank you in advance.
