We recently realized that for a few years, unbeknownst to anyone in the company, the Items Billable by Default setting was set to on (checked) (Setup -> Accounting -> Preferences -> Accounting Preferences -> Time & Expenses Subtab -> Expenses Group). This was never intentional, and the result is over 240,000 line items on Purchase Orders, Vendor Bills, Vendor Credits, and a couple of other transaction types where Billable = Yes, so that the Items are now listed under Invoice Billable Customers.
We attempted to fix this with a CSV update, but that failed for a number of reasons (most of the transactions were in locked periods and this apparently is a G/L change, even those in open periods where the CSV gave a "success" and not a failure error, the field was not actually changed. Worse, it caused a recalculation of taxes resulting in a large number of transactions now being off by $0.01, and some foreign currency transactions being off worse because of currency revaluations. We fixed those.
Which brings me to the ultimate question: short of manually billing out all these items with countervailing amounts to zero them out (which is really not practical), is there a way to do a mass change to fix this problem and make all these Billable Items not Billable any more?
Thanks in advance.