Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) What query is used to ...

What query is used to populate lots/quantities for inventory adjustments?

(0) Share

Report

Posted on by Community Member

Can someone tell me the exact SQL query that is used to populate the list of lots and quantities presented when you are are entering an inventory adjustment OUT (i.e. a negative adjustment) of lot tracked items? I know the information is coming from IV00300 but I need to duplicate the exact ORDERING that is presented with an inventory adjustment.

Thanks in advance for any help!

*This post is locked for comments