Dynamics Community Forum Thread Details

I am extending a report from Warehouse Insight so I can use there barcode generator.

I can product a barcode using this method but I am having trouble getting additional fields from the Item table and linking them to the barcode text.

barcodeText := itemGTIN   variable   itemDesciption   variable   Format(itemWeight, 9)   variable   "Country/Region Code"   variable   "Lot No.";

Fields from the diItemLedgerEntry work fine. But GTIN, Description and Gross Weight from Item are not showing up.

This is my report extension.

I understand the variables added at end are probably not correct. I was just testing many different things

reportextension 50202 "AM Item Barcode Label" extends "WHI Item Barcode Label"
{
    RDLCLayout = 'AM Item Barcode Label.rdlc';

    dataset
    {

        addfirst(diItemLedgerEntry)
        {
            dataitem(Item; Item)
            {
                DataItemLink = "No." = field("Item No.");
                DataItemTableView = sorting("No.");
                column(GTIN; GTIN) { }
                column(Gross_Weight; "Gross Weight") { }
                column(Description; Description) { }

                trigger OnPreDataItem()
                begin
                    itemGTIN := GTIN;
                    itemWeight := "Gross Weight";
                    itemDesciption := GTIN;
                end;
            }
        }

        add(diItemLedgerEntry)
        {
            column(barcodeImage; Barcode.Image)
            {
            }
            column(barcodeText; barcodeText)
            {
            }

        }

        modify(diItemLedgerEntry)
        {

            trigger OnAfterAfterGetRecord()
            var
                BarcodeGeneration: Codeunit "IWX Library - Barcode Gen";
                variable: Text;
            begin
                variable[1] := 10;
                barcodeText := itemGTIN   variable   itemDesciption   variable   Format(itemWeight, 9)   variable   "Country/Region Code"   variable   "Lot No.";
                //Item.GTIN   variable   "Description"   variable   Format(Item."Gross Weight", 9)
                BarcodeGeneration.GenerateQRBarcode(Barcode, barcodeText, 220);
            end;
        }


    }

    var
        Barcode: Record "IWX Barcode" temporary;
        barcodeText: Text;
        itemGTIN: Text;
        itemWeight: Decimal;
        itemDesciption: Text;

}

Here is the report im extending from

report 23044900 "WHI Item Barcode Label"
{
  RDLCLayout = 'source/reports/WHI Item Barcode Label.rdlc';
  Caption = 'Warehouse Insight Item Barcode Label';

  dataset
  {
    dataitem(diItem; Item)
    {
      column(diItem_No_;'Code[20]')
      {
      }
    }
    dataitem(diItemLedgerEntry; "Item Ledger Entry")
    {
    }
    dataitem(diLabels; Integer)
    {
      dataitem(diNumCopies; Integer)
      {
        column(trecItems_No;'Code[20]')
        {
        }
        column(trecItems_Description;'Text')
        {
        }
        column(trecItems_Routing;'Code[50]')
        {
        }
        column(fldBarcode;'Blob')
        {
        }
        column(fldLotSerialBarcode;'Blob')
        {
        }
        column(diNumCopies_Number;'Integer')
        {
        }
        column(fldQuantity;'Decimal')
        {
        }
        column(fldUnitOfMeasure;'Code[10]')
        {
        }
        column(fldIncludeQty;'Boolean')
        {
        }
        column(fldExpiryDate;'Text')
        {
        }
      }
    }
  }
  requestpage
  {
    layout
    {
      area(content)
      {
        group(Options)
        {
          Caption = 'Options';

          field(fldNumCopies; iNumCopies)
          {
            Caption = 'Number of Copies';
          }
          field(fldIncludeQty; bIncludeQty)
          {
            Caption = 'Include Quantity';
          }
        }
      }
    }
  }
  var trecItems: Record Item temporary;
  recWHISetup: Record "WHI Setup";
  trecBarcode: Record "Company Information" temporary;
  trecLotSerialBarcode: Record "Company Information" temporary;
  cuWHICommon: codeunit "WHI Common Functions";
  cuSessionHelper: codeunit "WHI Session Helper";
  iNumCopies: Integer;
  iCount: Integer;
  bIncludeQty: Boolean;
  tcOnlyOneFilterErr: Label;
  dQuantity: Decimal;
  codUOM: Code[10];
  codTrackingNumber: Code[50];
  dtExpiryDate: Date;
  sExpiryDate: Text;
}

Community site session details

Cant get field references on reportExtension in vsCode

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates