Recently, the volume of inventory assets that we convert to fixed assets has increased drastically.
Currently, the SO includes the initial installation costs and the actual inventory item at 0 sales price since we're not actually selling it. We're shipping it to the customer and then leasing it.
Once the SO is fulfilled, it hits the COGS. We manually create a Journal to reclass the COGS to fixed asset-CIP clearing account. We use NetAsset and NetLessor modules. The IF and Journal are both linked to a job code which is a custom segment.
On top of the product cost, we also have other costs that need to be capitalized as part of the fixed asset. Those costs are recorded in Vendor Bills and are tagged to job codes as well. Sometimes it is not posted directly to the fixed asset clearing account. So it also needs to be reclassed.
Now our plan is to automatically create the reclass journals for Item Fulfillment and Bills via script.
What is the best way to handle this?
We're thinking of developing a script that uses a saved search of the qualified costs and creates one journal (assuming the line limit is not hit) for all job codes. It will be scheduled to run daily and will update the same journal for the same period (provided it is open), so we won't end up with a lot of reclass JEs.
Once the final reclass JE is generated at month-end, we will then generate the NetAsset asset and lease provided that the job is complete already.
How would you handle this if you were in this situation?