Get and display serial number in report sales shipment

(0) Share

Report

Posted on by SebSeb

Hi,

I need to display serial numbers in report "sales shipment". I would like displayed serial numbers for each line :

line 1 ITEM44 Qty : 3
serial001
seriel003
serial002

line 2 ITEM55 Qty : 1
serial009

I have tried to base myself on report 208 (RetrieveDocumentItemTracking), but I did not succeed.

Please can you help me ?

*This post is locked for comments

All responses (5)

Answers (1)

Salba Z.K 127 on at

Like (0)

Report

RE: Get and display serial number in report sales shipment

hey can you show how you have done this i want same thing
SebSeb 30 on at

Like (0)

Report

RE: Get and display serial number in report sales shipment

Hi Stevdeb,

I have solved!

I have done what you say for Sales Shipment line in the Code and I have used filter in the layout.

It's beautiful!

Thanks for the help.
stevdeb 650 on at

Like (0)

Report

RE: Get and display serial number in report sales shipment

Hi,

You need to create a new indented DataItem (Integer) under Sales Shipment Line that loops through the TrackingSpecBuffer temporary record. This temporary record contains the serial numbers

Regards
SebSeb 30 on at

Like (0)

Report

RE: Get and display serial number in report sales shipment

Hi stevdeb,

Where I do this? in the layout?

My problem is : How I insert the field "TrackingSpecBufferSerNo" in the line shipment table?

Regards
Verified answer

stevdeb 650 on at

Like (0)

Report

RE: Get and display serial number in report sales shipment

Hi,

Isn't the easiest way to use the item ledger entries and filter on

Type = Sale

Document No. (=shipment no)

Document Line No. (=shipment line no)

Regards