The above is not possible by default in BC, I know. But a customer of mine has functionality (built by previous partner) that allows them to post left-over stock in the system (not in physical stock anymore) back to output of finished production orders (where the stock output potentially has been shipped and invoiced already). They are on NAV2013. I cannot get my hands on the current NAV source code. I have done a quite a bit of research on this to no avail.
If you think of the concepts introduced by Item Charge assignment, something like that would possibly allow this to be possible. Obviously the consumption would just be a write off of inventory but the cost could be allocated to the output and flushed through similar to item charges.
Many years ago (NAV 5.0 SP1) I built a process that was based on Item Charges. The purpose was for posting actual overhead to production output. Based on that experience I’d say your idea is feasible.
I don’t think I have the complete project. It was a long time ago and also was not a single modification project. I may have bits and pieces of it from which I could provide some guidance.
There was no UI with this. it was designed as a batch process.
It sounds like you’re trying to figure out a way to allocate costs to output for leftover stock that has already been shipped and invoiced. While it may not be possible to replicate the exact functionality built by the previous partner, there may be some workarounds you can explore.
One idea is to use the Item Charge Assignment feature to allocate costs to the output of finished production orders. This would involve creating a new item charge code specifically for the leftover stock and assigning it to the output items on the production orders. The consumption of the leftover stock would be treated as a write-off of inventory, but the cost could be allocated to the output items and flushed through similar to item charges.
Another option would be to create a custom journal that would allow you to manually adjust the costs associated with the finished production orders. This would require some development work to create the custom journal and integrate it with the production order process, but it could be a viable solution if done correctly.
Ultimately, the best solution may depend on the specific needs and requirements of your customer, as well as the limitations of their current NAV2013 system. It may be worth consulting with a NAV/BC developer or consultant to explore different options and determine the best course of action.
The item charge approach would be a valid solution. Something I have done in the past. In that scenario, we were using item charges to apply actual labor cost to production output. This is basically the process I mentioned above. Of course, assigning item charges to production is not a standard feature. So this involves a fair amount of custom work.
One issue with applying new cost to output, is those cost changes cannnot be posted as direct cost. Otherwise future Adjust Cost runs will simply back out those changes. The approach of using item charges helps to work around this.
Hi @bbrown5962 how can i get in touch with you. I am doing a similar customization. I have managed to create the item charge assignment but i cannot get the value entries posted. Need some help