web

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

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Need to print batch nu...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Need to print batch numbers based on item number

(0) Share

Report

Report

Posted on by prasadn.nampalli@gm...

45

If I want to print multiple batch numbers based on an item number in report ...how we can solve this,please suggest me...

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mehdi AMRANI 1,422 on at

Like (2)

Report

Hi,

In you request, call the batch number table filtred by the items you want and grouped by ItemID.

Example :

select * from INVENTBATCH ib inner join INVENTTABLE it on ib.ITEMID = it.ITEMID

Where it.itemid in ("A0001","1000")

Group by it.ITEMID

Regards,

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Abhilash Warrier 669 Super User 2025 Season 2

#2

André Arnaud de Cal... 449 Super User 2025 Season 2

#3

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans