Skip to Content
0
Jan 12, 2023 at 12:53 PM

Issue with table connection

188 Views Last edit Feb 06, 2023 at 09:40 AM 2 rev

Please maybe someone can help with my issue.

I load two tables:

1. the first one line with material, material desc.etc., the field Fraction Weight is as measurement;

2. Vendor nr., vendor name, quantity, in the same table we material number, in this example we have 2 lines for the same material.

In BO I combine both tables and merge unique field "Material" and that I see both vendors in this table below, Vendor nr. and vendor name made as Qualif. - Detail Material.

Question and where I made mistake - why Fraction Weight system show only for the one vendor, not for both? Due to this look like field "Kg" is not calculated, because Kg = (Fraction Weight * Quantity)/1000. Where can be the problem?

image.png

Attachments

image.png (23.5 kB)