I would need to calculate the gross margin for my sold products every month, down to the accuracy of every single unit.
So for this to happen, I must be able to tie the sold unit to a purchase order either via:
- A barcode ( When I order a Purchase Order, I key in a barcode for every single unit, and when I sell, I can key in the barcode for the sold unit, so that the link is presented)
- Or, if 1) is too cumbersome, every single sold unit will be deducted off from the earliest available Purchase Order
So in this way, I can tell how long it takes for every unit to be sold, once I order them from my supplier. And it would then be trivial to calculate the gross margin for every single unit ( which is nothing but the unit cost according to the purchase order, minus the sold price).
Is there any ATUM plugins that can do this?