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

Report layout - working with Lot and expiry

(0) Share

Report

Posted on by Jakob123

Hi,

How is it possible to add lot number and expiry date for each line on sales invoices etc. (template and direct working document), without having to manually update the extended text?

Jakob

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Jakob123 10 on at

Like (0)

Report

RE: Report layout - working with Lot and expiry

Hi Armit, thanks.

I am assuming this needs to be done in VSC? do I need to edit this in the RDCL layout or where do I need to apply above?

Item tracking has been assigned (only LOT, no serialization needed for our setup at least). Will above result in new itemdata when you modify in word?

Thanks

BR

Jakob
Suggested answer

Amit Baru 3,025 on at

Like (0)

Report

RE: Report layout - working with Lot and expiry

Hi,

Pls do the following steps

First Assign Item Tracking.

Write code on SalesLine Dataitem OnAfterrecord

Reservation.reset

Reservation.setrange("Source ID","Document No.");

Reservation.setrange((Source Reference Line No.,"Line No.");

if Reservation.findset then begin

repeat

LOTNO := Reservation."Lot No.";

ExpirayDate := Reservation."Expiry Date"

until Reservation.next =0;

end;

This helpful

Regards

Amit Sharma

www.erpconsultors.com
Jakob123 10 on at

Like (0)

Report

RE: Report layout - working with Lot and expiry

Hi Amit, thanks for your reply.

Did not manage to resolve challenge based on above, do I need to configure the report and add lot and expiry to the XML mapping for modifying report template in word or is there a more simple way?

BR

Jakob
Suggested answer

Amit Baru 3,025 on at

Like (0)

Report

RE: Report layout - working with Lot and expiry

Hi,

Yes, system allow to print Lot and Expiry Sales Line wise in Report. If you want to know the above information then go to the Item Tracking button and see the information.

Regards

Amit Sharma

www.erpconsultors.com

https://linkedin.com/in/amit-sharma-94542440

Press Yes If Info is useful.