Multiple Items in 1 Bin

Epicor ERP 10
, ,
1

Hi all,

im sure this is simple but 2 points

  1. Can we stop multiple parts from going into the same bin? But so the bin is not tied to a certain part i.e if the stock is used a diff part can then go into the bin

  2. This is currently an issue, is there a BAQ i can create to show this. All i can get atm is it to show like this (Below) would be hand to just get the ones that have 2 parts in them to show?
    image

2

That should be physically controlled. If they look in the bin, and there is something else in there, they shouldn’t put the second thing in there. Putting controls on the entry side of it is just going to stop them from doing the entry.

If you want to should the number, you can do group by and count the records in the bins. If you need to show the part number you can use windowing functions to show the count so that you can order by that.

count() over (partition by partbin.binnum, partbin.whse)

That should give you the number of entries per partbin.