Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Inventory item shows demand which are not
05-27-2019, 08:37 PM
Post: #1
Inventory item shows demand which are not
I have an inventory item that shows a demand of 40 and keep on popping up in the MRP shortages.

I can not find this demand, ran the following scripts from the inventory item inquiries and all come up with nothing outstanding.
Code:
Search Outstanding Sales Orders
Search Completed Sales Orders
Search Outstanding Purchase Orders
Search All Purchase Orders
Where This Item Is Used

Any idea how I can reset the demand to 0.

Regards
Find all posts by this user
Quote this message in a reply
05-27-2019, 08:44 PM
Post: #2
RE: Inventory item shows demand which are not
Alan, you should have a field in the mrprequirements table called mrpdemandtype. Can you look in there and see what it says for that item?

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
05-27-2019, 09:44 PM
Post: #3
RE: Inventory item shows demand which are not
Thanks Tim, fixed.
I got a WO number from there, had a look at the WO and BOM which where still open and BOM does not use the item.

However on costing there were a issued line of 60 for the item, so probably some finger trouble earlier. I closed the WO and the 40 disappeared. Just recreated it and no problem.

Thanks again, helps if you know where to look.Smile

Regards
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)