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
