Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

Cordial Saludo:

Comparto con ustedes este reporte que muestra los impuestos realizados por documento.

SELECT T0.[DocDate], T0.[DocNum], T0.[CardCode], T0.[CardName], (T0.[DocTotal]-T0.[VatSum]+T0.[WTSum]) as 'Sub Total', T0.[VatSum], T0.[WTSum], T0.[DocTotal] FROM OINV T0 WHERE T0.[DocDate] between [%0] and [%1]