How to set up BPM conditions to AutoPrint Part Labels based on Location in Data Directive

[ZanebK]

Hi,

I have created a Data Directive on the PartTran table, which auto prints part labels when a stock transaction happens (e.g. ‘MFG-STK’, ‘STK-STK’).

I have added conditions to print to a specific printer based on the Warehouse/Bin Number:

Condition 1: Transaction Qty is more than 0 and Bin Number begins with ‘M’

• If True, prints to Printer_A
• If False, moves to Condition 2.

Condition 2: Transaction Qty is more than 0

• If True, prints to Printer_B
• If false, ends

The issue I’m having is that, when we move stock from an ‘M’ bin (e.g. “M100”) to a non ‘M’ bin (“B100”), it is still printing to Printer_A when it should be printing to Printer_B.

I investigated the transactions, which have Transaction type ‘STK-STK’. I see in the Part Tran table that ‘STK-STK’ creates two transactions:

• A minus qty transaction in the original M location (M100)
• A plus qty transaction in the new location (B100). (My conditions should exclude the minus transaction).

I then tested moving the stock back from the B100 bin to the M100 bin. Again, it still prints to Printer_A. So both scenarios are validating condition 1 as ‘true’.

Would be grateful for any guidance on where my logic is going wrong.

Thanks in advance!

[itsme (Rhythem Prajapati)]

@ZanebK

The issue I’m having is that, when we move stock from an ‘M’ bin (e.g. “M100”) to a non ‘M’ bin (“B100”), it is still printing to Printer_A when it should be printing to Printer_B.

I believe you are using a different field based on your requirement.
There are 4 fields: PartTran.WarehouseCode and PartTran.BinNum work as “From Warehouse” and “From Bin”
And PartTran.Warehouse2 and PartTran.BinNum2 work as “To Warehouse” and “To Bin”.

Probably, change your field under Condition1 to Bin2 and check, that should help.

[ZanebK]

@itsme

Probably, change your field under Condition1 to Bin2 and check, that should help.

I tested this but the problem is that it doesn’t seem to matter which way round the ‘To’ and ‘From’ bins are.

I tested two move transactions:

1. Bin ‘From’ = M101 and Bin ‘To’ = B101
2. Bin ‘From’ = B101 and Bin ‘To’ = M101

In both cases, it is validating ‘Condition 1’ as true.

@ZanebK

Condition 1: Transaction Qty is more than 0 and Bin Number begins with ‘M’

I think it has something to do with the fact that, during a single stock move action, two transactions are created in the PartTran table (positive and negative qty) like so:

Qty: -1, BinNum = M101; BinNum2 = B101
Qty: 1: BinNum= B101; BinNum2 = M101

I tried to put a condition in to select the record where Qty > 1 but that doesn’t seem to work

[itsme (Rhythem Prajapati)]

I guess the issue is when condition is being checked.
TranQty is a decimal field and it cannot be compared with a string expression.

Create a variable for string, use “Set Argument/Variable” widget to set tran qty value to this string

And put this condition:

This should help!

[ZanebK]

@itsme

TranQty is a decimal field and it cannot be compared with a string expression.

Hi, thanks for your reply. In this case, I have the expression set as 1 (and not “1”) - wouldn’t this been seen as an integer and not a string value?

If I convert TranQty to a string value, then I am not sure if the ‘greater than’ condition will work, when comparing this number to my expression.

[cjwright (Chris Wright)]

ZanebK,
Did you have any luck with fixing this? I’m running into the exact same issue. I have not found a way to filter out the negative quantity record to prevent the label from coming out twice. Thanks.