Inventory Reconcile Insists on Adding Quantity

(0) Share

Report

Posted on by Tim Foster

8,515

A receipt for quantity 32 of a particular Item was processed. My user tells me something strange happened during the process. They returned 32. There were zero on hand. Then I reconciled Inventory. GP is adding 32 more to the receipt. Which leaves an erroneous 32 on hand.

I have checked the receipt and return and everything matches. I have checked Inventory Transaction and they look correct. I have scoured every SQL table that contains relevant data. I traced (in SQL Profiler) the Inventory Reconcile process but because the scripts are encrypted, I can't see anything.

Does anyone have any ideas about how to fix this? I have run out.

Thanks

Tim

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Inventory Reconcile Insists on Adding Quantity

I will suggest that you take a look either at the receipt or the return posting, and pay special attention to the sequence numbers, sometimes by "magic" dual postings occur, you can easily spot because sequences have a tendency of being multiples of 16384 if for some reason you have like a 16385 then that is the invalid record driving your mismatch.

Have a great day
Richard Wheeler 75,756 on at

Like (0)

Report

Re: Inventory Reconcile Insists on Adding Quantity

I actually meant to say Purchase Receipts Report which uses the purchase receipts table.

Reports->Inventory->Activity->Purchase Receipts
Richard Wheeler 75,756 on at

Like (0)

Report

Re: Inventory Reconcile Insists on Adding Quantity

What does your purchase receipts file show for this item? Does it also show 32 on hand? The IV10200 is the table for purchase receipts.