Here's the start of report. I have tried encapsulating the dataitem("Sales Header".. inside the dataitem(Header; "Sales Invoice Header") like you would an Sales Invoice Line. In this example I moved it out to see if that was the issue. Thoughts?
report 50125 EightyAcresSalesInvoice
{
RDLCLayout = './80AcresSalesInvoice.rdlc';
WordLayout = './80AcresSalesInvoice.docx';
Caption = '80 Acres Sales - Invoice';
DefaultLayout = Word;
EnableHyperlinks = true;
Permissions = TableData "Sales Shipment Buffer" = rimd;
PreviewMode = PrintLayout;
WordMergeDataItem = Header;
dataset
{
dataitem("Sales Header"; "Sales Header")
{
DataItemLinkReference = "Header";
DataItemLink = "No." = Field("Order No.");
column(No_; "No.") { }
column(Sell_to_Customer_Name; "Sell-to Customer Name") { }
dataitem("Sales Line"; "Sales Line")
{
DataItemLinkReference = "Sales Header";
DataItemLink = "Document No." = field("No.");
column(OrderQuantity; Quantity) { }
column(OrderQuantityShipped; "Quantity Shipped") { }
column(Description; Description) { }
Column(Unit_of_Measure; "Unit of Measure") { }
column(Allow_Line_Disc_; "Allow Line Disc.") { }
column(Unit_Price; "Unit Price") { }
column(Amount; Amount) { }
}
}
dataitem(Header; "Sales Invoice Header")
{
DataItemTableView = SORTING("No.");
RequestFilterFields = "No.", "Sell-to Customer No.", "No. Printed";
RequestFilterHeading = 'Posted Sales Invoice';
column(CompanyAddress1; CompanyAddr[1])
{
}
column(CompanyAddress2; CompanyAddr[2])
{
}
column(CompanyAddress3; CompanyAddr[3])
{
}
column(CompanyAddress4; CompanyAddr[4])
{
}
column(CompanyAddress5; CompanyAddr[5])
{
}
column(CompanyAddress6; CompanyAddr[6])
{
}
column(CompanyAddress7; CompanyAddr[7])
