Bartender prints three different labels instead of one

Epicor ERP 10
1

I have setup the Epicor autoprint functionality to print a label using bartender based on a change in the PartTran table.

I can’t explain the printed output:
I get three labels: the first one is blank, except for the formatting. The headers, lines, and logo are the only thing on the label; no dynamic data. The second label to print has all of the first, but now it fills in the db field names in the places I wanted data. The third label to print is perfect; it has all the lines, headers logo, and actual data in the right spots.

Does anyone know what is going on and how to fix this?

Thanks!

2

Are you using drop files? What do they look like? Sounds like you have an extra line or two. When you try to print out a same label directly from bartender, does it print correctly?

3

If you are using a “Bartender Report” in your report style is the RDD correct? If the RDD is returning more rows that Bartender expects it may be using additional Rows returned by the RDD as extra labels.

Perhaps your execution rule in your Auto Print Action is set incorrectly.

Let us know how you get on Paul, I’m curious.

4

I’d first make sure you turn off your labels, that should solve one issue. Next, Hally may be correct about your conditions.

Mark to ExcludeLabel on your fields in RDD
image

5

@Chris_Conn I’m thinking that ExcludeLabel column could get confusing :slight_smile:

6

So I am following what others are currently doing in the group; I need a Material Issue Tag to appear as soon as we issue a part from STK to MTL.
I have a Std Data Directive that uses AutoPrint to Bartender and sends data from Part, PartTran, and Company to a network folder that Bartender is watching.
I’ll jump on the label settings next, as I unchecked both for each option I wanted in my dataset.

7

Not so good to set all the “Exclude Label” checkboxes checked… I checked a few other fields along the way and the result was that the PartNumber barcode disappeared from my label. Since it all became a bit messy I thought it would be a good idea to start from scratch, only to end up with no more .bt file generating upon MTL Issue.

So this is what I have; feel free to point out what I am missing or things to try…

Report Data Definition, Report Type: Bartender Labels. I created this as a copy of GenInv.
I have three tables; Report, Part, PartTran

image
image.png857×281 15.7 KB

image
image.png855×314 16.5 KB

image
image.png832×769 26.9 KB

I have linked PartTran to Company and Part, on both links the Relation Type is “Definition Only”

I have a Standard Data Directive on PartTran:

image

With an AutoPrint instruction:

image

image
image

And finally, here is the report style I created:

image
image.png872×597 22.5 KB

I would love to get your input on this…

Thanks!

Paul

8

Try your rule again by selecting the right Style, in the BPM Window once you click on the Auto-Print node on the bottom click on GenInv and it will let you select the right style which will also bring with it the right RDD.

2018-10-09_1524
You have the wrong Style selected.

2018-10-09_1527

once you select the right style you will have to redo your “specified options”

9

OK; I made the correction. It shows the right style and Data Definition now, but still no data as I issue a MTL:

image

10

Question, which screen is the user in, when this Label should be Invoked? Job Receipt Entry?

11

Inventory Mgmt / General Operations / Issue Material

12

So the Auto-Print rule triggers right, your .csv just does not contain data?

13

Here is how mine looks like for MFG-STK

2018-10-09_1544
2018-10-09_1544.png1161×735 146 KB

2018-10-09_1548
2018-10-09_1548.png705×313 11.2 KB

2018-10-09_1548_001
2018-10-09_1548_001.png698×375 13.6 KB

14

I don’t get .CSV’s specifically; I used to get .BT files that would get picked up by bartender. But the .BT files are really .CSV’s… if that is what you meant.

15

Can you open the .BT file and look at it? What do you see there? It would be a good way to track down whether it’s an epicor problem, or a bartender problem.

16

Below are the contents of one of the .BT files it produced prior:

%BTW% /AF="\EPAPP01-BPA\reports\MTL_Issue_Tag_BPA.btw" /D="" /PRN="\EPAPPSA-BPA\gx420d-2-bpa" /DBTEXTHEADER=3 /R=3 /P
%END%
“_PartTran_RptLanguageID”,"_PartTran_AssemblySeq","_PartTran_AssemblySeq2","_PartTran_BinNum","_PartTran_BinType","_PartTran_Company","_PartTran_ContractID","_PartTran_CostID","_PartTran_CustNum","_PartTran_EmpID","_PartTran_EntryPerson","_PartTran_JobNum","_PartTran_JobSeq","_PartTran_JobSeq2","_PartTran_JobSeqType","_PartTran_MatNum","_PartTran_OrderLine","_PartTran_OrderNum","_PartTran_OrderRelNum","_PartTran_PackLine","_PartTran_PackNum","_PartTran_PackSlip","_PartTran_PartDescription","_PartTran_PartNum","_PartTran_Plant","_PartTran_POLine","_PartTran_PONum","_PartTran_POReceiptQty","_PartTran_PORelNum","_PartTran_RevisionNum","_PartTran_SysDate","_PartTran_SysRevID","_PartTran_SysRowID","_PartTran_SysTime","_PartTran_TranClass","_PartTran_TranDate","_PartTran_TranDocTypeID","_PartTran_TranNum","_PartTran_TranQty","_PartTran_TranReference","_PartTran_TranRefType","_PartTran_TranType","_PartTran_UM","_PartTran_WareHouseCode","_PartTran_DimCode_DimCode","_PartTran_DimCode_DimCodeDescription","_PartTran_PartLot_LotNum","_PartTran_PartLot_PartLotDescription","_Company_RptLanguageID","_Company_Company","_Company_Name","_Company_SysRevID","_Company_SysRowID","_Part_RptLanguageID","_Part_Company","_Part_IUM","_Part_LinkToContract","_Part_PartDescription","_Part_PartNum","_Part_SysRevID","_Part_SysRowID"
“”,“0”,“0”,“ELEC-CART1”,“Std”,“BPA”,"",“1”,“0”,“804”,“psiebers”,“057052-2-1”,“60”,“0”,“M”,“0”,“0”,“0”,“0”,“0”,“0”,"",“SERVO MOTOR A-B MPS-B330P-SJ52DA MPS-B330P-SJ52DA Bulletin MPS - Stainless Steel Servo Motors Product460 V Frame Size 3 = 100 mm (3.94 in.)Stack Length 30 = 76.2 mm (3.0 in.) 5000 RPMSingle-turn High-resolution Encoder. Keyed Shaft Extension Circular DIN Connector on 3 Meter CableNo Brake IEC MetricTapped Mounting Holes (Type FT) Torque 3.6 LB-IN","1023-442","VA","0","0","0","0","A","10/9/2018 12:00:00 AM","942473761","bfdb3811-e1ad-4b3a-94a7-a806bd443e22","35865","I","10/9/2018 12:00:00 AM","","735609","1.00000000","","0","STK-MTL","EA","VA","","","","","","BPA","BluePrint Automation Inc.”,“829369918”,“6cc38fa3-22bd-440a-a772-447f795ff745”,“enu”,“BPA”,“EA”,“False”,“SERVO MOTOR A-B MPS-B330P-SJ52DA MPS-B330P-SJ52DA Bulletin MPS - Stainless Steel Servo Motors Product460 V Frame Size 3 = 100 mm (3.94 in.)Stack Length 30 = 76.2 mm (3.0 in.) 5000 RPMSingle-turn High-resolution Encoder. Keyed Shaft Extension Circular DIN Connector on 3 Meter CableNo Brake IEC Metric` Tapped Mounting Holes (Type FT) Torque 3.6 LB-IN”,“1023-442”,“729253354”,“89005f4a-0a79-4edd-ba87-74226b7bb37b”

17

Look over my settings above, everything else you have looks good.

Curious do you have a space here? or is that just how it looks like:
2018-10-09_1552

Give me a screenshot of your RDD Relationships :slight_smile:

1 Like
18

I tried that route in the beginning as well. Let me plug it in and see if it works this time around.

19

If you use that file as your template file in bartender does it print the label correctly. (Does Epicor supply the bartender template files???)

20

WHOA! It was the space!!! Actually two. I entered that clause using the gui keypad on the menu instead of my keyboard, and it verified as well… Good eye!

Thanks!

Paul

1 Like