Hey Everyone,
We are having quite the issue with acumatica because it seems it was not built for the way we run our business.
I’m curious if anyone else has these problems.
Our company very heavily relies on lot tracking and traceability. Basically, we need to know what lot was used in what, and what warehouse location it was transferred to and everything like that. And for this reason we are not able to just backflush inventory, we need to actually assign each box that we use to a production order.
But in the instance of a production order, we usually issue a full 900kg of powder into a production order. That 900kg of powder has a cost to it, which is then given to the first move transaction of finished goods.
The issue is that the cost (value) given to the very first move transaction is exactly the same cost of 900kg, even though in reality, we only used 50kg. Lets say we make 4 more move transactions, these next 4 have 0 value in the system. How is there not a way for the system to accurately take the cost of only the 50kg that it would actually take to make that first move transaction of finished goods. So each move transaction would have an accurate value for the amount of material that it would normally take to produce it?
The second issue is:
maybe we didn’t use all the powder once we complete the production order, and we return the leftover powder back into the warehouse inventory. That first move transaction still has a value of essentially the 900kg that we issued to the production order, even though we may return 300kg. The system then does a WIP Variance Adjustment to correct this, but only once the production order is closed. This by it’s self isn’t the biggest issue because the system does this automatically, but I don’t understand why it can’t just go update those 0 value transactions instead of just giving a variance to counter them.
Our options that we have been given are these:
Standard Costing: which we don’t want to do because we don’t have the ability to pay someone right now to spend 4-5 hours a day to dive into how much things actually do cost and keep it updated.
Staging area/ Backflush ingredients: Instead of picking the lot/serial number of the components we use, we just backflush the ingredients. Which means when we create a move transaction the system automatically issues the exact amount of materials that we would need based on FIFO/Exp dates.
We don’t want to do this because we need to be able to actually choose which lot/serial items go into the product, and if there are 3 boxes in the backflush location, we need to pick which of those 3 bags we actually consumed.
No Move Transactions until Reconicilation is complete: We could wait to create any move transactions until the production order is complete and we have returned the material that we didn’t use.
We don’t want to do this, because we may run the same product for a week. And the pallets of finished goods would just be sitting in the warehouse with no label, unless we wrote on a paper. But we also would not be able to track where it is, and we cannot consume it into another order or ship it until the whole production order is complete.
I know this is a lot to read, so if you read all of this I thank you. I am just looking for any other ideas to see how other businesses get away with this. This all seems backwards to me, but it could just be my perspective.
Thanks
