I need some help with a report called in spanish “Informe operaciones num. serie”.
I want to create this report in SQL Server but i dont find the logic between tables, and the virtual tables dont help a lot to my cause.
Could someone help me with the sintaxis of this report please. All that i wanto to know all the moves of all the serial numbers including the field “Sentido” (Entrada, Salida, Asignación, etc.)
The report in Sap Business One is the following: