Hi All,
While saving the sales order, our script creates a work order and sets all mandatory and necessary field values for the work order. We have a custom field on the sales order line level to input the work order production end date, which is then used to set the Production End date on the work order. A separate work order is created for each sales order item line.
Initially, our script correctly set the Production End date on the work order. However, when saving the work order, NetSuite automatically overwrote the Production End date in most cases, changing it to the previous day of the entered date.
We conducted tests by creating a work order through the User Interface (UI), and the same issue occurred. The Production End date was consistently overwritten by NetSuite. We also checked for customizations, such as scripts and workflows, related to the Production End date field update, but found none.
In the Manufacturing preferences, we have "Backward Scheduling" selected as the Default Scheduling Method. We investigated the "Backward Scheduling" functionalities but could not identify the specific reason for the issue. The inconsistent nature of the Production End date changes made it challenging to pinpoint the calculation logic. Are there any other operational functionalities that could be affecting the Work Order Production End date calculation?
Any thoughts on this?