Would someone be able to explain why Epicor will not show all the releases on a pick list. Notice my screenshots there show 3 releases for both lines 4 and 5, but the pick list only shows one release for those lines.
Even though this pick list here is a custom one, the same thing happens on the default report.
Do parts on the fly show on the pick list and are any of them parts on the fly?
My guess is that it is because the report only goes down to the line level and probably only selects the soonest release date (I can’t see what Epicor does to generate the data). Since the release dates are all the same, it only takes the first one it comes across. What happens if you ship release 1 on one of the lines? I would think that the report would then show the second release.
More importantly, why do you have 3 releases with the same date? I would understand the need to do that if there are multiple ship to’s, but then I would expect the report to work properly and have each release with the ship to’s splitting the report.
they are not on the fly
Anything different for the releases other than the quantities? Are you shipping to different addresses on each release?
all going to the same address
correction, they have different addresses for each release.
Are the releases open?
Yes, just double checked
Dates? The pick list is date limited, right?
Oops - didn’t read that very well. All the same date.
Also, I think drop-ships don’t show, but I assume that’s not the issue here. Just FYI.
I tried a test order and everything came through in the stock pick list. Is the request date the same for all three releases? If I adjust those and my pick report falls within the range I don’t get all of the releases. The need by date doesn’t seem to affect the report.
Releases are not Drop Ship
They are make to order? We do MTO here, but we never use the pick list for those jobs, so I don’t know the gotchas with that.
Do the jobs have a completed quantity (via time and expense or job adjustment)? I presume this is a prereq…
One of the lines is MTO the other line is not MTO. Both have the same “missing releases” on pick list
I would start troubleshooting the output from the report program. Can you generate the report and then look at the report data to see what data is being generated? That may help eliminate what you need to look at.
You referring to something like this? Because the report data only shows one release for the 2 lines.
This is data from the default report
When you generate a report, it creates temporary tables in your report database:
When it generates you’ll get the following in your report monitor:
If you then look in your report database via SSMS you can see the following table:
This table should show all of the releases. If it does not, then the data is getting filtered out from Epicor. If it does, then your report is filtering them out. My guess is they will not be showing since they don’t show up in the stock report either, but it’s good to check.
