UD table join to another table issues

Kinetic ERP
1

I’m not sure I’ve actually had a need to link a UD table to another table inside of the BAQ, but when I try it it gives me an sql error. Anyone else have it do that or do I need to do something special in get this to work?

I did this a lot in E-9 before we converted way back, and realized I didn’t have any BAQs in kinetic/E-11 that is actually connecting tables to a UD table. I’ve used the standard and re-written the baq several times, using the company to company and key1 to the proper field in another table. This scenario is just using a UD table to store weight in some number fields & the pack ID in Key one that packID in a master pack detail table is the DtlPackNum.

image
image981×171 6.08 KB

2

You have to make sure you link on the same datatypes. The Keys in UD tables are all strings. So you have to convert your numbers to a string to link it. It is a trickly little gotchya. But you should be able to cast it as an nvarchar. You may have to write that expression right in the join field where it says “MasterPackDtl field or and expression”

1 Like
3

That worked thanks.