I am looking to print a label when Inventory transfer occurs. Right now I am using the condition when a record is inserted into Parttran table and the Trantype = ‘STK-STK’ and TranQty >= 1. I can generate the bt file from it. [image] I also want to map the Bin location on the label, which reside…

Atul, would you consider marking this post as the solution though, we’ve been through a lot. I am more than happy to keep helping you, but lets not let this thread turn into a month long project. [image] Bartender Label for Inventory Transfer Kinetic 202X So after all tha…

Make a new report style that references this copy you just made and print the label and see how the output file looks. Keep the relationships for now. Validate that the data is good for you and that you even need to worry about the relationships before you go and modify relationships.

@atuljainajm @Mark_Wonsil asked you a question. Does this part even have bins set up Atul?

That is, if you whipped up a quick BAQ, dragged PartBinInfo into it with all columns selected, how many records do you get?

MArk, I see that it doesn’t have to do with kanban though necessarily, but yeah @atuljainajm first and foremost does the record you are looking for even exist in partbininfo? Like if you look in partbininfo and search the table for your part, do you see any rows coming back?

I see that you’d only create these bins if you were attempting to do Kanban though Mark

[image] utaylor: MArk, I see that it doesn’t have to do with kanban though necessarily, PartBin and PartBinInfo “On Hand Qty” don’t match - ERP 10 - Epicor User Help Forum (epiusers.help)

That’s the output after filtering out the results which making any changes to data sources or relationships: [image] Just need to map partbininfo table i guess. Thanks

I guess what I am getting at is you can create entries in that table without setting it up fully. [image]

Okay, do you see the bin that you are interested in when you look at that data set? Write to me the label of the company, part number, the warehouse that the bin is in and the bin number itself. Write me the labels of those fields Atul, not the values, but the labels for those fields. All from your…

@atuljainajm for example Atul, if you see the TO BIN in your dataset, give me the field label for it. For example, “PartBin_BinNum” or whatever the appropriate label for the exact field is. I’ll be around when you get back to this, let me know. We are close! However, to @Mark_Wonsil 's point, if yo…

Bartender Label for Inventory Transfer

Kinetic ERP

Mark_Wonsil (Mark Wonsil) October 11, 2023, 4:04pm 28

PartBin and PartBinInfo “On Hand Qty” don’t match - ERP 10 - Epicor User Help Forum (epiusers.help)

Topic		Replies	Views
Reduce number of fields in Bartender file Kinetic ERP bpm , bartender	22	988	October 10, 2023
Creating Barcode Labels For Inventory Kinetic ERP e10	65	3321	August 27, 2025
Bartender Issue - GenInv on PartTran Kinetic ERP bpm , customization , reports , cloud	3	1013	November 20, 2021
Bartender prints three different labels instead of one Epicor ERP 10	37	7172	October 9, 2018
Bartender Receipt Label - Need multiple labels Kinetic ERP	5	1893	November 29, 2023

Bartender Label for Inventory Transfer

Related topics