Small and medium business | Business Central, N...

Adding Serial Numbers to Sales Invoice/Credit Memo Report Layouts (RDLC)

(0) Share

Report

Posted on by AI123456789

129

Does anyone know of any way to add in Serial Numbers, linked from the Item Tracking Entries into a Sales Invoice or Sales Credit Memo document layout using RDLC? I'm using report 1306.

I know I need to extend the report and link from the Sales Invoice to the Item Ledger Entries table but am not certain on how to set up the DataItemLink.

Then once this is set up, does anyone know how I'd best set up the grouping in RDLC (e.g. to include all serial numbers under the description for the item).

All help appreciated!

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (0)

Suggested answer

MahGah 15,428 on at

Like (0)

Report

RE: Adding Serial Numbers to Sales Invoice/Credit Memo Report Layouts (RDLC)

Hi

Thank you for posting this here. it will help for future questions.
AI123456789 129 on at

Like (0)

Report

RE: Adding Serial Numbers to Sales Invoice/Credit Memo Report Layouts (RDLC)

For anybody that stumbles across this post looking for an answer, I've solved the issue and it's actually relatively simple.

For some reason there's minimal resource online about how to do this but basically you need to link a data item from the lines to the Value Entry table which has "Item Ledger Entry No." and "Document No." (table 5802), then inside this data item, link to the Item Ledger Entry table.

Here's my code for extending the Sales Invoice (1306) and Credit Memo (1307) reports:

reportextension 50101 "SalesInvoiceExt" extends "Standard Sales - Invoice"

{

dataset

{

addlast(Line)

{

dataitem("Value Entry"; "Value Entry")

{

DataItemLink = "Document No." = field("Document No."), "Item No." = field("No.");

DataItemLinkReference = Line;

column(Item_Ledger_Entry_No_; "Item Ledger Entry No.")

{

}

dataitem("Item Ledger Entry"; "Item Ledger Entry")

{

DataItemLink = "Entry No." = field("Item Ledger Entry No.");

DataItemLinkReference = "Value Entry";

column(Serial_No_; "Serial No.")

{

}

}

}

}

}

}

___________________________________________________

reportextension 50103 CreditMemoExt extends "Standard Sales - Credit Memo"

{

dataset

{

addlast(Line)

{

dataitem("Value Entry"; "Value Entry")

{

DataItemLink = "Document No." = field("Document No."), "Item No." = field("No.");

DataItemLinkReference = Line;

column(Item_Ledger_Entry_No_; "Item Ledger Entry No.")

{

}

dataitem("Item Ledger Entry"; "Item Ledger Entry")

{

DataItemLink = "Entry No." = field("Item Ledger Entry No.");

DataItemLinkReference = "Value Entry";

column(Serial_No_; "Serial No.")

{

}

}

}

}

}

}

__________

I hope someone finds this beneficial!
MahGah 15,428 on at

Like (0)

Report

RE: Adding Serial Numbers to Sales Invoice/Credit Memo Report Layouts (RDLC)

it could be because it is old post and mainly mean for providing example.

As Josh mentioned look into report 208

or see what has changed between C/AL and AL then see if you can tweak the code.

I could not find any other example.
AI123456789 129 on at

Like (0)

Report

RE: Adding Serial Numbers to Sales Invoice/Credit Memo Report Layouts (RDLC)

This code does not work in Business Central, is this C/AL?
MahGah 15,428 on at

Like (0)

Report

RE: Adding Serial Numbers to Sales Invoice/Credit Memo Report Layouts (RDLC)

Hi

Please see this post

community.dynamics.com/.../how-to-modify-the-sales-invoice-report-to-print-serial-no-lot-no
JAngle 33,159 on at

Like (2)

Report

RE: Adding Serial Numbers to Sales Invoice/Credit Memo Report Layouts (RDLC)

Use report 208 as a guide. It already has the feature you require.