Still Cant connect an Invoice item to batch number
8.80.236 PL 18 HOTFIX1
I thought I got this answered but it is still illuding me.
I still cannot make the connection between INV1 and the correct record in OBTN for a crystal report.
Table: INV1 Field: DocEntry Value: 234
Table: INV1 Field: LineNum Value: 0
Table: INV1 Field: ItemCode Value: Product A
Table: INV1 Field: Quantity Value: 2
Table: OBTN Field: ItemCode Value: Product A
Table: OBTN Field: DistNumber Value: Product A-0001
Table: OBTN Field: MnfSerial Value: Product B-0002
My issue is that besides the ItemCode and Date fields in both tables there is no specific link to a batch. If the Itemcode in OBTN has 2 records then there is no way of telling which batch the INV1 came from because it will link to both records in OBTN.
Simular issues arise with OBTQ OBTW OITL ITL1