Share
ReportGood Morning All,
I have a client with a customization that creates specific Inventory Adjustments for Lot Controlled Items for the purpose of "consuming" a raw material lot and creating finished goods lots. Normally, this works fine. We've worked with the process and thought we had all the kinks worked out to avoid split lots. For these particular folks, split lots are a curse from the pits of hell.
Every now and then when the Inventory Adjustment is posted, GP splits one of the finished good lots - and the normal causes do not appear to be present.
So... this brings me to wanting a SQL script that would recombine the split lot in a manner that won't be giving GP any heartache once the lots are invoiced and posted. I will be dealing with the cost appropriately, and the final result will be confirming the extended cost is rounded to 2 places (their unit costs are to 4 places) -- but at the end what was already posted to the GL should still match what we end up with in Inventory.
Any help or input is much appreciated!
Jonathan
*This post is locked for comments
All responses (
Answers (
3