The previously suggested approach seems to assume you're doing this on the Purchase Order Processing side (hence the reference to "Landed Costs"). It sounds to me like this is on the sales side (Sales Order Processing module). Isn't that right?
What you're doing is tricky, because if you use the same item number for both the real sale at let's say $100, and then do an additional inventory transaction at $0, the costing of your item will be adversely affected.
We're in the process of doing something like this for one of our clients. It's more a creative solution than a custom solution. These steps could be manually performed, but we are creating a small customization that will help manage it better. Basically, here are the steps:
-
Enter the original order/invoice and process normally.
-
When the sales invoice posts, we can either do automatically with code or you can do manually:
-
Create a copy of the item being sold that used expressly for the purposes of zero-cost transactions. This could perhaps be the same item number, but with a "Z-" prefix, or something like that.
-
Create an inventory adjustment to bring all items being sold back on hand using the "Z-" items, all at zero dollars.
At this point, you can process a new sales order for the "Z-" items, and add any processing costs, freight costs, etc. to the new order.
However, the remaining challenge is managing that "Z-" inventory. Two ways of approaching that. Perhaps you could have all "Z-" items track lot numbers (if you're not already tracking lot numbers), were the lot number is the customer ID on the original sale. Otherwise, a custom solution could be created to track activity on these items, and event allow you to automatically draw against these outstanding balances.
What do you think?
Ron Draganowski
Senior Solution Developer
Olsen Thielen Technologies, Inc.
rdrag@ottechnologies.com
http://www.ottechnologies.com
Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski
