Nota de Entrada x Lotes de produtos - Incoming Invoice x Product Batches/Lots

[Ederson]

Alguém já desenvolveu uma consulta que traga as notas fiscais de entrada onde apareça o item e o seu lote? Por exemplo, quero digitar o lote de um produto na cláusula WHERE e ele retornar as notas fiscais referentes.

Sei que o relatório de transação por lotes só aparece pelo documento de recebimento, e estou com dificuldades para criar o relatório.

English: 

Has anyone already developed a query that retrieves incoming invoices showing the item and its batch/lot number? For example, I want to enter a product's batch/lot number in the WHERE clause and have it return the relevant invoices.

I know that the batch/lot transaction report only appears by the receipt document, and I'm having trouble creating the report.

[SonTran · Accepted solution]

Hi,

You can refer this for the same

https://forum.sapb1.vn/community/inventory/tips-truy-van-thong-tin-batch-number-duoc-mua-ve-tu-phieu...

***There is a translation widget at the top right corner in my forum.

Hope this helps,

Son Tran

[Ederson · Accepted solution]

That's exactly what I needed, thank you so much!!