Tracking varying inventory costs and vendors for same product using FIFO

[evolveddistro]

I've spent 20 hours looking in to inventory systems for magento and can't find any thing that performs this seemingly simple task.

I need a system that allows me to track where my inventory comes from (vendors), and how much it sells for so I can track my margin. I need to assign COGS in a fifo fashion in cases where I am holding one SKU that was replenished by more than one vender.

So last week I bought 10 widgets from company A for $6 each

This week I bought 10 widgets from company B for $4 each

Today I sold:

6 widgets for $10 

7 for $12

Company A gets logged for 6 widgets sold at $10 each and 4 at $12 each all costing $

Company B gets logged for the remaining 3 widgets at $12

10 widgets cost me $6 each

3 cost me $4

Quantity in inventory is now 7 widgets

Any ideas what extension could do this?

[Gabriel Guarino]

Hi @evolveddistro,

Since this has been posted several days ago, I would like to know if you were able to find the solution.


Please let us know.
Best regards.
Gabriel

[evolveddistro]

No it hasn't. We are looking at Odoo as an option at this point. There doesn't seem to be any modules or built in functionality for Magento that can handle inventory in a sane manner.  We are thinking of using Odoo for inventory and connecting that to magento