on 11-01-2010 8:55 PM
He estado revisando los informes y query de SAP Business One pero no logro localizar Reportes que me muestre el estado de cuenta de algun proveedor o de algun cliente, es decir que me traiga todas las facturas con sus cobros o pagos con las retenciones de iva e impuesto sobre la renta realizado a la factura, las notas de credito y debito asociada a la factura si existiesen y los adelantos realizados si hubieren.
Te envio un store que desarrolle, el cual me visualiza el estado de cuenta por cliente, me muestra el total en soles y en dolares en columnas distintas
Si deseas que te muestre el estado de proveedores solo varia el store.
Espero te sirva,
[CODE
ALTER PROCEDURE [dbo].[SBO_SP_VTH_EstadoCuentaFLETES]
AS
BEGIN
select
'Facturado' as TipoDoc, OINV.CardCode as CodigoCliente,
OINV.CardName as RazonSocial,
Sum(DocTotal - PaidToDate), Sum(DocTotalFC - PaidFc) as 'TOTAL SOLES',
Sum(OINV.DocTotalFC)-Sum(OINV.PaidFC) as TotalDolares,
'0' as TotalSoles,
'1' as Orden
FROM OINV
Where (OINV.canceled = 'N' and OINV.DocStatus = 'O' --AND OINV.DOCCUR = 'US$'
and (OINV.U_BPV_SERI = '009-01' OR OINV.U_BPV_SERI = '009-03') and OINV.U_VTH_ARROZ in ('FLETE') and OINV.DocTotalFC > 0)
OR
(OINV.canceled = 'N' and OINV.DocStatus = 'O'
and (OINV.U_BPV_SERI = '009-01' OR OINV.U_BPV_SERI = '009-03') and OINV.U_VTH_ARROZ = 'NO' and OINV.DocTotalFC > 0)
Group By OINV.CardCode, OINV.CardName
UNION
select
'Facturado' as TipoDoc, OINV.CardCode as CodigoCliente,
OINV.CardName as RazonSocial,
Sum(DocTotalFC - PaidFc), Sum(DocTotal - PaidToDate) as 'TOTAL DOLARES',
Sum(OINV.DocTotal)-Sum(OINV.PaidToDate) as TotalSoles,
'0' as TotalDolares,
'2' as Orden
FROM OINV
Where (OINV.canceled = 'N' and OINV.DocStatus = 'O' --AND OINV.DOCCUR = 'SOL'
and (OINV.U_BPV_SERI = '009-01' OR OINV.U_BPV_SERI = '009-03') and OINV.U_VTH_ARROZ in ('FLETE') and OINV.DocTotalFC = 0)
OR
(OINV.canceled = 'N' and OINV.DocStatus = 'O'
and (OINV.U_BPV_SERI = '009-01' OR OINV.U_BPV_SERI = '009-03') and OINV.U_VTH_ARROZ = 'NO' and OINV.DocTotalFC = 0)
Group By OINV.CardCode, OINV.CardName
UNION
select
'En Pedido' as TipoDoc, T0.CardCode as CodigoCliente,
T0.CardName as RazonSocial,
Sum(DocTotal - PaidToDate), Sum(DocTotalFC - PaidFc) as 'TOTAL DOLARES',
'0' as TotalSoles,
Sum(T0.DocTotalFC-T0.PaidFC) as TotalDolares,
'3' as Orden
FROM ORDR T0
Where T0.canceled = 'N' and T0.DocStatus = 'O' and T0.DocTotalFC > '0'
and T0.U_VTH_ARROZ in ('FLETE')
Group By T0.CardCode, T0.CardName
UNION
select
'En Pedido' as TipoDoc, T0.CardCode as CodigoCliente,
T0.CardName as RazonSocial,
Sum(DocTotal - PaidToDate), Sum(DocTotalFC - PaidFc) as 'TOTAL DOLARES',
Sum(T0.DocTotal-T0.PaidToDate) as TotalSoles,
'0' as TotalDolares,
'4' as Orden
FROM ORDR T0
Where T0.canceled = 'N' and T0.DocStatus = 'O' and T0.DocTotalFC = '0'
and T0.U_VTH_ARROZ in ('FLETE')
Group By T0.CardCode, T0.CardName
Order By RazonSocial--, Orden
END
CODE]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola que tal?
Te servirá el Diario de documentos? o Libro Mayor?
Finanzas-Informes financieros-Finanzas?
saludos.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Puedes construir una consulta de usuario para este informe, acá en Chile al menos existe un add-ons que te entrega mas o menos este informe, claro que esta no es la función principal de este add-ons, sino lo trae más que nada como un plus.
slds.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola que tal.
Desafortunadamente no hay un informe nativo tan detallado como el que tu necesitas, ahora bien lo que puedes hacer es ir a SOCIO DE NEGOCIOS/INFORME DE SOCIO DE NEGOCIOS/ANTIGUEDAD/ANTIGUEDAD DE SALDOS DE CLIENTES O PROVEEDORES (POR SEPARADO). ahi le das el rango de fecha y ten presente pinchar los casilleros de "visualizar clientes con saldo cero" y "Visualizar operaciones reconciliadas" para que no te cambie el saldo de la cuenta, ademas si quieres ver en mas detalle algun socio, en el informe ya generado le haces doble click.
Espero te sirva, saludos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
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.