Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

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

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

Categories:
  • 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 71,565 Super User 2024 Season 2 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,421 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,157 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans