I’ve been asked to make it so when a receipt is made to a specific bin, that immediately afterwards a quantity adjustment should be made to set the number in that bin as 0. Basically, the bin should work more as a virtual bin, and anything received to it should be not included anywhere that Epicor is summing Part Quantity.
While I can certainly write something up that would do just this (probably not simply, but doable), is there a better way to go about this?
Like a Stock Item but not Quantity Bearing?
If you make the bin non-nettable, that excludes it from various things in the system.
Trying out this nonnettable. Do you happen to know if it records these transactions anywhere? Unless I’m looking wrong, I see nothing in the PartTran table or the Rcv Tables after performing the transaction. Was hoping it was still recorded in some way if I ever want to go back and look at it.
Back up a minute, what’s the problem we’re trying to solve. That might help give best direction.
We have a consumables bin that we want to be able to record receipt to but we don’t want the quantity that has come in to be used for other calculations as it could lead to people assuming product is here that is not. This bin is used for one offs that isn’t going to be put in to inventory, but we do want to account for us having made / received it before.
Also, we are a job shop so we often make things that may or may not ever be made again.
For consumables I would just make it a non qty bearing part. You still do the receipt and transaction but it doesn’t go to inventory at all.