Is this doable through simple script or field calculation? I don't know where to start but I'm hoping to exact solution about this.
Here my example. I have a stock of 70", 100", 2pcs of 150" and 12pcs of 240". Also i have orders that needs
39", 88", 91", 106", 55", 55", 72", 72", 72", 144", 144", 144", 32", 66", 66", 66", 66", 144", 144", 144", 50", 50", 81", 81", 132", 132", 132", 168", 196". In the real world my goal is to minimize the wastage. So it will end up similar to this results.
#1 - 70" = 66", with 4" wastage
#2 - 100" = 66", 32" with 2" waste