Adjust inventory out on a Friday - On Sunday Adjust inventory in at new value.

Wouldn't an Inventory Worksheet be able to do this in a single transaction?

I've had trouble with inventory worksheets and inventory detail.

Oh we don't use inventory detail so I haven't come across that