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
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?
Hi,
We purchase in a long length and then cut as required
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).
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
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.
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?
Regards
Vinita
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,275 Most Valuable Professional
nmaenpaa 101,156