We are a distributor, and we are having issues with our costing. We use Special Purchase Prices from our vendors that are associated with specific end users. I know we can use the Purchasing Code to tie a particular Sales order to a Purchase order, but here is the dilemma.
Let's say we have part ABC. We buy it at $5 for our OEM. We have safety stock of 25 on hand for this customer. We also sell this part directly from out Web site. Our cost from the vendor for anyone other than Customer ABC is $10 per unit.
So now let's say we currently have 25 on hand, all purchased at the SP of $5. We have 50 on a purchase order at our regular cost of $10 per unit. We receive a sales order from our Website for a Qty of 5 and the customer wants them ASAP. We have the parts physically on hand, but per NAV they are designated to our OEM.
Is there any way we can "easily" take 5 that were purchased at $5, adjust the cost to $10 and ship out to our web customer? Then when we receive the 50 on order at $10, I would need to put 5 back at a cost of $5 for our OEM, and have 45 in stock with a cost of $10.
We pay commission on GP so it is very important to make sure the actual costs are associated with a particular sale. However, we also want to provide the best service possible to our customers. If we have stock on our shelves, we want to be able to ship it to our customers. When we have items purchased at different costs it becomes difficult.
We currently use Weighted Cost for our inventory valuation.
I'm hoping someone has similar issues and has found a way to make NAV work for them. ANY suggestions would be greatly appreciated. We are scratching our heads trying to figure this one out.Thanks,
If you've found this thread useful, dive deeper into User Group community content by role