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

How can we export all the pick lines for all the transfer order at a time in business central?

(7) Share

Report

Posted on by Satya2277

114

User has requirements that they want to export all the pick lines for all the transfer orders at a time how can we do that in business central?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Teagen Boll 1,436 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

You will want to use the pick worksheet to create your picks. From the pick worksheet you can grab many shipments at a time and perform a batch picking process.

There is more info here: How to Plan Picks in Worksheets - Business Central | Microsoft Learn

In summary the steps are:

1. Create your Transfer Orders

2. Create your Warehouse Shipments

3. Open the Pick Worksheet page

4. Select "Get Warehouse Documents"

5. Plan the picks you would like to perform

6. Create Picks

Make sure your inventory location is setup to have picks enabled. Note that this same process can also be replicated for put-aways but using the put-away worksheet.

Was this reply helpful? Yes No
Satya2277 114 on at

Like (0)

Report
Copy link

Link copied!

I have created the transfer order and then create the shipment and then pick lines. Now i want to export all the pick lines according to the all transfer order at a time... How can i do that?

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,208 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

If you're referring to exporting all the pick lines to an excel file, you can use configuration packages. In the configuration package add Table 5767 Warehouse Activity Line and filter on Source Document = Outbound Transfer. This will give you all the pick lines in an excel file.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Teagen Boll 1,436 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

There are a few ways to "export" lines.

1. Use a configuration package like Valentin mentioned. This is good if you want to export all lines from all warehouse picks but is a bit more advanced.

2. You can also just print the warehouse pick by selecting Home > Print... from the pick itself

3. Lastly, open the Pick lines in excel with the open in excel function:

If you're still unsure about the best way to manage that process it's usually best to work with your partner to determine an approach to managing your pick processes.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,959 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Configuration Worksheet you can use to export the data directly from the table.

If you wish to complete the operation for multiple document then use Pick Worksheet.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

Dynamics 365 Business Central: Viewing table data (Six ways)

https://yzhums.com/61330/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,965 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Just go to Warehouse Picks (or Warehouse Activity Lines), filter Source Document = Transfer Order, then use Edit in Excel to export all pick lines at once; this pulls every created pick line for transfer orders in one file. If you need automation, expose Warehouse Activity Line via OData/API and apply the same filter to retrieve all lines programmatically.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,898 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

After following the steps to create picks, you can print them all using Picking list report.

You can run it from Pick document or Report layout. Make sure you apply following filter and remove other filter to print all the picks generated from Transfer order.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards,

Dhiren.

LinkedIn - https://www.linkedin.com/in/ca-dhiren-nagar-5079081b2/

Blog - https://dhirennagar.blogspot.com/

Was this reply helpful? Yes No