G
GuestUser140
Guest
<div class="bbWrapper">Hi guys,<br />
<br />
We sell used consumer electronics amongst other things.<br />
<br />
I like simplicity.<br />
<br />
Until now, I've always used two Excel files: <br />
<br />
1. A general table with all the stock in it (with serial number, purchase price, date, ...)<br />
<br />
Only the columns "sale price", "sale date", "invoice number" and "customer name" are empty and need to be filed out when something is sold.<br />
<br />
2. A blank invoice template.<br />
<br />
When something is sold, I (or my employee) simply fills out the 4 empty fields in table 1. Takes no time.<br />
Then she copies the line of that specific item from table 1, and pastes it into the invoice.<br />
<br />
Print and done.<br />
<br />
Variation: save as PDF, upload to cloud, done.<br />
<br />
At the end of the month, we do a stock count.<br />
She scans the physical stock and emails me the barcodes. I check in table one whether all the empty fields correspond to a scanned barcode (=whether an item is indeed in stock). I do that manually. (About 100 barcodes which takes 15 min.)<br />
<br />
Am I doing too much work? Can it be done more efficient? <br />
<br />
<br />
Best,<br />
<br />
Michael</div>
Dislike ads? Become a Fastlane member:
Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)