We noticed that the bin quantities are showing at a decimal value when we split lines to ship? We have the config setting set to 1.
We are still facing issues with improper inventory tracking, due to not being able to recover receipt codes that have been allocated to a closed order.
For instance, SMT needed a total of 14500 of a resistor. We have 3 full reels (5k each) available for this job, so we allocate 14500 to the work order, and hand them to the floor.
Total Need: 1400
Receipt#1, Date Code 2150: 5000 - No excess
Receipt#2, Date Code 2150: 5000 - No excess
Receipt #3 Date Code 2233: 4400 - 500 excess and expected back from the floor
Say, the floor did not consume the reels in the order that we allocated them, and instead used all of Receipt#2 and Receipt#3 , and gave us back Receipt#1 with 500pcs left on it. To maintain quality and proper traceability in adherence to our QMS, we need to bring back Receipt#1 into stock, without having to change the original receipt code (Receipt#1) - due to keeping track of every single receipt code and also the date codes are different.
And we would also need to allocate the full 5k of Receipt#3 to the work order, because that’s how it’s been consumed. We have implemented Use First and Use Last bins when putting a kit together, but we have very little control over how and if production uses the parts in the right order, per allocation.
In this scenario, how would we minimize doing inventory adjustments and creating 0 dollar POs to bring these parts back into stock? Or what is the correct way to go about this scenario?