Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Stock On Hand By Date - Zero Quantity?
04-11-2018, 05:08 AM
Post: #1
Stock On Hand By Date - Zero Quantity?
StockQuantityByDate.php

Historical Stock Quantity By Location/Category

This report shows items with a quantity on hand value of zero. I am not too sure if that is as designed so I added "AND newqoh > 0" to the SQL query to skip them.

We only want to see stock that actually exists in the warehouse.

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
04-11-2018, 05:18 AM
Post: #2
RE: Stock On Hand By Date - Zero Quantity?
Sometimes knowing what stock is at zero is also important so I think I would rather this was an option in the report criteria.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
04-11-2018, 05:34 AM
Post: #3
RE: Stock On Hand By Date - Zero Quantity?
Tim... I agree and think having a checkbox would be a very nice touch.

I also added a "Controlled" header to my report. File attached...


Attached File(s)
.php  StockQuantityByDate.php (Size: 6.15 KB / Downloads: 2)

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
04-11-2018, 07:36 AM (This post was last modified: 04-11-2018 07:58 AM by falkoner.)
Post: #4
RE: Stock On Hand By Date - Zero Quantity?
Hi Paul, I have committed these changes and pushed them to github.

I changed the Yes and No on the $Controlled variable to be gettext compatible _'(Yes') and _('No')

I also ran it through my code formatting scripts, but these problems were not of your doing, they were already present Smile

Tim
Somehow I seem to have messed this up, must be tired, I will correct in the morning.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
04-11-2018, 09:42 AM
Post: #5
RE: Stock On Hand By Date - Zero Quantity?
Tim... Thank you for keeping an eye on my work!

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
04-11-2018, 06:24 PM
Post: #6
RE: Stock On Hand By Date - Zero Quantity?
Ok, I have redone this commit and it all seems to work ok now, so I have pushed it to github.

This can be pulled into other repos as desired.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
04-12-2018, 10:06 AM
Post: #7
RE: Stock On Hand By Date - Zero Quantity?
Pulled to the other two repo's.
Find all posts by this user
Quote this message in a reply
04-22-2018, 09:26 PM
Post: #8
RE: Stock On Hand By Date - Zero Quantity?
Now this script is showing QoH greater than zero for items with QoH equal to zero.

I replaced my script with the original 4.14.1 script and the issue persists.

I will look into it tomorrow...

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
04-22-2018, 11:30 PM
Post: #9
RE: Stock On Hand By Date - Zero Quantity?
Hi Paul,

There should be two options. One produces a report of all stock items, and the other produces a report of only those items with a stock quantity on hand. Looking at my installation that appears to be what is happening. Is this what you see?

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
04-24-2018, 04:56 AM (This post was last modified: 04-24-2018 05:15 AM by VortecCPI.)
Post: #10
RE: Stock On Hand By Date - Zero Quantity?
The issue occurs with the new script as well...

Never mind... The date was set prior to today...

That is VERY annoying so I am changing the default date to TODAY...

New script option to show zero stocks produces odd results for my data.

I attached my working hacked script from 4.14.1 for reference...


Attached File(s)
.php  StockQuantityByDate.php (Size: 6.24 KB / Downloads: 0)

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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