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

How to calculate Standard hours by Sales orders

(0) Share

Report

Posted on by Gabi Rad

Hello to everyone,

Is there any way to calculate standard hours based on sales orders per month?

I've tried through Posted sales shipments first, then - Production order lines and Capacity ledger - at the end, but there is something, that I'd missed.

Appreciate your help!

BR, Gabriela

All responses (3)

Answers (0)

Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to calculate Standard hours by Sales orders

hi

it is possible to calculate standard hours based on sales orders per month in Dynamics NAV. Here is a possible approach you can follow:

Determine the required data: To calculate the standard hours, you need to know the following information:

The total quantity of each item sold in a given month (from sales orders)

The production time required to manufacture each item (from production order lines)

The capacity utilization rate for each work center (from the capacity ledger)

Extract the required data: You can extract the required data from the following tables:

Sales Header and Sales Line tables: To get the total quantity of each item sold in a given month

Production Order Header and Production Order Line tables: To get the production time required to manufacture each item

Capacity Ledger Entry table: To get the capacity utilization rate for each work center

Join the tables: You can join the tables using the Item No. field to link the sales orders to the production orders, and using the Work Center No. field to link the production orders to the capacity ledger entries.

Calculate the standard hours: Once you have joined the tables, you can calculate the standard hours for each item by multiplying the total quantity sold by the production time required, and then dividing by the capacity utilization rate.

Summarize the results: Finally, you can summarize the results by item and by month to get the total standard hours required for each item in each month.

This approach may need to be tailored to your specific business requirements, and the data you need to extract may vary depending on how your production processes are set up in Dynamics NAV. However, this should give you a general idea of how you can calculate standard hours based on sales orders per month in Dynamics NAV.

DAniele
Gabi Rad 10 on at

Like (0)

Report

RE: How to calculate Standard hours by Sales orders

Thanks, Zhu, I hope so, that somebody already have had the same task and could help :)
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to calculate Standard hours by Sales orders

Hi, Unfortunately, as far as I know, the standard does not have this feature, and this may require customization.

Hopefully other experts can give you better advice.

Thanks.

ZHU