Skip to main content

Notifications

Announcements

No record found.

Business Central forum
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

  • 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 64,563 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,411 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,139 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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans