Hi,
With Sage X3 v11 & SEI, I'm trying to join the SINVOICED table with STOJOU using SOHNUM_0 and VCRNUMORI_0 to get the product lot number for each invoice. The only issue is that 1 sales order can have multiple stock journal entries but only 1 invoice (one-to-many), I have tried a left join but the invoice lines get automatically duplicated by the number of stock journals.
Any idea how I can get the lot number maybe from a different table ?
Best regards,
Tarik
