I do know, the Netsuite documentation on Inventory worksheets strongly recommends against using worksheets to "retroactively" impact valuations; the flavor of the write-up that I saw, was to use worksheets from a "today moving forward" type of basis.