web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to check which bat...

Microsoft Dynamics AX (Archived)

How to check which batches were actually picked in an INVOICED Sales Order

(0) Share

Report

Report

Posted on by Abdo Khoury

14,855

Dear

how can i check in an invoiced sales order , which Batches were actually picked?

thanks

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Brandon Wiese 17,790 on at

Like (0)

Report
Copy link

Link copied!

Since sales orders contain multiple sales order lines potentially for different items (and Batch is specific to each item), you'll have to iterate through each sales order line.

For each sales order line, consider all InventTrans records for that InventTransId with StatusIssue == StatusIssue::Sold (and StatusReceipt == StatusReceipt::None), and join InventDim according to its standard relation. InventBatchId is found on InventDim.

You can, of course, have multiple combinations of ItemId and InventBatchId for an invoiced sales order line.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 16

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans