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.
I also want to map the Bin location on the label, which resides in Partbininfo table.
I want to link the bin location to the part which is being transferred and print it on the label.
What happens when you have multiple STK-STK transactions in your table that have a quantity >=1?
Move the part from one bin to the other again.
Are you familiar with customizing Report Data Definitions? You can add the PartBinInfo table to your datasources and select the field(s) you want to display. They will then be included in the output bt file that is sent to BarTender.
Also, to @utaylor’s point, you may consider using a BPM on the ‘Erp.BO.IssueReturn.PerformMaterialMovement’ method, instead of a data directive on PartTran.
Hi @andrew.johnson ,
when I join partbininfo to part with relationship type as definition only.
If you are wanting to display the bin description, I think you will want the WhseBin table, not PartBinInfo.
You may also consider using the ‘Linked Tables’ feature. It is a good way to get related fields without having to create extra tables and relationships. Try the Linked Tables tab on the PartBin table.
Atul, how many records in part tran do you see that match the join that you have and the criteria? 2?
@andrew.johnson
I have a custom field “Partbininfo.Character01” in Partbininfo table which I want to use.
@utaylor
These are the current relationships, total of 3.
Atul,
When you join part tran to part on company and partnumber fields you are saying, give me all of the transactions for this part.
Do you want all the transactions for the given part?
Unless you’re using KanBan, Kinetic will not create any PartBinInfo records. To my knowledge, that’s the only purpose for PartBinInfo.
@utaylor
What do you mean by all transactions of the part?
I just need one transaction that’s shown in the file.
Does that answer your question?
Thank you.
I mean, the parttran table holds all transactions for a part. That’s what I mean.
If you only want the transaction that is shown in the file, the base file, not your modified one, then why are you joining part tran to your file?
Remove part tran since you have already said that you only want the transaction for the label. There’s no need to bring in more transactions at this point.
Atul, in the original dataset, not your modified one, can you identify the bin that you want more info on?
Please use the base rdd and base form at this point, we need to start over with the joins.
