I need a sanity check on how the Costed BOM Inquiry should work. Since I am using Advanced BOM, the default BOM DISPLAY CONTROL is "By Revision", and I would expect to see the current material cost for the current Revision as of the current date. What I am seeing is the material cost for the current Revision, but as of the Revision's EFFECTIVE DATE. I do not understand the logic in having the EFFECTIVE DATE default to the Revision's EFFECTIVE DATE instead of the current date, since the majority of the time you want to see the current cost. To insure the current cost is displayed, you have to either change the EFFECTIVE DATE or switch the BOM DISPLAY CONTROL to "By Date", which defaults to the current date. In the examples below it is obvious the first one has an issue, but we have BOMs with hundreds of components and those are sometimes not so obvious. I realize this may sound trivial, but I routinely need to remind people to change the date.
Assuming the way this report behaves is by design, is there any way to change the default BOM DISPLAY CONTROL to "By Date" or have the EFFECTIVE DATE default to the current date?
Thanks, John
At the time of Revision creation, newly created components are awaiting costing info, so $0 cost in first example.