I'm running a report showing items ordered under the same external doc no. As part of the report I want to show stock quantity, outstanding quantities on POs (orders only) AND all outstanding quantities on SOs (orders only). So I've used the item table and then Sales line, Purchase line and item ledger entry for the stock figure. For the POs and SOs I filtered the sum of outstanding quantity to show doc type order only.
The problem I have is that whilst the stock and the POs are reporting correctly, some of the SO totals are out by one or two. Both me and my developer have investigated it in SQL and classic client and neither of us can come up with a matching figure to the report.
and NO, no one shipped those quantities or placed them on SO whilst I was running the report.
anyone had this happen. Any clues?
Cheers
Matthew
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello Matthew -
While this is not something that any of us have ever seen, if it would be possible to duplicate the issue with a very limited data set (so the we could actually see all the data involved) and the report itself is simple enough, you could try posting the report and the (very limited) data set.
-HP -
Jet Reports Historic Posts Hmm…
Tricky to know how I might duplicate it as I don't know why it's occurring in the first place…
I've just bought Jet Essentials so I'll try running it there so see if the same glitch pops up.
I'll let you know.
Please sign in to leave a comment.