Hi,
I'm on GP 9.0 and want to know how to set all allocations to zero. I thought it was under "utilities" but I'm not sure. Do you know of a SQL script that will do this?
thanks.
*This post is locked for comments
Are you talking about the Qty Allocated field? As I understand it, the qty allocated comes from Quantities on Sales orders, so to set the number to zero, you would want to not have any on sales order. This also depends on your allocation method, depending on if you are allocating by line item or you do the allocation routine before you post the batch. If you don't have a particulat item on order and it is still showing up as allocated, you might want to run check links. This would be under Dynamics GP Button (version 10) - Maintenence - Checklinks. Then select Inventory and you might want to select all of the inventory ones. I can't remember which one would be the allocation, but this fixed the problem that I am describing above when it happened to me.
Thanks for the info but I think I'm looking for a SQL script that would set all allocated items to zero. Then I need to make a bunch of inventory adjustments and run the reconcile process to set all of the allocations back. I also need to know if someone out there knows how this would work with serialized items.
Susan,
First of all, which modules are you using? Allocations can come from Sales Orders, Service Orders, Projects in Project Accounting, Returns to Vendor in Returns Management, etc.
Secondly, why do you need to set the allocations to zero? Is it because the allocations are preventing you from making the inventory adjustments?
We are using manufacturing and SOP. No project accounting or service orders.
After conducting a physical inventory we need to make multiple adjustments, we are doing this manually not using cycle counts.
Yes, the allocations are preventing me from adjusting qtys. If I need to decrease the quantity in one site (to increase it in another) where allocations have reduced the availabe qty it causes complications. I've heard that clearing the allocations prior to making the adjustments is a good way to take care of that. Then the theory is that you reconcile inventory after the adjustments are made to re-allocate, but I don't know how that works with serialized items.
Thanks for any suggestions you can give. I do plan to try this out on the test company first.
Hi. Did you get this to work? I would think that you could just update the IV00102 table for all items and set the ATYALLOC value to 0, then enter the adjustment transactions, then run reconcile. Just a thought.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
