SQL View – Inventory Transactions with Lots and Reason Codes

By - April 18, 2018

Standard Dynamics GP Inventory Transaction reports and SmartLists do not include Lots or Reason Codes, but there are times that these would be helpful additions. To start, use SmartList Designer to create a SmartList using the view.

Restrict the Lot Number beginning with “RECONCILE:” because those are transactions that were created to back out those Lot Numbers that had been created when running the IV Reconcile Utility. You can find more on how to do this here.

As is always best practice, be sure to have a RESTORABLE backup in case something undesirable occurs and try this on a test server or test company first. Please use this view with caution.

To learn more about how you can take advantage of this and other Dynamics GP features, visit RSM’s Microsoft Dynamics GP resource. To make sure you stay up to date with the Microsoft Dynamics Community, subscribe to our Microsoft Dynamics Community Newsletter. For more information on Microsoft Dynamics 365, contact us.

By: Danielle Capozzi

RSM empowers middle market companies worldwide to take charge of change. Our unique middle market perspective makes RSM the natural choice for growth-oriented, internationally active organizations seeking relevant insights and tailored, innovative solutions for a complex and changing world. With a global reach spanning more than 120 countries, we instill confidence in a world of change by bringing the full power of RSM to make a lasting impact on our clients, colleagues and communities.

Contact our team to learn more!

Receive Posts by Email

Subscribe and stay aware of new posts by email.

Please Select Your Interests