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

Receive Posts by Email

Subscribe and receive notifications of new posts by email.