+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Stock On Hand By Date - Zero Quantity? (/showthread.php?tid=8149)
Pages:
1
2
Stock On Hand By Date - Zero Quantity? - VortecCPI - 04-11-2018
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.
RE: Stock On Hand By Date - Zero Quantity? - TimSchofield - 04-11-2018
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
RE: Stock On Hand By Date - Zero Quantity? - VortecCPI - 04-11-2018
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...
RE: Stock On Hand By Date - Zero Quantity? - TimSchofield - 04-11-2018
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
Tim
Somehow I seem to have messed this up, must be tired, I will correct in the morning.
Tim
RE: Stock On Hand By Date - Zero Quantity? - VortecCPI - 04-11-2018
Tim... Thank you for keeping an eye on my work!
RE: Stock On Hand By Date - Zero Quantity? - TimSchofield - 04-11-2018
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
RE: Stock On Hand By Date - Zero Quantity? - TurboPT - 04-12-2018
Pulled to the other two repo's.
RE: Stock On Hand By Date - Zero Quantity? - VortecCPI - 04-22-2018
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...
RE: Stock On Hand By Date - Zero Quantity? - TimSchofield - 04-22-2018
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
RE: Stock On Hand By Date - Zero Quantity? - VortecCPI - 04-24-2018
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...