I have a BAQ where I am pulling the ReasonCode from the LaborDtl table for SCRAP. I would rather pull the Reason Description for the ReasonCode. I have tried many ways but can’t seem to access them.
Any help would be much appreciated!
I have a BAQ where I am pulling the ReasonCode from the LaborDtl table for SCRAP. I would rather pull the Reason Description for the ReasonCode. I have tried many ways but can’t seem to access them.
Any help would be much appreciated!
Hi Judy,
You’re almost there. Just add the reason code table and join by company and reason code to pull description.
Have fun!
When pulling reason descriptions from Reason table, Reason Code isn’t always enough.
May need to link ReasonCodes and specify the ReasonType.
Reason.ReasonType codes
“S” - Scrap
“R” - Rework
“M” - Inventory Adjustments
“A” - RMA
“D” - DMR
“Q” - Quality Assurance
“C” - Service Calls
“W” Win CRM
“L” - Loss CRM
“T” Task CRM
“H” - Part On Hold
“E” ECO Task
“H” HelpDesk
“C” Service Call
“U” Course Result
"“F” Field Service Contract
Some reasons have references in EntityGLC too
e.g. EntityGLC.RelatedToFile = “Reason”
Thank you - that was it. I had put the Reason Code table in but I had Company and a different Table Relation. Your instructions worked like a charm. THANK YOU SO MUCH!