webERP Forum
Stock On Hand By Date - Zero Quantity? - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (/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 05:08 AM

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? - falkoner - 04-11-2018 05:18 AM

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 05:34 AM

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? - falkoner - 04-11-2018 07:36 AM

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


RE: Stock On Hand By Date - Zero Quantity? - VortecCPI - 04-11-2018 09:42 AM

Tim... Thank you for keeping an eye on my work!


RE: Stock On Hand By Date - Zero Quantity? - falkoner - 04-11-2018 06:24 PM

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 10:06 AM

Pulled to the other two repo's.


RE: Stock On Hand By Date - Zero Quantity? - VortecCPI - 04-22-2018 09:26 PM

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? - falkoner - 04-22-2018 11:30 PM

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 04:56 AM

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...