webERP Forum
Stock Usage - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: How To ? (/forumdisplay.php?fid=6)
+--- Thread: Stock Usage (/showthread.php?tid=8111)



Stock Usage - briantmg - 03-02-2018 05:37 AM

This may be a basic question.
When I issue tooling (drill bits, cutters, consumable tooling), to our shop, I use an Internal Stock Request. Which seems to be working fine.

However, it does not show up when I run the script StockUsage.php, (Inventory Item Usage). I was looking at the script and it seems to only look at Types 10 (Sales Invoice), 11 (Credit Note), 28 (Work Order Issue).
Is there a reason for this? If so, how would I look at tooling usage?

Thanks


RE: Stock Usage - falkoner - 03-02-2018 05:39 AM

Looks to be an error in the StockUsage.php script. I will have a look after the football Smile

Tim


RE: Stock Usage - falkoner - 03-02-2018 08:18 AM

You were correct in your diagnosis. The lines in the SQL statements that read:

SUM(CASE WHEN (stockmoves.type=10 Or stockmoves.type=11 OR stockmoves.type=28)

should be:

SUM(CASE WHEN (stockmoves.type=10 Or stockmoves.type=11 OR stockmoves.type=28 OR stockmoves.type=38)

and it should fix it.

Thanks
Tim


RE: Stock Usage - VortecCPI - 03-03-2018 02:48 AM

How about Type 17 for Stock Issues?


RE: Stock Usage - falkoner - 03-06-2018 07:54 PM

You are right Paul, 17 should be used as well. I have done the changes, anybody that wants can pull the changes from https://github.com/timschofield/webERP-svn.git to their own repository

Tim


RE: Stock Usage - TurboPT - 03-06-2018 11:46 PM

Change committed to webERP-team and mine as well.