Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PO Receive doubles qty on hand in item master

Status
Not open for further replies.

benksb

MIS
Jun 29, 2006
3
US
Randomly, when we receive an item on a purchase order the quantity on hand in our item master is increased by twice the amount received on the po line. Has anyone seen this behavior or have a solution?
 
You need to write a Crystal Report based on the IM5 and pull the records for this item and the date it was posted to see what the transaction detail is. I have seen this when there was an error message and they tried to post twice and it hit the files twice.
 
Crystal Report to IM5 sounds painful, assuming you have the transaction load I do. Would you get a result different than what you get on inventory transaction inquiry?

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
 
If all you are pulling is from IM5 it should not be bad.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top