Adding lot number field to custom sales invoice business form

(0) Share

Report

Posted on by Michael Scalamogna

135

Hi all, I've created a custom report for a customer that I will be using in place of the standard sales invoice business form in Dynamics 365 BC. We decided to take this route because the standard form did not contain some of the fields we needed to appear.

Everything seems to be working fine, but I just can't figure out how to get the lot number from where the shipment came to appear on the document. Does anyone have any ideas on how to do this? I suspect it can be done by linking the item ledger entries table to the sales invoice line table but for some reason it is not working for me.

Thanks,

Mike

Categories:

Inventory management

Customization

Reports and Business Intelligence