For years (see 2016 post) we have wrestled with missing material cost on the InvcDtl.mtlUnitCost field. It is “random” in that it is not all invoices. To correct the issue we would use an updateable BAQ and update the cost field with the correct unit material cost prior to month end. Fast forward to 2026 and we just upgraded to 2025.2.25. It appears the BO no longer allows us to update cost fields in the InvcDtl table. Has anyone else run across this and how do you handle it.
Keith, I’m going to ask a question mainly because I haven’t understood all the concepts of invoice detail costs and how/if they post to a GL, but if this is purely notational, you could use a UD Table and use the Number01 column to house an invoice number and Number02 an invoiceline and then a decimal field to house your MaterialCost that you wish for it to have and then join that UD table to whatever report or query that you have on those two key columns and do a case when UDTable.MtlCostField is 0 then use InvoiceDtl, etc.
Or you can try and understand why it’s not posting to the invoice. You could try and make a datadirective or BPM to flag when it doesn’t happen and shoot you an email. Hopefully there are others here who have had the same issue and can actually give you an answer to this instead of troubleshooting tips like me.
Hi Keith,
We used to run into this occasionally - it had to do with the timing between invoicing and job closing/costs posting. You can try running the Sales Gross Margin report. It updates the Invoice Detail costs for any timing issues. I ended up running it on a daily schedule off hours and it resolved our issues.
Jenn
I feel like I knew this at one time, but recently I was asking myself why the “changed by” and “ChangeDate” on a bunch of already-posted invoices from the past were updated.