We can’t be the only company out there with this issue…We received a full truckload of XXX. It is received through a PO. We then bill the customer for the full truckload by using a sales order and reserving the received load. This all has a cost and sell. We keep the full truckload of XXX at our warehouse and track inventory levels as the customer comes and takes XXX bits at a time. We need to see the original cost and sell in the normal accounting places but we also need to see the actual inventory level of XXX and it’s cost needs to be kept at 0.00. Our original implementation company came up with a solution of keeping a separate “Customer Owned Ledger” but this is not working as it does not have the full functionality of the Item Ledger. Our new IT partner has suggested making an additional XXX-1 item and modifying the system to place the full truckload quantity into this item at zero cost thus we would have one item (XXX) where we would see the cost and sell and another Item (XXX-1) where we could keep track of the actual inventory for our customers. I don’t really want to have to increase our items by doing this. Is there some way to have everything happen in one item? Receive and invoice with quantity, put the quantity back at zero cost so we can keep track with only 1 Item?
We also don’t want to have to manually post cost revaluations or have to insert quantities manually. We run through inventory too quickly for this to be an option.
I would love to hear from anyone knowing of any solutions or anyone with similar issues and what you have done to address this issue.