What is the appropriate equation to determine the required adjustment value for Periodic Average PAC

Summary:

We encounter an issue during every month-end closure, where we need to adjust a specific item’s cost to reach a required value.

For example, if an item currently has a cost of 10 and we need to adjust it to 20, we face a challenge because the Manage Periodic Average Cost Adjustments screen only allows input as a positive or negative value, rather than directly setting the desired cost.

Our main problem is that we do not know the exact adjustment value required to achieve the target cost.

Could you please confirm if there is a specific formula or equation we can use to determine the correct adjustment value needed to reach the desired item cost?