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

Formula in Navison

(2) Share

Report

Posted on by JM-20030740-0

Hello everyone,

I have a question about Navision Business Central.

I have various steps in the routings.
In one step I would like to make a calculation which is dependent on the number of pieces currently produced. For example, the production order with the quantity 100 is active. I would like to generate a calculation of 0.5. Quantity* 0.5 for example. Is there anyway to use formulas in the routingsteps

Many thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

It would require a customization, that the lines are generated (or the quantity field is updated - really depends on your process)
You could add a setup where You enter the Coeficient, then some process that generates/updates line, where this process generates a string of Quantity&Coeficient that would look like 100*0,5
If this text string is entered in Quantity field and validated, it should leave a value of 50 in the Quantity field

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report
Hi,

In that case you need to create a cutom logic like I tried below:

Create custom field in routing table to show the calculated value decimal field and show this to routing page as well and put the same field in "Prod. Order Routing Line" table using table extension.

do the following:

trigger OnAfterInsert() begin CalculateValue(); end; trigger OnAfterModify() begin CalculateValue(); end; local procedure CalculateValue() var ProdOrderLine: Record "Prod. Order Line"; begin // Find the related production order line ProdOrderLine.Reset(); ProdOrderLine.SetRange(Status, Rec.Status); ProdOrderLine.SetRange("Prod. Order No.", Rec."Prod. Order No."); ProdOrderLine.SetRange("Line No.", Rec."Routing Reference No."); if ProdOrderLine.FindFirst() then begin // Calculate: Quantity * 0.5 Rec."Calculated Value" := ProdOrderLine.Quantity * 0.5; Rec.Modify(); end; end;

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,575 Super User 2025 Season 2 on at

Like (0)

Report

Are you talking about your BOM calculation or the Routing Calculation? This is standard functionality in either case.

For Routings:

Expected Capacity Need = Setup Time (Fixed) + (Run Time x Quantity)

For example, if my Setup Time is 0 and my Run Time is .5 and my Quantity is 100, the Operation will have a Capacity Need of: 0 + (.5 x 100) = 50.

If you are talking about the Bill of Material, you can set a Qty per of .5, so if the Prod. Order Quantity is 100, the component has a demand for 50 units.

If I misunderstood your question, please share some additional information.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
JM-20030740-0 10 on at

Like (0)

Report

Thank you very much for your answers.

It's more about the following:

I have a raw sheet that measures 2000x1000x100 mm. I have this in the parts list.

We have a routing step that involves splitting the 100mm sheet into different layers. For example, into 2x25 and 1x 50.

If the customer now orders 100 units, the employee has to do the maths for this step himself. He then has to cut the 100 panels into 200x 25mm and 100x50 mm.

I would like to have this calculation path automatically in the work plan.

Example

10 Splitting - Split the sheet 200 times to 25mm
20 Splitting - Split the sheet 100 times to 50 mm

If the costumer is ordering now only 50 of course it takes it automatically different:

10 Splitting - Split the sheet 100 times to 25mm
20 Splitting - Split the sheet 50 times to 50 mm

so i was wondering if i could do a formula in the routingsteps:

10 Splitting - Split the sheet ‘quantity*2’ times to 25mm
20 Splitting - Split the sheet ‘quantity*1’ times to 50 mm

Was this reply helpful? Yes No