Hi All, I've been playing around with sql-ledger for a while and seem to have most of it figured out. i still have some outstanding usage questions that someone out there might be able to help me with.
Background I have a violin making business. I make instruments and bows and also purchase used instruments for resale. Most of my questions have to do with documenting inventory and cost-of-goods-sold. Questions #1. Re-selling used instruments seems pretty straight forward. I have set up inventory accounts for each type of instrument and when I purchase an instrument for resale I just enter it into inventory with a vendor invoice and use a unique item number. The COGS is just the price I paid for it. One question I have is that often I put quite a bit of work into the item to get it ready for resale. For example, with a bow I may re-hair it, put a new tip or new grip on it, etc. These are all services that i would normally charge a customer for. How do I account for this in sql-ledger and get it to roll-up in the COGS for that particular item? #2. I not quite sure what to do with items that I make. I can enter an item into inventory with a vendor invoice with me as the vendor again giving each item a unique product number. What price do I charge? I guess several options are: zero, sales prices, my best guess as to what materials I have in it. #3. This is related to the last question. I stock a number of raw materials and finished items for making and repairing instruments. How do i handle this? For instance, let's say that I am making a bow. I will need some wood for the stick, wood for the frog, silver fittings, a tip and hair. Is there a way in sql-ledger to remove those items from inventory and assign them to the bow I am making and have that show up as the COGS when I enter the finished product into inventory? #4 Finally, when I enter a vendor's invoice, everything has to be an inventory item. Quite often I will get invoices that have some inventory items and some items that are just general supplies (like glue or sandpaper, etc.). What is the best way to enter these invoices? Thanks in advance for your help and thanks to Dieter for a very nice piece of software. Barry ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
