Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Stock Usage
03-02-2018, 05:37 AM
Post: #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
Find all posts by this user
Quote this message in a reply
03-02-2018, 05:39 AM
Post: #2
RE: Stock Usage
Looks to be an error in the StockUsage.php script. I will have a look after the football Smile

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
03-02-2018, 08:18 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
03-03-2018, 02:48 AM
Post: #4
RE: Stock Usage
How about Type 17 for Stock Issues?

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
03-06-2018, 07:54 PM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
03-06-2018, 11:46 PM
Post: #6
RE: Stock Usage
Change committed to webERP-team and mine as well.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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