Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Stock Usage
03-02-2018, 05:37 AM,
#1
Stock Usage
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
Reply
03-02-2018, 05:39 AM,
#2
RE: Stock Usage
Looks to be an error in the StockUsage.php script. I will have a look after the football Smile

Tim
Reply
03-02-2018, 08:18 AM,
#3
RE: Stock Usage
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
Reply
03-03-2018, 02:48 AM,
#4
RE: Stock Usage
How about Type 17 for Stock Issues?
https://www.linkedin.com/in/eclipsepaulbecker
Reply
03-06-2018, 07:54 PM,
#5
RE: Stock Usage
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
Reply
03-06-2018, 11:46 PM,
#6
RE: Stock Usage
Change committed to webERP-team and mine as well.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)