Item allocation issue

(0) Share

Report

Posted on by Community Member

Hello,

We are seeing an item quantity allocation discrepancy in GP and can't seem to resolve. For example, if I go to Inquiry>Inventory>>Item and look at an item. I can see that there is a quantity of "8" in the Allocated field. if I clicked on the linke for Allocated, it brings me to the Item allocation window but there are no transactions for that item. I do a have a few open sales order in the work table for that item, but they are not allocated nor invoiced.

I ran Inventory reconcile a few times but it cannot resolve.

Please advise.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Did you run Reconcile with everyone is out? It's coincidence that we just did the same today. Make sure the Options include Item in History is checked.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes, I did run this while everyone was logged out and included Item in History.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you go in to SQL and look at the SOP10200 table do you perhaps see an orphaned record for this item? If so, try running check links on the Sales Work tables.

You could also try Inquiry->Sales->Sales Line Items inside GP.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,633 Moderator on at

Like (1)

Report
Copy link

Link copied!

Also, if you use Field Service or Project Accounting, allocations that originate in those modules do not appear in the Item Allocation window because there is no link back to the documents in those modules.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

We had this same problem. We discovered an order that was in both the SOP10100 and SOP10200 tables, but that order could not be opened using the Sales Transaction Enrty Screen (it did not appear as a choice in the lookup). When we did a Sales Document Inquiry, the order appeared, but all of the header info was blank (customer number, name, etc.).

Any idea on what causes these orphaned orders?

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (1)

Report
Copy link

Link copied!

Unfortunately orphaned records in the SOP1020 are not that uncommon. Do you users ever report their computers locking up? Hopefully there are only a handful of these. Now you can try copying your data to a test company and then using SQL delete these orphaned records, run check links on the sales series and then inventory reconcile to see if it corrects the item quantities. If so, repeat the process in the production company.

Was this reply helpful? Yes No
Syed Hasan 55 on at

Like (0)

Report
Copy link

Link copied!

HI there, reviewed, if its not posted and only on Sales order level,

Step 1= take a backup of database

Step2 = Review the sales SOP tables, its mostly effect four tables, 1) SOP10100 2) SOP10101 3) SOP10200 and 4) SOP1010, Review the items by using select table and where clause using sopnumber.

Step3 = After confirmation, delete those order number rows.

Step 4 = Reivew in inquiry sales document with sales oder number.

its should work.

Irfan

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

My issue with the allocated items is rejects. When I upload our manufacture order, I need to enter dozens produced and quantity rejected. The rejects are what is going to the allocated quantity. I was looking on here to try to figure out how to get rid of the allocation quantity.

Was this reply helpful? Yes No
Suggested answer

adeel333 487 on at

Like (0)

Report
Copy link

Link copied!

Thank you. It resolved my issue.

I simply run check links on Sales Work (only)

then I reconciled the item (single item at one time)

and issue was resolved :)

Was this reply helpful? Yes No