Options

Sales Order Multiple

FishermanFisherman Member Posts: 456
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.

Comments

  • Options
    jglathejglathe Member Posts: 639
    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
  • Options
    SavatageSavatage Member Posts: 7,142
    Are you trying to avoid selling decimals? Like when the inventory has 0.5 or something like that?
  • Options
    FishermanFisherman Member Posts: 456
    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.
  • Options
    FishermanFisherman Member Posts: 456
    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...
  • Options
    kiranvvkiranvv Member Posts: 4
    Hi;

    I think Minimum Order Quantity feature and Order Multiple feature in "Planning" tab of Item Card may help you.
    Regards,
    Kiran
  • Options
    FishermanFisherman Member Posts: 456
    Kiran

    Those fields are involved in planning and replenishment, not sales orders
Sign In or Register to comment.