Chris Warren
Forum Replies Created
-
A few of our favorites:
- Dimension Manager for NAV: While this isn’t needed anymore since Business Central lets you update dimensions for posted transactions, historically, the only way of updating dimensions was using an add-on like this. We decided to overhaul the dimension setup in our environment, and this was a great app to use.
- Shop Floor by InsightWorks: We used to have an intern whose sole job was to take the time cards from a 3rd party system and post capacity ledger entries against production orders to properly cost our items, and then provide documentation that they were properly reconciled…. needless to say, this app paid for itself.
- Continia Expense Management: I’ve written a few articles and blog posts about this one. It’s probably saved us the most money in the long run. Historically, we used Concur, and it took a team of 3-4 people to transpose the data from Concur to BC after it went through a manual review process. With Continia, everything is done in real-time, and all reviews and approvals are digital. Everyone in our company is shocked at how ‘easy’ it is to do expense reports now.
I’ll also add that the support from Continia and InsightWorks is incredible. We’ve had a few issues, and they are both very responsive.
Can’t wait to hear about what other people are using.
-
I’m excited to see what @RobbDelprado and @billwilson have curated for us this month!
-
Hey Jonathan, thanks for your question. We have a similar situation where we produce medical sensors. These sensors are packaged into boxes of 10, and then those boxes are packaged into cases of 80. Due to quality and manufacturing process requirements for traceability to each box of 10 (per the FDA), we have to treat these as different production orders.
We batch produce individual sensors, and place them into inventory as finished goods. When an order comes in, we create another production order to package the sensors accordingly, and then ship them out.
I hope this helps. Maybe @davidwiser or @chinsky can chime in if there’s a better way.
-
Another option: If you have Jet Reports, you can quickly create this by filtering on the Item Ledger Entries (as previously mentioned) and doing a table filter based on the posting date. If you want this item-by-item, you can either prompt the report to ask you what Item Number or create a pivot table in that Excel sheet based on the data that Jet brings in.
-
One option would be to make your packaging material an item, and then consume it in the production order. This is how we’ve done it for a lot of our products.
Another option would be to do a revaluation of the item after the production order is finished, making sure that the inventory revaluation account is set to that expense account in the General Posting Setup.
Apart from that, I’m unaware of another way to add a ‘charge’ to a production order.
-
While it’s not a report to compare all production orders, have you checked out the “Statistics” tab on a Released or Finished Production order? It sounds like this would show you the information you’re looking for.
We’ve used this during financial audits to prove our costing methods for our Items/Work Centers/Machine Centers. I’ve also managed to recreate this in PowerBI and Jet Reports to get the report that you’re looking for in a single spreadsheet, since I have yet to find an OOTB report from NAV/BC that can do this.
