Inventory Quantities and their amount upload

We are maintaining an excel of inventory of raw materials in several plants. Every month end, we extract the data and upload to F0911. The file has account number, amount, and units.  I don't want to setup an entire inventory module for those plants. While this works fine for the balance sheet, I am trying to see if there is a way to update Item Ledger and Item Availability if I create the item and have the G/L entry by account number, amount, units and item number. Please let me know if there is any report that I can run