XML generation of invoice, XML output is missing part # though its visible in the normal PDF printout

Epicor ERP 10
1

Currently I am trying to address an issue in which an end user reported an issue with a custom SSRS report an Epicor consultant created for us.

Issue:

  1. User navigates to invoice tracker
  2. User searches for invoice
  3. User selects actions>>print
  4. User selects custom SSRS style
  5. User selects print preview with a form of XML output
  6. Custom XML generated does not contain Part # though if reprinted as PDF and not XML part # displays correctly.

Question:

  • How is the XML’s output determined is it controlled by a data definition just for the XML?

Information Gathered:

Report Data Definition = “MN_ARForm”

-Tables “InvcDtl, PartLot” in definition that have part_num, do not have the column excluded

Report Styles: “Standard - SSRS, Standard MX - SSRS”

XML Output:

  • With standard style selected and print preview of XML I received the two fields in the result set:

TxtPartNum=“233D2590G003”

TxtPartDescription="IML & BACKSPLASH ASM

-With the Standard MX style in the result set I only see the part number in "<Details Textbox15=“233D2590G009/9100002340”