Dynamics 365 CommunityForums Finance forum Business Document cust...

Answered

Business Document customization - Sales order packing slip line with Batch number

(2) Share

Report

Report

Posted on by Community member

40

Hi people,

I want to add the batch number from the sales order packing slip on the business document.

However the report always prints the batch number from the first position in the sales order.

I mapped the batch number from:

$SalesPackingSlipLines/>Relations/CustPackingSlipJour/<Relations/CustPackingSlipTrans.CustPckSlpJour/inventDim()/inventBatchId

Two positions in this example with different batch numbers

On the report I get for the two positions the same batch number.

In the report I have configured a repeating section content control for the lines.

Any idea why the report prints only one batch number?

Thanks,

Pasqual

Categories:

Administration and Setup

Development / Customization / SDK

Attachments

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Community member 40 on at

Like (0)

Report

Business Document customization - Sales order packing slip line with Batch number

Hi Kevin,

thanks for your reply. The reason was indeed the wrong mapping in the related table. So correct mapping lead to the correct result:

$SalesPackingSlipLines/>Relations/CustPackingSlipTrans/>Relations/InventDim/inventBatchId

Thanks again!

Best regards,

Pasqual
Kevin Xia Microsoft Employee on at

Like (0)

Report

Business Document customization - Sales order packing slip line with Batch number

Hi,

You need to make sure that you are correctly referencing the data source of the batch number field in the repeating part content control. Check that the logic of retrieving the batch number fields from the related table is correct. Or you can check the loop logic of your control by repeating parts of the content. Make sure it displays the batch number of the shipping line for each sales order.

Best regards,

Kevin

Helpful resources

Quick Links

Leaderboard

Andre Arnaud de Cal... 283,183 Super User

Martin Dráb 222,733 Super User

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans