Sales Order Multiple

Fisherman

I'm having trouble remembering something. Hoping someone will set me straight.

I need to ensure that quantities entered on a sales order are in multiples of some number of eaches. A different unit of measure isn't suitable because the product arrives, is inventories, and is sold in eaches.

Is there something pre-existing? Having trouble running it down.

jglathe

Hi fisherman,

if it's not a NA localization feature, I doubt it. You can enter quantity witch decimals in a sales order. I would recommend to change the behaviour by item or item UOM, with code.

with best regards

Jens

Savatage

Are you trying to avoid selling decimals? Like when the inventory has 0.5 or something like that?

Fisherman

Not really.

Our stock is purchased, received, inventoried, and priced, sold, and shipped in eaches, BUT is physically in cartons, and we don't break open cartons.

So, if an order is placed for 50 pcs, but that part comes in boxes of 75, then the smallest quantity we'll ship is 75. But everything must be expressed in the priced unit of measure or the customer won't pay for it... period.

Now - I can get crazy and modify every report and invoice to convert from base to sales UOM, but that seems unnecessarily complicated to me... Ultimately, when the order comes in and shows EA, I shouldn't expect a data entry person to do the math to convert to CASE only to have the system convert it back to EA on invoices/reports.

On the replenishment/planning side, you have Minimum and Multiple quantities so that planning won't recommend replenishment for less than a minimum quantity, and will recommend in even multiples. I'm looking for some way of doing something similar for Sales.

I can always add the functionality, but was trying to avoid it if something already existed.

Fisherman

If something isn't already there, then I'm thinking of adding a couple of fields to hold "Sales Minimum Quantity" and "Sales Multiple Quantity". Then, likely in the OnValidate() trigger of the Quantity field in T37, I'd compare the quantity against those two fields and prompt the user to confirm updating to enforce the minimum/multiple...

kiranvv

Hi;

I think Minimum Order Quantity feature and Order Multiple feature in "Planning" tab of Item Card may help you.

Fisherman

Kiran

Those fields are involved in planning and replenishment, not sales orders