Announcements
Good day,
A receipt was done for an item, which according to the system posted though. I am unable to invoice the item because it is saying 'qty allocated'. I am unable to view where it is allocated. I have run check links and reconcile but the scenario was not fixed. We use Field Service but the receipt was not done via In Transit.
I have run the scripts to view allocation as per module, didn't come up with any results.
The only other solution, I am thinking, is an update statement, but I am unsure what I am changing, am I just updating the allocated quantity per site to '0'
Regards
Rosemary
Thanks, maybe you can post the link.
Regards
Hi Rosemary!
I remember reading a support document from Microsoft the order you should run reconcile when something is not right.
When I have to run reconcile about some data not being correct -- especially with inventory numbers or something like it, this is what I always do:
First run reconcile on sales, then on purchasing, then finally inventory. They all touch inventory numbers, so better safe than sorry.
Joe
Thank you Richard for mentioning the SOP table, it appears the allocation was due to the invoice. I had initially only did the reconcile on Purchasing and Inventory. But when I did the Sales, it pulled the invoice number and cleared the allocated quantity.
Regards
Rosemary
No problem, don't envy you guys.
Sorry for the typo. We are in the middle of an ice storm and it is 12 degrees.
The allocated quantity is in IV00102. That is what the Quantity/Site screen will display. Running IV reconcile should fix this if there are no lines allocated in the sales order work tables.
Thank you Richard for your response, but I am not seeing that field in IV00101. The Item number is there though in that table. Via item inquiry the item number is there 1 'on hand', 1 'allocated'.
Regards
Rosemary
It is most likely referring to IV00101.ATYALLOC having a value with no matching line in SOP10200. Pull up the item in GP and go to quantity/item. You will most like see a qty there.
You can run item reconcile under GP Inventory Utilities to correct this.
Good day,
I ran an Item Reconcile from PSTL and received this message relative to the item number,
'IV00102 has allocations with no matching detail', how do I work around this?
What 'detail' is it referring to?
Regards
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156