1

(2 replies, posted in Items and Inventory)

Hello everybody,

Slowly I'm getting to know Frontaccounting and can perform the basic tasks I need.

Now the more advanced things come up. One thing I can't seem to find in theze forums (and on the rest of the net) is the use of graduaded discount. For example: I buy bottles of wine per dozen and sell these a piece. This setting I have managed already. Now I want to give customers a discount when bought per 6 bottles. Only problem is, this discount should  not be a percentage on the item price. I want this to be a fixed price for the 6 bottles and the inventory should be adjusted as well.

Is there a way to get this result?

Thanks in advance,
Kind regards,
Rob

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