Transaction query bacth number of OINV and INV1 table relation

[Former Member]

Hi ..

SELECT T1.DocDate, T1.CardCode, T1.CardName, T1.NumAtCard, T2.Quantity, T2.Dscription, BATCH_NUMBER
from OINV T1 INNER JOIN INV1 T2 ON T1.DocEntry = T2.DocEntry
WHERE T1.CANCELED = 'N'


How does query show sales transaction from OINV and INV1 table with batch number ??
please help to complete the query with other tables.

Thank you in advance.

[ANKIT_CHAUHAN]

Hi Rizky wawan,

Adding to the Edy's Reply mentioned above:

Always try to search the existing threads before creating your own question. Try to search with "batch number in sales invoice query in sap business one" and you will get a lot of discussions about it that are already there. Here is a thread which might help you:

Batch in Sales Invoice

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[edy_simon]

Hi Rizky,

Batch/Serial Numbers are not stored in INV series table.

Please look into the OITL and sub tables + OBTN

Regards
Edy