You’re offline. This is a read only version of the page.
100
We have just gone through our first full year-end closing with GP10.0. We ran a full cycle count of the inventoy, but now we are coming up with negative inventory and negative allocations to lot-tracked inventory.
Would anyone have had a similar experience and know haw to fix it?
Thanks
*This post is locked for comments
Sorry, but Updating IV00102 is a waste of time. The first thing an inventory reconcile does is ZERO out ATYALLOC in this table. It's final computed value is subsequently placed here. In my case the number is significantly negative, and we do not use the part in question in MOs, nor are they part of a BOM.
it is best to try inventory reconcile tools first , go to support.microsoft.com/.../850365 for a guide. another answer I found was to update the inventory quantity master table. I would suggest trying it on only one item at first,if you see no issues then try it on the rest.
There is some SQL involved in this soultion , backup your database before attempting
first log into your GP data base and run this Query
SELECT [ITEMNMBR]
,[LOCNCODE]
,[BINNMBR]
,[RCRDTYPE]
,[BGNGQTY]
,[QTYRQSTN]
,[QTYONORD]
,[QTYINUSE]
,[QTYINSVC]
,[QTYRTRND]
,[QTYDMGED]
,[QTYONHND]
,[ATYALLOC]
,[QTYCOMTD]
,[QTYSOLD]
,[FXDORDRQTY]
,[ORDRPNTQTY]
,[DEX_ROW_ID]
FROM [dbo].[IV00102]
where[ATYALLOC] like '-%'
this will give you a list of all the items with negative allocation
then go into GP > inquiry > inventory> Item allocation .
in items put in the item number that you want to fix , one at a time, to get the correct allocation information.
go back to GP database and run this select statement
SELECT [ITEMNMBR]
,[LOCNCODE]
,[BINNMBR]
,[RCRDTYPE]
,[BGNGQTY]
,[QTYRQSTN]
,[QTYONORD]
,[QTYINUSE]
,[QTYINSVC]
,[QTYRTRND]
,[QTYDMGED]
,[QTYONHND]
,[ATYALLOC]
,[QTYCOMTD]
,[QTYSOLD]
,[FXDORDRQTY]
,[ORDRPNTQTY]
,[DEX_ROW_ID]
FROM [dbo].[IV00102]
where [ITEMNMBR] = 'fas11515'
this will show you which locations need to be changed
then run a update for any site that needs to be corrected , I have only ever updated sites or Rcrdtype 2 , I have never tried to update the overall record , or rcrdtype 1.
UPDATE [dbo].[IV00102]
set ATYALLOC = 'correct allocation'
where LOCNCODE = '**' and ITEMNMBR = '*****'
people more talented than me with SQL could probably create a single solid script for this.
this stil happens in 2013 R2...so 11 years now...and no answers?
At this point, the only way to clear these negative allocations is to regularly run reconcile. I have been observing this issue for 6 years now.
Cherie,
Did you ever notice any duplication in inventory transactions i.e you entered and posted a transaction involving quantity 10 and after posting you find it to be 20 ( two lines having 10 each) ??
That's an excellent question. I'm not familiar enough with MFG to tell you where/how to unallocate items from MOs but if it were me, I'd be looking for those MOs that have allocations against them that shouldn't and then remove the allocations.
Then, I'd run reconcile on inventory again to see if that corrects the negatives.
So the question remains ---
How do we clean up these allocations from MOs that were not closed properly? We run a JIT manufacturing process, and having these inventory problems really mess up both getting our manufacturing through the system and our inventory valuation.
I would be willing to bet there were allocations to MOs in inventory when you ran the Inventory Reconcile. Because there is no equivalent 'Reconcile' in Manufacturing, when MOs are closed that had allocations on them, this is driving the allocations for those items negative in Inventory.
Just a semi-educated guess based on things I've seen in the Field Service module with allocations to service calls . . .
Actually, we reconciled our inventory and this is when the problem showed up.
Before we were having problems with allocations becuase our inventory is lot tracked and has a best buy date, but the system was--in every case-- allocating by first in first out. So for a while we had lots in the system which were not in physical inventory. After the reconciliation, these allocations turned negative. We can't figure out how to get them out of the system, becuase they do not show up except when we are building manufacturing orders.
negative inventory - maybe you allow override quantity
negative allocation - this can be fixed by performing utilities inventory reconcile.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (