BPM for ReciptsFromMFG

[vfeldt (Valorie)]

We want to create a BPM that will stop a user from receiving the part to stock if it is a NonInventory Item. If it is a make to order job we don’t want it in inventory. I had thought the way to go would be a method directive (Pre-Process) on the ReceiptsFromMfg. I got this from the trace, but I can’t figure out how to connect the receipt in a query to the PartFile to check for the NonStock condition is true.

I know very little about BPM’s and I’m not a coder so I’m struggling to figure out how to make the connection in the BPM condition.

[Fernando]

I’ve had to do similar conditions on a BPM, one thing that worked for me was create a condition and connect it to a exception. The condition is “MyQuery is more or equal to 1”

On the query itself, join the temp table to the Part Table and add a condition of “NonStock = true”
The tables joins would just be company to company & partnum to partnum.

Note, haven’t tried this exact scenario but its worth giving it a shot here.

[Doug.C (Doug Crabtree)]

Be careful when you do this, that condition block can cause serial number issues due to a bug in Epicor.

First Serial Numbers in Receipt Entry Disappears

It is the presence of a condition block as the first step in the BPM. I needed to do a condition block, so I ended up using a code widget and wrote my own. As soon as I did that the first S/N issue disappeared. In our case it was seemingly random. We would receive qty X parts, and only qty X-1 serial numbers were created. It caused some funny SN Transaction numbers as well. Putting a code block in for the initial check allowed me to set a variable which I could then check in a conditional …

[vfeldt (Valorie)]

I actually tried that first, so I guess I shouldn’t feel so bad, but this is the error I keep running into. It’s doesn’t seem to be making the connection.

[Fernando]

Yeah I got that error at first too, you need to do lower case true. so ( NonStock = true )

[vfeldt (Valorie)]

Thanks! That got rid of the error but it’s not firing the exception.

[Fernando]

What method are you using out of curiosity?

[vfeldt (Valorie)]

Thank you Doug - I will likely need to tap our consultant to help write the custom code. Many of our nonstock items serialized so this is a concern. Appreciate it!

[vfeldt (Valorie)]

I’ve tried several - the trace showed me GetNewReciptsFromMfgJobAsm (i’m not great at reading the trace files) after your post I tried GetNetReciptsFromMfg - still no luck.

[Fernando]

The last one I’d try is ReceiveMfgPartToInventory but to Doug’s point, be cautious of that bug, I wasn’t aware of it prior to making a suggestion. Good luck!

[vfeldt (Valorie)]

Thanks for your help! I’ll post when I get a solution.

[vfeldt (Valorie)]

That did the trick! it’s working. Now we are going to do some testing for the serial number issue. We don’t assign serial numbers until the time of shipment and as I understand it, they manually put in the starting and ending numbers so I think we may be ok on this…

Thank you both for your help!
val

[SAD (Sergey Davydkin)]

BPM Queries are not BAQ. They are C#-based. So you have to use valid C# literals.
In the case of boolean fields, they are false and true in lower case.
False and True in Pascal case are VB.NET literals.

[Fernando]

Yup, I noticed that a while back when the first time I used a BPM Query, I had to do " " on a string and same with lower case true or false for Boolean. Thanks for confirming that!