Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Stock On Hand By Date - Zero Quantity?
04-11-2018, 05:08 AM,
#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
Reply
04-11-2018, 05:18 AM,
#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
Reply
04-11-2018, 05:34 AM,
#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 Files
.php   StockQuantityByDate.php (Size: 6.15 KB / Downloads: 2)
https://www.linkedin.com/in/eclipsepaulbecker
Reply
04-11-2018, 07:36 AM, (This post was last modified: 04-11-2018, 07:58 AM by TimSchofield.)
#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
Reply
04-11-2018, 09:42 AM,
#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
Reply
04-11-2018, 06:24 PM,
#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
Reply
04-12-2018, 10:06 AM,
#7
RE: Stock On Hand By Date - Zero Quantity?
Pulled to the other two repo's.
Reply
04-22-2018, 09:26 PM,
#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
Reply
04-22-2018, 11:30 PM,
#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
Reply
04-24-2018, 04:56 AM, (This post was last modified: 04-24-2018, 05:15 AM by VortecCPI.)
#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 Files
.php   StockQuantityByDate.php (Size: 6.24 KB / Downloads: 0)
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)