BAQ with a nicer display of part numbers

Epicor ERP 10
,
1

Hello,
I am pretty new to creating BAQs and work in a company that I’m trying to coerce into using Epicor a little better.

Step one of this is making a BAQ to replace our current process of generating a past due list. I have the mass majority of what I want, and actually replicate what the foreman currently uses, but I want to take it a step further.

I am trying to separate assembly parts out, I have added a calculated column to show the assembly sequence. It’s “calculated” with a simple statement as follows
case
when JobAsmbl.AssemblySeq = 0 then NULL
else JobAsmbl.AssemblySeq
end

This is just so that there is a break in the table and it doesn’t feel like a wall of text. I wanted to do the same thing with the assembly part number where it leaves the cell blank when the assembly part number is the same as the base part number. For one reason or another it isn’t working for me… Any help would be appreciated, as right now it displays the part number instead of a blank cell
LateJobs-OpList.baq (56.1 KB)

2

In your BAQ, you have:

case 
    when JobAsmbl1.PartNum= JobAsmbl1.BasePartNum then NULL
    else JobAsmbl1.PartNum
end

Why not do the same thing as the AssemblySeq? I’m pretty sure the BasePartNum isn’t what you think it is… Are you thinking it was the part number of the job? The description on it says it’s the configurator part number (only used with the configurator). I tried the below and it does what you’re expecting it to do.

case 
    when JobAsmbl1.AssemblySeq=0 then NULL
    else JobAsmbl1.PartNum
end
3

You can use this calculation at the top level:

iif(JobAsmbl.PartNum=JobHead.PartNum, '', JobAsmbl.PartNum)

@dr_dan is right, that base part num isn’t what you think. Just compare the job asm part to the job head part.

4

You are correct, thanks for the help. I will have to be a little more diligent in reading the descriptions.

5

This follows the thought process I was aiming for when generating the report. Thanks for the clarification.