Skip to main content
Business Central forum
Suggested answer

Sales order lines with variable size and quantity - UOM and variants

editSubscribe (0) ShareShare
ReportReport
Posted on by 10

Hi,

Sales order lines with variable length and quantity

We are setting up our company on Business Central, but having difficulty working out how to set up the products.

We sell wire rope by the meter. Customers can order any length of rope, they may want 1 x 25m rope or 8 x 12.5m rope for example

So the quantity and the length are both variable.

How would you recommend we do this?

Trying to void using variants...

thanks for your help

  • Abi Lidd Profile Picture
    Abi Lidd 10 on at
    RE: Sales order lines with variable size and quantity - UOM and variants

    Hi,

    This may work. Can you get the details of the required length on the sales order or is it only shown on the assembly order?

  • Abi Lidd Profile Picture
    Abi Lidd 10 on at
    RE: Sales order lines with variable size and quantity - UOM and variants

    Hi,

    We purchase in a long length and then cut as required

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 59,926 Super User on at
    RE: Sales order lines with variable size and quantity - UOM and variants

    Hi, Was the raw material purchased in one piece? Inventory by square meter?

    If there is a cutting process, I recommend using the assembly order proposed by Josh.

    If you just buy and sell, I recommend using square meters to manage inventory, and manage length and width in Item Attribute (Or new fields).

    pastedimage1652831466698v1.png

    PS: In this way of cutting, every time there is waste, it may be better to use a production module.

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,395 on at
    RE: Sales order lines with variable size and quantity - UOM and variants

    Hi

    Do you produce these items or you purchase them cut and sell?

    if you produce you can use assembly or production order tp produce the length you want and QTY.

  • Suggested answer
    Vinita_Kas Profile Picture
    Vinita_Kas 325 on at
    RE: Sales order lines with variable size and quantity - UOM and variants

    Hi Abi
    I can think of a few ways you could do this

    If you have a standard size of the rope which is more often sold then use that as an item example 1* 25 M rope
    did you try the related UOM for different combinations of length and qty where you can specify UOM as meter square?

    pastedimage1652825924851v1.png


    Regards
    Vinita

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,131 on at
    RE: Sales order lines with variable size and quantity - UOM and variants

    Maybe an assembly BOM? Idea would be use assemble to order. So the qty. on the sales line is how many and the assembly order is length. User would be able to alter both values and stock is depleted accordingly.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans