Absorb cost but not quantity

Got a new customer who wants to issue sheet goods to a job, and cost the ENTIRE sheet to the job, but any unused material he wants returned to inventory with zero value so it can be used later on. I can’t think of any way to separate the unit cost of a transaction from the quantity involved… we’ll issue “1 sheet” to the job, add the whole cost of the sheet to that job, but return some inventoriable portion to inventory with zero cost.

This is a privately owned company, so SOX is being ignored. They do not have Advanced UOM, but unless that would be required to solve the cost/quantity issue, I can work around that.

If you are returning to a different part number, you can edit the cost on the salvage transaction.

If you are returning to the same part number, I don’t think you can alter the cost.

You also could close the job out and then do a quantity adjustment in at 0 (depending on what their costing is).

They’re wanting to use Last as their cost method. If they did the quantity adjustment after the fact at a zero cost, would that revalue their entire inventory to zero?

No, I believe it would go into inventory at Last cost because cost adjustment changes the cost.

I’ll test it out (probably not for a week or so until I’m back there), but I’ll let you know. Thanks!