search

agritheory / beam

General Purpose 2D barcode scanning for ERPNext
https://agritheory.com/documentation/beam/
Other
23 stars 11 forks source link

Split quantities based on Handling UOM #22

Open agritheory opened 1 year ago

agritheory commented 1 year ago

An example case to integrate: assume that the Item "Flour" is purchased in 50 pound bags. Flour can also be purchased by the pallet : 20 50-pound bags. When we receive 1500 pounds of Flour, we want it automatically split the pallets into two handling units, one with 1000 pounds and one with the remainder.

There's a function that does this division in the codebase but it is based on customizations to UOM conversion detail. This doesn't seem configurable enough for our purposes, so a more comprehensive design is required.

Additional Requirements - 8/8/24

If the current row is already using the "preferred" UOM, continue, regardless of qty. This will allow specific over/under on items that may be received or transferred that are variable-per-HU (boxes of fruit).

Add a button to the child table to split items based on a dialog input. If a PO raises a total requirement for 75 boxes and the boxes are received as 7 per-pallet, but a pallet UOM specific conversion is not configured, allow that conversion. There's a chance we want to modify our "strict UOM" feature in Inventory Tools to accommodate this with more sensitively.

agritheory commented 1 year ago

@federicocalvo @fproldan Please let me know your thoughts about this issue.

viralkansodiya commented 7 months ago

@agritheory

company can buy Flour 50 pound bags, which means each bag has 50 Pound weight company can also purchase in pallets, where 1 pallet is equal to 20 bags and each bag has 50 pounds of weight.

did I understand correctly?

hpema commented 5 months ago

Receiving in pallets would make sense in this senario and the pallet would need to be able to be received in fractions only divisible by the bad/pallet. This makes it tricky.

Important factor would be how the item is going to be used. So if items will be used in pounds then I would suggest receiving in pounds. Maybe have some kind of UI support to keep track of what actually is being received - pallet in this case. Maybe extending the UOM doctype for this without using it for any conversion but just as support.

These are my initial thoughts.