on 03-10-2019 6:14 AM
Hola,
soy nuevo en esta comunidad, quisiera pedir su ayuda puesto que quiero en el consultor de datos (SQL) quisiera saber de un rango de fechas cuantos articulos se vendieron y cual es su precio de costo y venta para determinar la ganancia.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Check this for general idea
SELECT Distinct T0.DocNum 'Invoice#', T0.DocDate, T0.DocDueDate,
T0.GrosProfit, T1.ItemCode, T1.Quantity, T1.Price 'Sales Price',
T1.GrossBuyPr 'Purchase Price' , T1.[GrssProfit] AS 'Row Gross Profit'
FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry
Regards:
Balaji.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.