Unable to bill Description Direct Items in Work Order Billing
Hello, we often purchase description direct items for work orders and we need to bill the cost of these items. We just started using EAM Work Order Billing and up until now, we hadn't had a Description Direct to test.
What I noticed is this:
1. The 4th union clause of the eam_bill_by_requirements_v view is there Description Direct items are queried (edirv.direct_item_type_id = 1)
2. The query has a join that fails every time: AND msi.inventory_item_id = wep.bill_inventory_item_id
wep is the wip_eam_parameters table.
Here's the entire query from the 4th union clause of eam_bill_by_requirements_v: