Inventory sheet template for openoffice for free#
Inventory sheet template for openoffice serial#

Obviously this would also need to be adjusted automatically too, so when I select PRODUCT1 on the sales sheet and enter QTY SOLD 3, if the QTY AVAILABLE was previously 4 from the stock sheet this now show QTY AVAILABLE 1 on both the sales sheet and the stock sheet. Vertex42 focuses on Excel, so people may not know that we offer 100+ free templates for OpenOffice and LibreOffice as free.

Inventory sheet template for openoffice serial#

Then, complete the spreadsheet with the following information for each unique product: ID number, name, brief description, unit cost, quantity, style, value, serial number, and condition. Click on Get more templates on-line in this pop-up.

Inventory sheet template for openoffice for free#

Or from within OpenOffice Writer, click on File then New and then Templates and Documents. Free Inventory Form Templates Smartsheet Contributor Andy Marker MaTry Smartsheet for Free We’ve compiled the most comprehensive collection of free forms for business inventory management, which inventory clerks, warehouse managers, and other inventory-stock personnel can use. First, indicate the name of the store and the date. Go to to find invoice templates or click the button on the program’s home screen that says Get more templates for OpenOffice. No more writing out inventory lists or stock takes by hand simply enter inventory info into your chosen inventory record form or online spreadsheet and view the information in an easy-to-read format. Download this inventory template as an Excel spreadsheet or a PDF. I understand I’d likely need to have another sheet with all the products listed there along with the qty’s available, etc but I can’t get my head around how I would get what I wanted without a massive formula that would have to be applied to each cell on the “sales” sheet which could be quite unworkable.Įssentially I’m looking for a way to have another sheet, like a stock sheet, with the products and qty’s available and have those qty’s shown on the sales sheet once I selected the product from the dropdown we have there currently. So whether you’re keeping track of supplies at the office or items in your home, get organized with our free online inventory templates. The “Product Sold” field is simply copied and pasted from the previous line and I have this field as a dropdown which contains all our products.ĭATE | PRODUCT SOLD | QTY AVAILABLE | QTY SOLD | CUSTOMER DETAILS Hopefully I can explain this logically, bear with meĬurrently, I have a sales sheet where I enter the details of our sales.ĭATE | PRODUCT SOLD | QTY SOLD | CUSTOMER DETAILS