1 (edited by rob75 09/03/2013 03:42:23 pm)

Topic: Items and purchasing

Hi all,

I am a small businessowner where one of my activities is selling Italian food products. I have a problem with items and inventory. Some items I purchase per box and sell them per item. So for one item I chose the unit per box (they sell per 10) and used a conversion unit of 10 for the supplier and a conversion to own units of one. Later on I discovered that the inventory was only added with one after a full purchase order. As I would like the item to show up as 10 after a purchase I started fiddling with the numbers. I discoverd that when buying per 10 the UoM and UoC should be the same, resulting in what I want. For example: a box of pasta containing 10 packages of pasta should go with a unit price of 24,95 (suppliers price per box) an a supplier UoM of 10 and a conversion to own unit of 10. This resulting in a purchase order of the item with 10 pieces with a correct per piece price and an inventory update with 10.

My problem now: I allready entered purchase orders with the wrong conversion units, leading to faulty inventory values and stock values.

As I understood, existing purchase orders cannot be update with the right purchase information. So leaving me with nothing else then to start over with the accounting. This is not a big deal as I've just started and the total of transactions is still low and on paper record.

Just to be sure not to do something drastic, is my method for items and inventory right and should i better start over with a clean accounting?

If anything is not clear please ask for clarification.

Thanks in advance,
Rob